I have a load of CSV files in with the same layout with the exception of the termstr. Some have CR, the others CRLF. Is there an easy way to import all of these? This is my current code: filename tsvs "/Path/To/Files/*.txt";
data test;
infile tsvs filename=tsvfile dlm=',' dsd missover TERMSTR=CR;
input code:$5. @;
if code='P10' then
do;
fName=scan(scan(tsvfile,-1,"/"),1,".");
input @7 a b c$ d$ e$ f$ g;
output test;
end;
run; This only works for the CR ones. I can then have another code that has CRLF as the termstr and append them together, but is there a way to do it together? Or get SAS to clean the CSVs first? thanks
... View more