topic Re: proc transpose not working in SAS Programming

proc transpose not working

radhikaa4 — Fri, 27 Dec 2019 14:38:04 GMT

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....

Re: proc transpose not working

ed_sas_member — Fri, 27 Dec 2019 14:42:12 GMT

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;

Re: proc transpose not working

ed_sas_member — Sat, 28 Dec 2019 11:38:51 GMT

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,