Hello,
I have a variable - full names, and I want to separate all names (last, middle, first).
The variable is usually like Dan I Cooper. However some persons' names include a nick name and their names are like Johnson (John) E Allen. So I want to have a function to tell me which full names include a nickname within (). My solution is to use : If ANYPUNCT(fullname)>0 then nick_name=scan(fullname,2).
But now I find out a new issue, some full names are like Jeff M O'Hagan. With an apostrophe, the anypunct(fullname) is also greater than 0.
So is there a function I can just search parentheses within a string?
Thank you!
P.S. of course these names are not real names.
Cliff
FIND and INDEX functions.
FIND and INDEX functions.
Thanks! I just find(fullname,'(') and filter out those nicknames.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.