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

[ewharry99]

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

[blakeellis18 · Accepted solution]

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]

Another option could be Cat

data Want;

set Have; 

FullName = cat(Lastnm, Firstnm);

run;

https://documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.5&docsetId=basess&docsetTarget=p1ka2...

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

[sdevenny]

You could do this:

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