topic Stacked Bar Graph with subgroup in New SAS User

Stacked Bar Graph with subgroup

Rajeshthangam — Mon, 02 Dec 2019 11:14:44 GMT

Re: Stacked Bar Graph with subgroup

PeterClemmensen — Mon, 02 Dec 2019 10:18:16 GMT

@Rajeshthangam Hi and welcome to the SAS Community 🙂

What version of SAS are you in?

Re: Stacked Bar Graph with subgroup

Rajeshthangam — Mon, 02 Dec 2019 10:22:34 GMT

I am using SAS University edition..

Re: Stacked Bar Graph with subgroup

PeterClemmensen — Mon, 02 Dec 2019 11:24:21 GMT

This gets you some of the way at least

proc freq data=have noprint;
    tables year*Group_Y_Name*Rankle / out=temp outpct;
run;

data graph;
    set temp;
    pct_row=round(pct_row)/100;
run;

title 'Group Y Portfolio (2007 / 2008 / 2009 / 2010)';
proc sgpanel data=graph;
    styleattrs datacolors=(CXFFDAB9 CXADD8E6 CXFAFAD2);
    panelby Group_Y_Name / layout=columnlattice novarname noborder colheaderpos=bottom;
    vbar Year / response=pct_row group=Rankle stat=sum seglabel seglabelformat=percent.;
    colaxis display=(nolabel);
    rowaxis display=(nolabel);
    keylegend / noborder title='';
run;
title;

Re: Stacked Bar Graph with subgroup

Rajeshthangam — Mon, 02 Dec 2019 10:56:52 GMT

It works fine. Thank you so much.

Is there anyway to acheive the same results in GCHART?

Re: Stacked Bar Graph with subgroup

PeterClemmensen — Mon, 02 Dec 2019 11:06:06 GMT

You're welcome 🙂 Probably. I'm no expert in PROC GCHART. Also, the SG Procedures are newer and better documented.

Re: Stacked Bar Graph with subgroup

Rajeshthangam — Mon, 02 Dec 2019 11:23:27 GMT

Thank you so much for giving this logic. But, Can you please remove the sample data and expected output image given?

Re: Stacked Bar Graph with subgroup

PeterClemmensen — Mon, 02 Dec 2019 11:24:33 GMT

Done

Re: Stacked Bar Graph with subgroup

ballardw — Wed, 04 Dec 2019 23:42:03 GMT

@Rajeshthangam wrote:

It works fine. Thank you so much.

Is there anyway to acheive the same results in GCHART?

No. SAS University Edition does not include the SAS/Graph part that would be needed to use the much less capable GCHART.