BookmarkSubscribeRSS Feed
deleted_user
Not applicable
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
2 REPLIES 2
Ksharp
Super User
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
Not applicable
Thanks Sharp..am getting exact output !!!

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 637 views
  • 0 likes
  • 2 in conversation