07-12-2011 05:42 AM
I have a csv file with a line break in one of the columns enclosed by ". Am havign trouble importing them to SAS using proc import.Can anyone please help me on this..?
here is an example..
If you observe first row has a new line character in address column and proc import treats it differently..
Am using the below code for import..
proc import datafile = "C:\test.csv" out = test dbms = csv replace; run;
Thanks in advance
07-12-2011 08:02 AM
Sounds like your CSV contains EXCEL hard returns '0A'x, produced by <CNRL>ENTER in EXCEL. You should be able to fix this with the FILENAME statement option TERMSTR. Put your filepath where I have the string 0a.csv
filename FT44F001 '0a.csv' termstr=CRLF;
proc import datafile=FT44F001 out=csv replace dbms=csv;