Hi All,
I want to extract people's first name where the full name starts with one of the following
Mr,
Mr.,
Mrs,
Mrs.,
Dr,
Dr.
Please note that some name doesn't start with their Title. So far I was able to work with the Title part. But I need help with the name part.
DATA All;
INPUT Fullname $40.;
CARDS;
Mr. Simon Hill
Mr ABBY ANTAL
Tom Kewen
Miss Ann Sharp
Miss. Carla Newman
Mrs SYLVIA TUYTEL
Aleya Khan
Mrs. Melissa Ward
Dr. Cobi Sharpe;
RUN;
DATA SShuffle.All3;
LENGTH Title Fullname2 $ 40.;
SET SShuffle.All2;
IF fullname=: 'Mr.' THEN Title=SCAN(Fullname,1)||'.';
IF fullname=: 'Mr ' THEN Title=SCAN(Fullname,1)||'.';
IF fullname=: 'Mrs.' THEN Title=SCAN(Fullname,1)||'.';
IF fullname=: 'Mrs ' THEN Title=SCAN(Fullname,1)||'.';
IF fullname=: 'Miss.' THEN Title=SCAN(Fullname,1)||'.';
IF fullname=: 'Miss ' THEN Title=SCAN(Fullname,1)||'.';
IF fullname=: 'Dr.' THEN Title=SCAN(Fullname,1)||'.';
IF fullname=: 'Dr ' THEN Title=SCAN(Fullname,1)||'.';
RUN;
Output table:
Title Name Mr. Simon Hill
Mr ABBY ANTAL
Tom Kewen
Miss Ann Sharp
Miss. Carla Newman
Mrs SYLVIA TUYTEL
Aleya Khan
Mrs. Melissa Ward
Dr. Cobi Sharpe
Can someone please help.
... View more
