I found this as a working solution. Working on the raw csv in binary format and removing special characters, then simply proc import the new csv. data _null_; infile cdata lrecl=1 recfm=n end=eof; file outdata lrecl=1000000; nq=0; do until (eof or (char='0A'X and mod(nq,2)=0)); input char $char1.; nq=nq+(char='"') ; if char not in ('0D'x,'0A'x) then do; char1 = prxchange('s/[^\x20-\x7E\x0A\x0D]//', -1, char); if missing(char)=1 or missing(char1)=0 then put char1 $char1. @ ; end; end; put ; run; Can someone confirm this and please explain any drawbacks/problems this might cause?
... View more