One more way . filename tmpfile1 'c:\temp\a.txt';
data want;
infile tmpfile1 dsd truncover lrecl=32000 ;
input col1 : $40. temp : $40. @;
do until( missing(temp));
zcode = substr(temp,1,5);
srcval = substr(temp,6);
output;
input temp : $40. @;
end;
keep col1 zcode srcval ;
run;
Ksharp
... View more