topic Re: Txt data with random line breaks in SAS Programming

Txt data with random line breaks

Emma8 — Wed, 17 Jun 2020 22:27:51 GMT

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 — Wed, 17 Jun 2020 22:32:21 GMT

Please try the FILENAME statement option TERMSTR.

filename sample 'sample.csv' termstr=CRLF;

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

ChrisNZ — Thu, 18 Jun 2020 06:06:59 GMT

>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 — Thu, 18 Jun 2020 09:04:58 GMT

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 — Thu, 18 Jun 2020 12:22:53 GMT