Help using Base SAS procedures

How to handle line breaks in csv files

Reply
Occasional Contributor
Posts: 14

How to handle line breaks in csv files

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

Respected Advisor
Posts: 3,777

How to handle line breaks in csv files

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;

Ask a Question
Discussion stats
  • 1 reply
  • 3790 views
  • 2 likes
  • 2 in conversation