topic How to extract numbers in Administration and Deployment

How to extract numbers

pallis — Wed, 21 Aug 2013 06:38:03 GMT

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

12345678

ab2345678d

45678ed34

34567289

looking for output:

12345678

34567289

I looking to get only numeric characters in that column. Can you help me

sas.9.2(base)

Regards,

venky

LinusH — Wed, 21 Aug 2013 06:41:46 GMT

Maybe there is cleaner way, but this quite straightforward:

numvar=input(compress(upcase(charvar),'ABC......XYZ'),best.);

LinusH — Wed, 21 Aug 2013 06:57:39 GMT

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.

pallis — Wed, 21 Aug 2013 06:59:10 GMT

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

12345678

ab2345678d

45678ed34

34567289

looking for output:

12345678

34567289

I looking to get only numeric characters in that column. Can you help me in the function.

I'm sorry i edited it.

sas.9.2(base)

Regards,

venky

pallis — Wed, 21 Aug 2013 09:05:14 GMT

Thank you issue is resolved.

Regards

vnky