title: SAS not able to merge two data sets by matching character variables
body: <p>I have two data sets, one imported from .xlsx and one from .csv. I did scan, trim, upcase and all those stuffs to clean up the two data sets. I tried both proc sql and data step to merge the two by a character variable. SAS won't be able to find any match. However, when I export the two data set back to .xlsx and then copy and paste the character column from the two sets side by side. Clearly there are many matches, and Excel also recognizes them being the same (use if statement to check them). </p>
  
  <p>What is going on here? </p>
  
  <p>Thanks!</p>