keeping only content within the 2nd set of parentheses

femiajumobi1 — Wed, 27 Mar 2024 23:23:20 GMT

In the column "event" My goal is to keep only 4010, but column event has COMBINED VISIT (-334 & -324) (4010)

The code below returned only VISIT. But I am interested in 4010

data want;
Set have;
redundant=scan(event,1,' ');
event=scan(event,2,' ');
drop redundant ;
run;

Re: keeping only content within the 2nd set of parentheses

Astounding — Wed, 27 Mar 2024 23:16:15 GMT

Try:

event = scan(visit, 4, "()");

First word: COMBINED VISIT

Second word: -334 & -324

Third word: blank between parentheses

Fourth word: 4010