topic Re: take only numeric (numbers) from a string in SAS Programming

take only numeric (numbers) from a string

Ronein — Sat, 20 Feb 2021 19:48:21 GMT

Hello

What is the way to take only numeric (numbers) from a string ?

For example:

Data t;

input string;

cards;

abcd25_fmt

gfhhff31_qr

jdhh4gt_r

;

run;

I need to get:

Re: take only numeric (numbers) from a string

A_Swoosh — Sat, 20 Feb 2021 20:23:24 GMT

You can achieve this by using a compress function to eliminate non-numeric values.

want= compress(string,'','A');

Re: take only numeric (numbers) from a string

Ronein — Sat, 20 Feb 2021 20:26:40 GMT

What does it mean 'A'?
What is the meaning of ''?
I ask in order to have logic

Re: take only numeric (numbers) from a string

A_Swoosh — Sat, 20 Feb 2021 21:09:53 GMT

Here is a good link for documentation on what you can do with the modifiers in the compress function.

https://www.lexjansen.com/phuse/2016/cc/CC01.

The third parameter, 'A' gets rid of all (A-Z) and (a-z) ...while the second parameter, ' ', does nothing other than hold space for the third parameter.

Re: take only numeric (numbers) from a string

Astounding — Sat, 20 Feb 2021 21:07:16 GMT

The correct answer actually depends on details that you haven't specified. What about decimal points? What about minus signs? What about multiple sets of digits? What should each of these become?

gfhhff3.14_qr

gfhhff3a1_qr

gfhhff-31_qr

gfhhff3-1_qr

gfhhff3+1_qr

gfhhff+31_qr

If you want to learn about the COMPRESS function (such as the meaning of "A"), you can read it here:

https://documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.5&docsetId=lefunctionsref&docsetTarget=n0fcshr0ir3h73n1b845c4aq58hz.htm&locale=en

Re: take only numeric (numbers) from a string

KlausBücher — Sat, 20 Feb 2021 21:19:13 GMT

Another way is to use the compress function with "k" and a positiv list:

want= compress(string,'0123456789','k');

For details of the compress function, see: https://documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.5&docsetId=lefunctionsref&docsetTarget=n0fcshr0ir3h73n1b845c4aq58hz.htm&locale=en