topic Re: proc report in SAS Procedures

proc report

kumarnaidu — Thu, 26 Apr 2012 09:14:13 GMT

Hi how to present it in the below format

shivas — Thu, 26 Apr 2012 09:53:19 GMT

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

Jagadishkatam — Thu, 26 Apr 2012 12:25:42 GMT

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;