topic how to extract the valuew which are in parentheses in SAS Programming

how to extract the valuew which are in parentheses

daisy6 — Mon, 30 Oct 2017 13:49:11 GMT

Hello,

I have a string of characters and I need those values in parentheses.

data title;
input title $20.;
datalines;
National Geography (NG)
Time (T)
National Food and Energy Council (NFC)
Food and Drug Administration (FDA)
National Hockey League (NHL)
National Football League (NFL)
;
run;

The results I want are:

NFC

NHL

NFL

Thanks for the help!

Re: how to extract the valuew which are in parentheses

FredrikE — Mon, 30 Oct 2017 13:55:47 GMT

If they always are at the end this is a quicky:

newTitle = compress(reverse(scan(reverse(title),1)),'()');

Untested, but should work 🙂

//Fredrik

Re: how to extract the valuew which are in parentheses

Astounding — Mon, 30 Oct 2017 14:01:22 GMT

This takes the first set of characters in parentheses, and doesn't consider whether there might be other sets of parentheses:

newvar = scan(oldvar, 2, '()');

Re: how to extract the valuew which are in parentheses

daisy6 — Mon, 30 Oct 2017 14:05:45 GMT

Thanks for that! It works!

Re: how to extract the valuew which are in parentheses

daisy6 — Mon, 30 Oct 2017 14:06:48 GMT

Thanks for reply. It works !

Re: how to extract the valuew which are in parentheses

Ksharp — Mon, 30 Oct 2017 14:13:48 GMT

data title;
input title $40.;
if findc(title,')','b')=length(title) then want=scan(title,-1,'() ') ;
datalines;
National Geography (NG)
Time (T)
National Food and Energy Council (NFC)
Food and Drug Administration (FDA)
National Hockey League (NHL)
National Football League (NFL)
;
run;