12-07-2016 11:30 AM
I read in the CSV file to dataset by using the PROC IMPORT. the UTF-8 specifical character carriage return looks like the single quatation sign ('). I need to remove it form the text variables and keep the normal single quatation sign. please suggest. thanks.
12-08-2016 12:29 AM
data _null_; A="‘a’"; B=translate(A,"''","‘’"); putlog B=; run;
12-08-2016 11:41 AM
I have a number of UTF-8 CSV files and none of them have this behavior. By any chance are you looking at a file generated in a different operating system? You may want to investigate the TERMSTR option for the Infile statement or use a FILENAME with that option to reference for proc import if that is the case.
12-09-2016 11:07 AM