Extract a numeric value from a string

[animesh123]

String=a1b2c3df456

[PeterClemmensen]

What numeric value do you want to extract?

[animesh123]

123456

[PeterClemmensen]

Try this

data test;
   string    = 'a1b2c3df456';
   newstring = input(compress(string, , 'kd'), 8.);
run;

[animesh123]

Thanks @PeterClemmensen

I will try to run this ,is it possible if you could explain me this ?

[PeterClemmensen · Accepted solution]

@animesh123 sure. Please mark my answer as the accepted solution if the code works for you.

The Compress Function keeps only digits from the string. 'kd' = 'keep digits'. 

The Input Function converts the character string to numeric.

[animesh123]

Hey @PeterClemmensen 

Is it anyway possible we could do the same using _num_?

[PeterClemmensen]

What does _num_ mean here?

[animesh123]

_NUMERIC_ specifies all numeric variables that are already defined in the current DATA step.

[PeterClemmensen]

So you want to expand this logic to all numeric variables in your data step?

[animesh123]

Yes, is it possible to pull out the numeric variables using _NUMERIC_ to get same output as we did by compress function?