topic Re: Cannot Create a Pie Chart in ODS EXCEL Using PROC GCHART? in Graphics Programming

Cannot Create a Pie Chart in ODS EXCEL Using PROC GCHART?

robby_beum — Tue, 01 Aug 2017 15:41:08 GMT

I can create a vertical bar chart in ODS EXCEL (.xlsx) using PROC SGPLOT but when I substitute that code and replace it with a PROC GCHART to create a pie chart, it doesn't create a chart and no error messages are created in the .xlsx

Does creating a pie chart in PROC GCHART not work with ODS EXCEL?

Generates a bar chart in ODS EXCEL:

proc sgplot data=work.data;

vbar percentage / group=category;

run;

Does not generate a pie chart in ODS EXCEL:

proc gchart data=work.data;

pie category / sumvar=percentage;

run;

Re: Cannot Create a Pie Chart in ODS EXCEL Using PROC GCHART?

Rick_SAS — Tue, 01 Aug 2017 15:43:54 GMT

If you want an ODS graphics version of a pie chart, check out the %GTLPieChartMacro by Sanjay Matange

http://blogs.sas.com/content/graphicallyspeaking/2012/08/26/how-about-some-pie/

Re: Cannot Create a Pie Chart in ODS EXCEL Using PROC GCHART?

Vince_SAS — Wed, 02 Aug 2017 11:15:26 GMT

This worked for me using SAS 9.4 M4 on Windows:

ods _all_ close;

ods Excel file='C:\temp\temp.xlsx';

goptions device=png;

proc gchart data=sashelp.class;
   pie sex / sumvar=age;
run; quit;

ods Excel close;

Vince DelGobbo

SAS R&D

Re: Cannot Create a Pie Chart in ODS EXCEL Using PROC GCHART?

robby_beum — Wed, 02 Aug 2017 12:51:44 GMT

Thank You Vince,

I did a little experiment. Your code worked for me as well and it appears that the "goptions device=png;" is what allowed the pie chart to render. I placed the following in my code and both graphs were created in the .xlsx. I then commented out the "goptions device=png;" and reran and only the bar chart was created.

goptions device=png;

proc gchart data=sashelp.class;
pie sex / sumvar=age;
run;

proc sgplot data=sashelp.class;
vbar age / group=sex;
run;

Re: Cannot Create a Pie Chart in ODS EXCEL Using PROC GCHART?

Vince_SAS — Wed, 02 Aug 2017 13:02:37 GMT

I have had the best results by explicitly specifying the PNG device when creating graphics for Excel. You can use the ODS GRAPHICS statement to set the image format for SG* procedures.

Vince DelGobbo

SAS R&D