I'm importing a CSV file into SAS using INFILE / INPUT, but a special character is causing SAS to skip over the comma delimiter. Previous posts have suggested that I use SAS with Unicode Support, but I still run into the problem. I'm using SAS 9.4 with Unicode Support. My data looks something like this: bill_address1 bill_address2 bill_address3 bill_address4 bill_address5 CS GravÚ 90050 Honfleur 9403 But when I import the data with my code, SAS ignores the comma separator between bill_address2 and bill_address3: The log file didn't output any errors or warnings. My code is below (replacing "[[filepath]]" with the data location) data test;
infile "[[filepath]]\test.csv"
dsd missover lrecl = 32767 firstobs = 2;
informat
bill_address1 $2.
bill_address2 $12.
bill_address3 $12.
bill_address4 $12.
bill_address5 $12.
;
input
bill_address1 $
bill_address2 $
bill_address3 $
bill_address4 $
bill_address5 $
;
run;
... View more