Grouporder doesn't work in proc sgpanel clustered bar chart graph

mahendraksas — Sun, 15 Mar 2020 04:11:33 GMT

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;

Re: Grouporder doesn't work in proc sgpanel clustered bar chart graph

ed_sas_member — Sun, 15 Mar 2020 11:39:07 GMT

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;

topic Re: Grouporder doesn't work in proc sgpanel clustered bar chart graph in Graphics Programming

Grouporder doesn't work in proc sgpanel clustered bar chart graph

Re: Grouporder doesn't work in proc sgpanel clustered bar chart graph