HI All,
I have a column which consists of numeric's and some numeric+char mixed.
I'm sorry.I'm looking only for numbers which are available in that column
ex
12345678
ab2345678d
45678ed34
34567289
looking for output:
I looking to get only numeric characters in that column. Can you help me
sas.9.2(base)
Regards,
venky
Did you edit your post?
The conversation will make more sense if you post clarifications separately...
So, you might want to look to use the anyalpha() function instead.
View solution in original post
Maybe there is cleaner way, but this quite straightforward:
numvar=input(compress(upcase(charvar),'ABC......XYZ'),best.);
I looking to get only numeric characters in that column. Can you help me in the function.
I'm sorry i edited it.
Thank you issue is resolved.
Regards
vnky
The SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment.
Join SUGA
SAS technical trainer Erin Winters shows you how to explore assets, create new data discovery agents, schedule data discovery agents, and much more.
Find more tutorials on the SAS Users YouTube channel.