topic Compress function in sas in SAS Programming

Compress function in sas

Akshaya_1397 — Tue, 27 Jun 2023 08:32:53 GMT

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

Re: Compress function in sas

JosvanderVelden — Tue, 27 Jun 2023 09:18:16 GMT

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

Re: Compress function in sas

PaigeMiller — Tue, 27 Jun 2023 09:39:28 GMT

Compress(splr_name,'kd');

should be

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

note the two consecutive commas

Re: Compress function in sas

Kurt_Bremser — Tue, 27 Jun 2023 09:53:27 GMT

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'.

Re: Compress function in sas

Akshaya_1397 — Tue, 27 Jun 2023 10:08:24 GMT

Thankyou for the explanation it worked