data want;
set have;
where=findw(x,'will',' ');
name=substr(x,1,where-2);
run;
This method fails for someone who has the name "will" in their name, such as the famous political writer George F. Will or the famous actor Will Smith, unless we can depend on the fact that all names are properly capitalized in the data set. It also fails if will is capitalized as "Will", or if will does not exist in the string.
... View more
