Treatment | _name_ | label | my_variable |
1 | WEIGHT | Weight (kg) | 69.75±7.56 |
2 | WEIGHT | Weight (kg) | 68.06±8.51 |
Hi how to present it in the below format
variable | Treatment | |
Weight | 1 | 2 |
69.75±7.56 | 68.06±8.51 |
Hi,
Try this...Hope its helps..
data have;
input Treatment _name_ $ label $ 11. @+1my_variable $ 10.;
cards;
1 WEIGHT Weight(kg) 69.75±7.56
2 WEIGHT Weight(kg) 68.06±8.51
;
run;
proc report data=have nowd;
column label (_name_ my_variable, Treatment);
define Treatment / across;
define label/group;
define _name_/group;
define my_variable/'' group;
run;
Thanks,
Shiva
Hi Kumar,
I produced the same report throught proc transpose. Please try the code below. Hope it helps.
data test(rename=(_name_=weight));
input treatment _name_$ label$11. myvariables$15.;
treatmentx=cats("Treatment",treatment);
cards;
1 WEIGHT Weight(kg) 69.75±7.56
2 WEIGHT Weight(kg) 68.06±8.51
;
run;
proc sort data=test;
by weight;
run;
proc transpose data=test out=mewtest (drop=_name_);
by weight;
var myvariables;
id treatmentx;
run;
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 the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.