How to extract the value which is in double parentheses

[JohnChen_TW]

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!

[PeterClemmensen · Accepted solution]

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;

[JohnChen_TW]

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

[PeterClemmensen]

Anytime, glad to help 🙂

[Ksharp]

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