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;
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.