How to create 100 percent stacked Bar chart using GTL?

[suraestar]

Hi ,

I want to generate a 100 percent stacked Bar chart using GTL Code?

PFA attachment for the expected output from GTL.

Can anyone help me in setting up the code ?

Thanks

[data_null__]

In 's blog he uses SGPLOT but I reckon you can do the same with GTL.

http://blogs.sas.com/content/graphicallyspeaking/2014/04/06/g100-with-sgplot/

[suraestar]

Hi,

Thanks.

But I want the options\statment in PROC TEMPLATE.... BARCHART statement..? Not using SGPLOT or GCHART.

[data_null__]

RTM.  I did not intend to "like" your reply but I don't know how to "unlike".:smileyplain:

TMPLOUT=“filename”

writes the Graph Template Language code for your graph to a file.

[Jay54]

Due to its popularity, an option to do a "G100" like bar chart will be added to GTL and SG procedures soon. 

[Jay54]

Just  an FYI...

Dan just reminded me that G100 feature has been added to SGPLOT procedure with SAS 9.4.  User PCTLEVEL=GROUP;

sgplot data=sashelp.cars pctlevel=group;

  vbar origin / group=type stat=pct;

  run;

[Ksharp]

try this one :

http://blogs.sas.com/content/sastraining/?s=stacked+Bar

[suraestar]

Hi All,

Thanks for your replies.

The below is the code which I tried to generate 100% stacked bar chart without Y axis and below is the output which I got.

proc template;
define statgraph bar100;
begingraph;
   layout overlay;
    barchart x=Origin /group=type
       stat=pct;
   endlayout;
  endgraph;
end;
run;

ods rtf file="c:temp\bar100.rtf";
proc sgrender data=sashelp.cars template=bar100;
run;
ods rtf close;

My expected Output is

Please suggest me how to generate since I am new to SAS graph.

Thanks.

[data_null__ · Accepted solution]

You have to make the data summary with the percent calculated within each group first.

proc sort data=sashelp.cars out=cars;
   by origin;
   run;
proc freq data=cars noprint;
   by origin;
   tables type / out=g100;
   run;
proc print;
   run;
proc template;
   define statgraph bar100;
      begingraph;
         layout overlay;
            BARCHARTPARM X = origin y=percent / group=type;
            endlayout;
         endgraph;
      end;
   run;
proc sgrender data=g100 template=bar100;
   run;

[suraestar]

Hi,

I have one doubt.

Is it possible to give in BARCHART statement? or Do we need to use BARCHARTPARM ?

Does it make any difference in output since we are paasing the summarized data to the erender?