@Tom & @Panagiotis - It *seems* like I do need to 1st copy over the file from SFTP to a local drive in order to be able to use the TERMSTR=CRLF option... However, contrary to my earlier statement of "Yes - I can point to a non-SFTP directory and process the file in the desired manner..." I find that results actually aren't processing in the manner I'd like yet. The picture above, I think, conveys the challenge. I'd like to read the pipe delimited rows from this csv file into one column so that resulting value would look as follows: a|b|c: d thru g|h Instead, I am still getting: using the following approach: data test;
infile "C:\csv containing variable with carriage returns.csv"
firstobs=2
termstr=crlf
truncover;
input row $32767.;
run;
... View more