GRIDDED RESPONSE TEMPLATE HOW TO

We have used Quarter as the Group variable.We have used Product as the Category variable.We use the SGPANEL procedure and use Year as the Class variable.Here we want to group Actual revenues placed side by side by Product, stacked by Quarter with Year as the Category.

GRIDDED RESPONSE TEMPLATE HOW TO

In that case, the SGPANEL procedures knows how to break up the adjacent groups across multiple rows and multiple pages. The additional benefit of using SGPANEL in such cases is when the graph gets too wide. Vbar product / response=actual group=quarter dataskin=gloss Panelby year / layout=columnlattice novarname noborder colheaderpos=bottom Title 'Actual Sales by Product, Year and Quarter' The reason to do this was that the frequency of use of a bar chart with Stacked AND Cluster groups was low, and there actually exists an easy way to do this using the SGPANEL procedure. Looking at the use cases, we decided to keep it simple, and support only Stacked OR Clustered groups but not both at the same time.

Adding this feature would introduce much more complications in the code. When we introduced the GROUPDISPLAY option, we had an extensive discussion on whether it was important to directly support this feature like in the GCHART procedure. So, we have three levels of categorization variables, one for category, one for cluster and one for stacks and one response variable. Vbar product / response=actual group=quarter groupdisplay=clusterīut what if you want to get a graph with Cluster and Stacked groups. Title 'Actual Sales by Product and Quarter'

Gridded response template