topic Re: sgpanel and vbar proportion/width in Graphics Programming

sgpanel and vbar proportion/width

Shad — Tue, 21 Feb 2023 23:33:25 GMT

Hello,

I'm attempting to create a graph to demonstrate variation in medication use by hospitals and region. I think I've gotten close to what I'm after, but I'm running into some struggles while trying to fine tune the figure.

proc sgpanel data=hospitalgraph;
	panelby region / novarname onepanel noborder layout=columnlattice  uniscale=column ;

	vbar ID / response=all_opioid_Mean stat=mean categoryorder=RESPASC barwidth= 0.6 groupdisplay=cluster ;  
	vbar ID / response=methadone_mean stat=mean barwidth= 0.4 groupdisplay=cluster ; 

	rowaxis label="Proportion" discreteorder=data  ;
	colaxis  valueattrs=(size=7) VALUESROTATE=VERTICAL label ='Hospital Number'; 

	format region REGION_.; 
run;

Specifically, what are some tips/tricks for:

Making the width/space between bars the same for each of the 4 panels?
How to force the bar width to be the same each panel, right now it seems to be auto scaling based on the available space
I was also struggling with indicating the hospital number horizontally, my work around was to request vertical x-axis IDs however for the hospitals in the Northeast region they're still horizontal, is there a better way to instead of the valuesrotate option?

Thank you,

Re: sgpanel and vbar proportion/width

Ksharp — Wed, 22 Feb 2023 11:48:30 GMT

Try "PROPORTIONAL" option:
panelby year/layout=columnlattice onepanel spacing=0 noborder
colheaderpos=bottom novarname uniscale=row PROPORTIONAL ;

Re: sgpanel and vbar proportion/width

DanH_sas — Wed, 22 Feb 2023 13:44:51 GMT

In addition to adding the PROPORTIONAL option mentioned by @Ksharp , add FITPOLICY=ROTATEALWAYS to the COLAXIS. This forces the axis tick values to rotate, even if there is no collision.

Re: sgpanel and vbar proportion/width

Shad — Wed, 22 Feb 2023 15:57:20 GMT

Thanks @Ksharp. Appreciate the help, that did the trick perfectly.

Re: sgpanel and vbar proportion/width

Shad — Wed, 22 Feb 2023 15:58:34 GMT

Thanks @DanH_sas, interestingly when I added the PROPORTIONAL option it forced the axis tick values to be 90 degrees, but I will keep this little tidbit in my back pocket if/when I need it.

Re: sgpanel and vbar proportion/width

DanH_sas — Wed, 22 Feb 2023 17:20:10 GMT

When you used the PROPORTIONAL option, the spacing for the second cell must have compressed in a way that there were collisions on that axis as well, causing the ROTATE fit policy to be applied there as well.