How to handle line breaks in csv files

kishore415 — Tue, 12 Jul 2011 09:42:40 GMT

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

How to handle line breaks in csv files

data_null__ — Tue, 12 Jul 2011 12:02:03 GMT

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;

topic How to handle line breaks in csv files in SAS Procedures

How to handle line breaks in csv files

How to handle line breaks in csv files