Hi, I have names in my table that have the first and last name format. I need to convert the format to first initial follow by dot then last name.
For example, Sandy Chint would be S.Chint, Kathy Kumarxy would be K.Kumarxy, and Thomas P Magliu would be T.Magliu
These names have first and last name format, as well as middle name/initial between first and last name. How to do this in prxchange or is there a better way to do it? Below is some examples. Thanks.
data ReversedNames;
input name $32.;
datalines;
Sandy Chint
Kathy Kumarxy
Bobby Smith
Jason McDonald
Annie Avor
Thomas P Magliu
Joan Smith Korcos
;
run;
How about
data ReversedNames;
input name $32.;
datalines;
Sandy Chint
Kathy Kumarxy
Bobby Smith
Jason McDonald
Annie Avor
Thomas P Magliu
Joan Smith Korcos
;
run;
data want;
set ReversedNames;
newname = cat(char(name, 1), '. ', scan(name, -1));
run;
How about
data ReversedNames;
input name $32.;
datalines;
Sandy Chint
Kathy Kumarxy
Bobby Smith
Jason McDonald
Annie Avor
Thomas P Magliu
Joan Smith Korcos
;
run;
data want;
set ReversedNames;
newname = cat(char(name, 1), '. ', scan(name, -1));
run;
I prefer the common string functions for this rather simple task:
data want;
set reversednames;
name = catx(".",substr(name,1,1),scan(name,-1));
run;
@LL5 wrote:
Hi, I have names in my table that have the first and last name format. I need to convert the format to first initial follow by dot then last name.
For example, Sandy Chint would be S.Chint, Kathy Kumarxy would be K.Kumarxy, and Thomas P Magliu would be T.Magliu
These names have first and last name format, as well as middle name/initial between first and last name. How to do this in prxchange or is there a better way to do it? Below is some examples. Thanks.
data ReversedNames; input name $32.; datalines; Sandy Chint Kathy Kumarxy Bobby Smith Jason McDonald Annie Avor Thomas P Magliu Joan Smith Korcos ; run;
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 how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.