Thanks. I am using SAS 9.1.3.
I have successfully solved the problem using anydigit function, using the following commands
char=input(substr(string,1,(anydigit(string)-1)) ,$8.);
num = input(substr(string,anydigit(string)),best.);
then,
proc sort data=test2; by char num;
run;
I figured that could be done with 'SCAN' too ....
Thanks everybody, you have been of great help.
... View more
