sql

[deleted_user]

Hi ,

I am having an data set, in that i need to remove all the alpha characters on the output files.Some records have values starts with 25MA07943500ANQ,A119966A85,
,AE209314-C18

I tried this code:
data x;
length provno$ 15.;
input provno$;
cards;
25MA07943500ANQ
25MA07943500BNQ
9096675
800004954-007
A002677-A85
A119966-A85
AT208713-A20
AE209314-C18
A209314-D18
A209314-E18
A209314-F18
;
run;

data y;
set x;
length provno$ 15.;
if anyalpha(provno)=1 then provno=substr(provno,2);
run;

But am not getting an exact output.Please help me on this code.

Thanks in Advance !!!

Raj

[Ksharp]

How about:
[pre]
data x;
length provno$ 15.;
input provno$;
cards;
25MA07943500ANQ
25MA07943500BNQ
9096675
800004954-007
A002677-A85
A119966-A85
AT208713-A20
AE209314-C18
A209314-D18
A209314-E18
A209314-F18
;
run;

data y;
set x;
length provno$ 15.;
provno=substr(provno,anydigit(provno));
run;
[/pre]


Ksharp

[deleted_user]

Thanks Sharp..am getting exact output !!!