topic Re: How do I turn a name into last,first from 2 variables of firstnm lastnm? in New SAS User

How do I turn a name into last,first from 2 variables of firstnm lastnm?

ewharry99 — Thu, 10 Dec 2020 05:50:49 GMT

Hi How do I turn a name into last,first from 2 variables of firstnm lastnm?

blakeellis18 — Thu, 10 Dec 2020 05:52:27 GMT

Hi!

if youre looking to make a new variable, say you name it "name" you would do

name= CATX (',', LastNm, FirstNm);

and if you wanted to get rid of those other two variables you would just drop them!

drop LastNm FirstNm;

Deanna_Payne — Sun, 13 Dec 2020 00:29:29 GMT

Another option could be Cat

data Want;

set Have;

FullName = cat(Lastnm, Firstnm);

run;

Or Google: "Creating New Character Values in SAS Documentation"

sdevenny — Wed, 16 Dec 2020 05:09:25 GMT

You could do this:

DATA new;
SET old;
FullName = LastNm || ',' || FirstNm;
RUN;