Help using Base SAS procedures

sql

Reply
N/A
Posts: 0

sql

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
Super User
Posts: 9,681

Re: sql

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
N/A
Posts: 0

Re: sql

Thanks Sharp..am getting exact output !!!
Ask a Question
Discussion stats
  • 2 replies
  • 146 views
  • 0 likes
  • 2 in conversation