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.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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: