topic Proc GChart Is a Sub-Subgroup Possible? in Graphics Programming

Proc GChart Is a Sub-Subgroup Possible?

RowanB1986 — Fri, 06 Sep 2019 11:52:56 GMT

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

Re: Proc GChart Is a Sub-Subgroup Possible?

DanH_sas — Fri, 06 Sep 2019 14:25:36 GMT

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;

Re: Proc GChart Is a Sub-Subgroup Possible?

RowanB1986 — Sat, 07 Sep 2019 08:04:02 GMT

Thanks Dan! Excited to try this on Monday!