Txt data with random line breaks

[Emma8]

Hi. I have very large datasets (Csv)—some variables have line breaks —how can I fix those random line breaks when I import into sas?thank you.

[Jagadishkatam]

Please try the FILENAME statement option TERMSTR. 

filename sample 'sample.csv' termstr=CRLF;

proc import datafile=sample out=csv replace dbms=csv;
run;

[Jagadishkatam]

filename sample 'sample.csv' termstr=CRLF;

proc import datafile=sample out=csv replace dbms=csv;
run;

[ChrisNZ]

>some variables have line breaks

This is insufficient information.

Are these LF or CRLF ? How do the breaks show in Notepad++ or in MS Word?

[Patrick]

Having LF in .csv created from Excels is unfortunately not uncommon. Luckily your .csv will most likely use CRLF as actual end-of-line indicator.

If so then using termstr=CRLF in the Infile statement should be the silver bullet for you.

[Ksharp · Accepted solution]

https://communities.sas.com/t5/SAS-Programming/How-to-import-line-feed-or-carriage-return-values-fro...

https://communities.sas.com/t5/SAS-Programming/Reading-Text-File/td-p/657209