I have a data set that has quite a few carriage returns. I need a way to write this into sas and not change my initial data. The initial data step that I had was: data companyinfo; infile 'sample.csv' lrecl=2500 firstobs=2 dsd truncover; input VAR1:$3. VAR2:$11. VAR3:$50. VAR4 VAR5:$2. VAR6:$2. VAR7:$550. VAR8 VAR9:$1. VAR10:$3.; run; Where VAR7 is the column that contains CR. I tried termstr=crlf and var7=tranwrd(var7,'0D'x,'') amd have not been able to find a correct result.
... View more