topic Re: How to genarate a stack and cluster bar chart together using sgplot? in Graphics Programming

How to genarate a stack and cluster bar chart together using sgplot?

sasuser3 — Thu, 02 Mar 2017 15:03:59 GMT

Hi,

In SAS 9.4, I can use sgplot to generate either stack or cluster bar chart using vbar and groupdisplay=stack (or cluster).
But I have total 4 variables to display in the chart: region, year, grade, and enrollment. I would like to draw 4 'stack and cluster bars' for 4 values of "Region" in the same chart. Each stack should consist of 3 grades and there will be 2 bars for 2 values of "Year" in one cluster. Thus, there should be 4 such clusters for 4 regions.
So, is it possible to genarate a stack and cluster bar chart together using sgplot?

Thnak you.

Re: How to genarate a stack and cluster bar chart together using sgplot?

Jay54 — Thu, 02 Mar 2017 15:06:51 GMT

http://blogs.sas.com/content/graphicallyspeaking/2013/09/07/bar-charts-with-stacked-and-cluster-groups/

Re: How to genarate a stack and cluster bar chart together using sgplot?

sasuser3 — Thu, 02 Mar 2017 15:14:44 GMT

Thanks for a quick reply. But that example gives only a stack bar chart, not a stack and cluster bar chart. I would like to have at least 2 such stack bars (in a cluster) for each x-category. Fo example, if you have that type of data for another year then we would like to show such stack bars for 2 years for each product in the same chart. How to do it?

Re: How to genarate a stack and cluster bar chart together using sgplot?

Jay54 — Thu, 02 Mar 2017 15:29:04 GMT

Scroll down to the 3rd or later example in the article, using the SGPANEL procedure.

Also note, since the date of this article, the AXISTABLE statements havebeen introduced, which is a better way to add table of statistics to a graph. There are many examples of this in the blog. Search for "Axis Table".

Re: How to genarate a stack and cluster bar chart together using sgplot?

sasuser3 — Thu, 02 Mar 2017 15:30:54 GMT

Thank you very much. I can do that way by removing the gaps between the bars of the products for each year. So they will look more like clustrered for each year. Thanks.

Re: How to genarate a stack and cluster bar chart together using sgplot?

Jay54 — Thu, 02 Mar 2017 15:34:32 GMT

Sure. Set BarWidth=1.

Re: How to genarate a stack and cluster bar chart together using sgplot?

sasuser3 — Thu, 02 Mar 2017 15:36:23 GMT

Thank you.