topic Re: How to create 100 percent stacked Bar chart using GTL? in Graphics Programming

How to create 100 percent stacked Bar chart using GTL?

suraestar — Mon, 21 Apr 2014 10:29:57 GMT

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

Re: How to create 100 percent stacked Bar chart using GTL?

data_null__ — Mon, 21 Apr 2014 10:40:31 GMT

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/

Re: How to create 100 percent stacked Bar chart using GTL?

suraestar — Mon, 21 Apr 2014 10:49:17 GMT

Hi,

Thanks.

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

Re: How to create 100 percent stacked Bar chart using GTL?

data_null__ — Mon, 21 Apr 2014 11:01:26 GMT

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.

Re: How to create 100 percent stacked Bar chart using GTL?

Ksharp — Mon, 21 Apr 2014 11:17:08 GMT

try this one :

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

Re: How to create 100 percent stacked Bar chart using GTL?

Jay54 — Mon, 21 Apr 2014 13:16:18 GMT

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

Re: How to create 100 percent stacked Bar chart using GTL?

suraestar — Tue, 22 Apr 2014 05:18:28 GMT

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.

Re: How to create 100 percent stacked Bar chart using GTL?

data_null__ — Tue, 22 Apr 2014 10:12:18 GMT

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; 

Re: How to create 100 percent stacked Bar chart using GTL?

suraestar — Tue, 22 Apr 2014 12:53:06 GMT

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?

Re: How to create 100 percent stacked Bar chart using GTL?

Jay54 — Tue, 22 Apr 2014 13:18:40 GMT

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;