topic Re: Extract a numeric value from a string in New SAS User

Extract a numeric value from a string

animesh123 — Thu, 08 Dec 2022 07:50:40 GMT

String=a1b2c3df456

PeterClemmensen — Thu, 08 Dec 2022 07:58:52 GMT

What numeric value do you want to extract?

animesh123 — Thu, 08 Dec 2022 08:22:48 GMT

123456

PeterClemmensen — Thu, 08 Dec 2022 08:26:48 GMT

Try this

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

animesh123 — Thu, 08 Dec 2022 08:42:14 GMT

Thanks @PeterClemmensen

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

PeterClemmensen — Thu, 08 Dec 2022 09:00:28 GMT

@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 — Thu, 08 Dec 2022 09:13:10 GMT

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

PeterClemmensen — Thu, 08 Dec 2022 09:21:57 GMT

What does _num_ mean here?

animesh123 — Thu, 08 Dec 2022 09:39:11 GMT

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

PeterClemmensen — Thu, 08 Dec 2022 09:45:20 GMT

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

animesh123 — Thu, 08 Dec 2022 10:06:03 GMT

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