topic Re: How to extract the value which is in double parentheses in SAS Programming

How to extract the value which is in double parentheses

JohnChen_TW — Wed, 21 Aug 2019 06:07:45 GMT

Hi Everyone,

I have a string of characters and I need the value in double parentheses.

How can I do?

Data is: SUBJECT NOT ELIGIBLE (LOW NEUTROPHIL COUNT (1.3))

I'd like to extract "(LOW NEUTROPHIL COUNT (1.3))".

Thanks!

Re: How to extract the value which is in double parentheses

PeterClemmensen — Wed, 21 Aug 2019 06:25:07 GMT

Here is one way

data test;
    string="SUBJECT NOT ELIGIBLE (LOW NEUTROPHIL COUNT (1.3))";
    pID = prxparse('/\((.*?)\)+/');
    call prxsubstr(pID, string, pos, length);
    newstring=substr(string, pos, length);
run;

Re: How to extract the value which is in double parentheses

JohnChen_TW — Wed, 21 Aug 2019 06:40:05 GMT

WOW! It works!
I never used 'prxparse' syntax...before.
I only know SCAN and SUBSTR function...
Thanks a lot!

Re: How to extract the value which is in double parentheses

PeterClemmensen — Wed, 21 Aug 2019 07:08:08 GMT

Anytime, glad to help 🙂

Re: How to extract the value which is in double parentheses

Ksharp — Wed, 21 Aug 2019 11:41:39 GMT

data test;
    string="SUBJECT NOT ELIGIBLE (LOW NEUTROPHIL COUNT (1.3))";
    newstring=prxchange('s/[^(]*(\(.+\)).*/$1/',1,string);
run;