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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.