topic Re: capture value within the parentheses using function in SAS Programming

capture value within the parentheses using function

jenim514 — Tue, 05 Dec 2017 22:29:12 GMT

Hi!

I have values that look like this:

VAR_NAME

(3) left hearing 12JAN2017

(14) right hearing 30JAN2017

The only thing i need to capture from this value are the numbers within the parentheses. Can someone help me use a scan or substr to capture this (or other function) ?

Thanks!

Re: capture value within the parentheses using function

novinosrin — Tue, 05 Dec 2017 22:34:29 GMT

if the pattern is exactly the same as your sample-

new_var=compress(scan(var_name, 1), '()');

Re: capture value within the parentheses using function

Reeza — Tue, 05 Dec 2017 22:37:33 GMT

new_var=scan(var_name, 1, '()');