how about:
data _null_;
file "R:/real_data.txt" lrecl=10000;
put '"Turner, Alfred","2A"';
put '"Anandsinh Sindha","4C"';
put '"Arundhati , "tiwari"","1A"';
run;
data test;
dlm=",";
infile "R:/real_data.txt" dlm=dlm truncover;
input @;
_infile_=left(reverse(_infile_));
input V2 :$20. @@;
dlm='0a'x;
input V1 ~$200.;
v1 = left(reverse(v1));
v1 = substr(v1,2,length(v1)-2);
v2 = dequote(left(reverse(v2)));
run;
proc print;
run;
Bart
... View more
