proc report

[kumarnaidu]

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

[shivas]

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]

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;