Thanks for the post Tom. Yes, holding the pointer over might work. The problem is that the data is coming from a large database organization, so we will have many databases, with different strucutures. Even if I had the time to go through each and check what fields this happened in and code around the issue, it should have been noted/fixed before. So I have a ticket in with SAS Support, and I will get back to the DB supplier to see why these specials are being sent in the first place. Not my job to fix commericial products :smileylaugh:
Hi,
Just to finalise this post. Support sent me some code posted below, which is working for me as an intermediary setup.
data _null_;
infile "s:\temp\rob\x.csv" recfm=n;
file "s:\temp\rob\y.csv" recfm=n;
retain Flag 0;
input a $char1.;
if a = '"' then
if Flag = 0 then
Flag = 1;
else
Flag = 0;
if Flag = 1 then
do;
if a = '0D'x then
do;
goto exit;
end;
if a = '0A'x then
do;
goto exit;
end;
end;
put a $char1.;
EXIT:
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.