Hi, I have this dataset HAVE which I want to "transpose" into dataset WANT, along with the column labels.
I am not sure how to do this. Thank you!
data have;
input name $ gender $ gender_label $;
cards;
Ann F Female
Mark M Male
Kate F Female
;
run;
data want;
input name $ F M ;
cards;
Ann 1 .
Mark . 1
Kate 1 .
;
run;
/*If there's a way to parameterize the labels as well*/
data want;
set want;
label F = "Female" M="Male";
run;
Look into the idlabel statement in proc transpose:
proc transpose
data=want
out=have (drop=_name_)
;
by name;
id gender;
idlabel gender_label;
run;
(Untested, no SAS at the moment)
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.