SAS Programming

DATA Step, Macro, Functions and more
BookmarkSubscribeRSS Feed
rajeshalwayswel
Pyrite | Level 9
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?


3 REPLIES 3
PeterClemmensen
Tourmaline | Level 20

you can do this

 

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

 

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

rajeshalwayswel
Pyrite | Level 9

Missing when it contains character, special characters.

Rickyboy
Calcite | Level 5

I would be fine with a missing observation

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 1696 views
  • 3 likes
  • 3 in conversation