Proc GChart Is a Sub-Subgroup Possible?

[RowanB1986]

Hi,

I've used the code below to successfully create a plot that groups quarters by year. Is It possible to add an extra, "top-level" grouping variable, so that there'll be a "Group" variable, a "Subgroup" variable and a "Sub-Subgroup" variable?

proc gchart data=FUEL_TYPE_QUARTERLY;
label REG_YEAR="Year" REG_QUARTER="Quarter";
vbar3d REG_QUARTER / discrete sumvar=PERCENT  group=REG_YEAR  subgroup=FUEL_TYPE   raxis=axis2;
run;
quit;

Regards,

Rowan

[DanH_sas · Accepted solution]

Try something like this:

proc sgpanel data=FUEL_TYPE_QUARTERLY;
label REG_YEAR="Year" REG_QUARTER="Quarter";
panelby fuel_type year / layout=lattice onepanel novarname;
vbar REG_QUARTER / response=PERCENT  group=subsubgroupvar dataskin=pressed;
run;
quit;

[RowanB1986]

Thanks Dan! Excited to try this on Monday!