How to extract numbers

[pallis]

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:

12345678

34567289

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

sas.9.2(base)

Regards,

venky

[LinusH]

Maybe there is cleaner way, but this quite straightforward:

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

[LinusH · Accepted solution]

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]

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:

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]

Thank you issue is resolved.

Regards

vnky