Please try the FILENAME statement option TERMSTR.
filename sample 'sample.csv' termstr=CRLF;
proc import datafile=sample out=csv replace dbms=csv;
run;
>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?
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: