Compress function in sas

[Akshaya_1397]

Hi I have a variable call splr_name which is a character variable and has alphanumeric values as shown in the picture and I need to extract only the numeric value and store it in a new variable called splr_number.

 Attached the picture for reference.

I tried to use 

Compress(splr_name,'kd');

But I got the output as blank.

Can anyone help me on this

[JosvanderVelden]

Have a look at the solution in this post: https://communities.sas.com/t5/SAS-Programming/extract-numbers-from-variable-with-character-and-nume...

[PaigeMiller · Accepted solution]

Compress(splr_name,'kd');

should be

splr_name=compress(splr_name,,'kd');

note the two consecutive commas

[Kurt_Bremser]

Maxim 1: Read the Documentation: COMPRESS Function 

Syntax

COMPRESS(source,<characters>,<modifier(s)>)

Note the non-optional commas; this means that there must be a second argument before the modifiers, if these are to be used. Therefore, you have to supply a second argument, even if it's empty or 'null'.

[Akshaya_1397]

Thankyou for the explanation it worked