proc transpose not working

[radhikaa4]

I have the following dataset

category	group	measure	value
height	control	mean	55
height	control	median	54
weight	control	mean	123
weight	control	median	125
height	treatment	mean	57
height	treatment	median	56
weight	treatment	mean	147
weight	treatment	median	167

I am trying to transpose by category and treatment then by mean/median with values

Something like this: 

category	group	mean	median
height	control	55	54
weight	control	123	125
height	treatment	57	56
weight	treatment	147	167

I did: 

proc sort data=have; by category group;run;

proc transpose data=have out=want;
by category group;
var Value;
run;

Not working....

[ed_sas_member]

Hi @radhikaa4 

You need to add an ID statement:

proc transpose data=have out=want (drop=_name_);
	var Value;
	ID measure;
	by category group;
run;

[ed_sas_member]

Hi @radhikaa4,

Did the proposed answer solved you problem ? If yes, could you please mark the topic as answered. Otherwise, could you please detail the issue so that we can help you?
Thank a lot,