BookmarkSubscribeRSS Feed
mahendraksas
Calcite | Level 5

Hello all,

 

I am trying to create a clustered bar chart by patient grouped by treatment and then by patients internally at each timepoint. Below is my code. But despite of numerous combinations using grouporder=ascending or data the bars won't stack up by treatment (trtp2) first. Rather they are ordered by usubjid. I tried sorting by trtp2 alone without other variables also. Is there anything wrong that I am doing ?

 

proc sort data= mo out=mo2 ;
by atptn trtp2 usubjid ;
run;

 

proc sgpanel data=mo2 ;
panelby atptn / layout=columnlattice onepanel noborder colheaderpos=bottom novarname ;
vbar usubjid / response=aval group=trtp2
groupdisplay=cluster CLUSTERWIDTH= 1 grouporder=data;
colaxis display=(nolabel noticks );
rowaxis label=' ' grid offsetmax=0.025 ;
keylegend/ title="";
run;

1 REPLY 1
ed_sas_member
Meteorite | Level 14

Hi @mahendraksas 

 

Does this adaptation meet your expectations?

Could you please clarify how the graphic would look like?

proc sort data=mo out=mo2;
	by atptn trtp2 usubjid;
run;

proc sgpanel data=mo2;
	panelby atptn / layout=columnlattice onepanel noborder colheaderpos=bottom 
		novarname;
	vbar trtp2 / response=aval group=usubjid groupdisplay=stack CLUSTERWIDTH=1 
		grouporder=data;
	colaxis display=(nolabel noticks);
	rowaxis label=' ' grid offsetmax=0.025;
	keylegend/ title="";
run;

 

SAS INNOVATE 2024

Innovate_SAS_Blue.png

Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

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.

Get the $99 certification deal.jpg

 

 

Back in the Classroom!

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

View all other training opportunities.

Discussion stats
  • 1 reply
  • 290 views
  • 0 likes
  • 2 in conversation