There are a number of ways. If you only have the one set of parentheses in each string, probably the easiest would be a slight modification of what you tried:
data have;
informat name $30.;
input name &;
cards;
Sammy (NL)
Don (DP)
Greg (OL)
Fred Donalson (DE)
St. George B (BW)
;
data want;
set have;
name=scan(name,-2,'(');
run;
another way:
data have;
informat name $30.;
input name &;
cards;
Sammy (NL)
Don (DP)
Greg (OL)
Fred Donalson (DE)
St. George B (BW)
;
data want;
set have;
name=substr(name,1,find(name,'(')-1);
run;
proc print;
run;
data have; informat name $30.; input name &; cards; Sammy (NL) Don (DP) Greg (OL) Fred Donalson (DE) St. George B (BW) ; run; data want; set have; a=prxchange('s/\(\w+\)/ /',-1,name); run;
Ksharp
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.