I have a CSV file where some records end with CR, and other records end with CRLF. Luckily, there are no embedded CR or CRLF.
So file is like below (actual file has pipe-delimited records with variable lengths, variable number of fields, etc).
1 CRLF 2 CR 3 CRLF 4
I need to read the file using SAS 9.4 on Windows. I had hope that I could specify on the INFILE statement multiple delimiters, something like termstr=CR|CRLF. But seems that isn't allowed. Now I thinking I could just read in the file with termstr=CR, and then remove the LF from the data. Something like:
data want ; infile "c:\junk\have.txt" termstr=CR; input @; _infile_ = compress(_infile_,'0A'x); input x 1. ; run ;
Before I go too far down this path, wanted to ask about possible better alternatives.
That should work.
But are you sure that you don't actually have a file with CRLF as end of line and some string fields with embedded CR values?
Thanks Tom. Yes, pretty sure. : )
Very interesting Question.
How about make LF as a delimiter ?
data x;
infile 'c:\temp\test.txt' termstr=cr dlm='200A'x;
input x ;
run;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.