BookmarkSubscribeRSS Feed
radhikaa4
Calcite | Level 5

I have the following dataset

categorygroupmeasurevalue
heightcontrolmean55
heightcontrolmedian54
weightcontrolmean123
weightcontrolmedian125
heighttreatmentmean57
heighttreatmentmedian56
weighttreatmentmean147
weighttreatmentmedian167

 

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

 

Something like this: 

categorygroupmeanmedian
heightcontrol5554
weightcontrol123125
heighttreatment5756
weighttreatment147167

 

I did: 

 

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

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

 

Not working....

2 REPLIES 2
ed_sas_member
Meteorite | Level 14

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
Meteorite | Level 14
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,

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 462 views
  • 0 likes
  • 2 in conversation