topic How to keep only digits when data contents numeric and alphabets? in SAS Programming

How to keep only digits when data contents numeric and alphabets?

rajeshalwayswel — Fri, 08 Dec 2017 10:29:49 GMT

data have;
input a $;
cards;
acc>>>
qe
12.3hjj
78.0
88
run;

Required output;


12.3
78.0
88

I have written in this way:

data have;
input a$;
a1=compress(a,'1234567890.','k');
cards;
acc>>>
qe
12.3hjj
78.0
88
run;

Is there any other way?

Re: How to keep only digits when data contents numeric and alphabets?

PeterClemmensen — Fri, 08 Dec 2017 10:45:19 GMT

you can do this

a1=compress(a,'','kpd');

What do you want to do when a does not contain numbers?

Re: How to keep only digits when data contents numeric and alphabets?

rajeshalwayswel — Fri, 08 Dec 2017 10:49:32 GMT

Missing when it contains character, special characters.

Re: How to keep only digits when data contents numeric and alphabets?

Rickyboy — Fri, 08 Dec 2017 11:34:15 GMT

I would be fine with a missing observation