Help using Base SAS procedures

proc report

Reply
Occasional Contributor
Posts: 13

proc report

Treatment_name_labelmy_variable
1WEIGHTWeight (kg)69.75±7.56
2WEIGHTWeight (kg)68.06±8.51

Hi how to present it in the below format

variableTreatment
Weight12
69.75±7.5668.06±8.51
Super Contributor
Posts: 349

Re: proc report

Posted in reply to kumarnaidu

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

Trusted Advisor
Posts: 1,137

Re: proc report

Posted in reply to kumarnaidu

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;

Thanks,
Jag
Ask a Question
Discussion stats
  • 2 replies
  • 210 views
  • 2 likes
  • 3 in conversation