How to handle line breaks in csv files

[kishore415]

Hi..

   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..

test.csv

name  address

abc,"aaa,

China"

def,"ccc,USA"

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

[data_null__]

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;

   run;