topic Re: Extracting only numbers in New SAS User

Extracting only numbers

cmemtsa — Tue, 05 Jan 2021 07:27:19 GMT

data T;
input ID $ L $;
Datalines;
1 3/42514
2 11/761
3 350
;

Hi,

I have a column L with data and I want to extract only numbers after the slash (\). If there's no slash, then the whole number i.e. the output should be

1 42514

2 761

3 350

Is it feasible?

Thank you in advance for your help.

Re: Extracting only numbers

andreas_lds — Tue, 05 Jan 2021 07:45:33 GMT

You can use the scan-function to extract a "word" from a string. If the second argument is negative, scan starts from the right side.

data want;
   set T;
   
   newL = scan(L, -1);
run;

Re: Extracting only numbers

cmemtsa — Tue, 05 Jan 2021 07:52:59 GMT

Yes, this works!

Is there a way to do it also in proc sql?

Re: Extracting only numbers

ballardw — Tue, 05 Jan 2021 10:58:17 GMT

The SCAN function works in SAS Proc SQL.