topic search for numbers (successively) in a string in SAS Programming

search for numbers (successively) in a string

J_J_J — Mon, 28 Oct 2019 08:28:53 GMT

Hi!

Can anybody help me please to find in a string numbers (successively). It can be different count of digits on different lines.

Example:

1) text #11111111# text

2) text

3) text #555555555# text

I would like to get 2 rows:

1) 1111111

2) 555555555

Re: search for numbers (successively) in a string

PeterClemmensen — Mon, 28 Oct 2019 08:35:41 GMT

Do you simply want to extract numbers (0123456789) from a string or do they have to be enclosed in ##?

Re: search for numbers (successively) in a string

J_J_J — Mon, 28 Oct 2019 08:40:47 GMT

They have to be enclosed in ##

Re: search for numbers (successively) in a string

PeterClemmensen — Mon, 28 Oct 2019 08:45:42 GMT

Ok. Building on your previous thread, how about this?

data have;
input string $ 1-50;
datalines;
text #11111111# text
text
text #555555555# text
;

data want;
    set have;
    num=input(prxchange('s/.*#(\d+)#.*/\1/', -1, string), 8.);
    if num;
run;

Result:

string                   num
text #11111111# text     11111111
text #555555555# text    55555555

Re: search for numbers (successively) in a string

J_J_J — Mon, 28 Oct 2019 09:01:47 GMT

Thanks a lot! It works!