topic Re: using proc gchart for pie charts in Graphics Programming

using proc gchart for pie charts

Anita_n — Tue, 17 Oct 2017 11:23:25 GMT

Hello ,

Is there any way to roundup the percentage values in a pie chart. I don't want any decimal points to be displayed. Also I want the title bold and will like to display all slices even those below 0%. I dont want them to be labelled other.

I used other =0 but still have not the appropriate results. I will appreciate any help. Thanks

Re: using proc gchart for pie charts

RW9 — Tue, 17 Oct 2017 12:03:18 GMT

You should be able to apply a format directly to it, for example:

http://support.sas.com/kb/24/877.html

Re: using proc gchart for pie charts

Anita_n — Tue, 17 Oct 2017 19:30:16 GMT

proc format is not changing the decimal point a similar chart of what I have. I do not want any decimals

goptions  border htitle=12pt htext=10pt;


pattern1 color=red;
pattern2 color=green;
pattern3 color=orange;
pattern4 color=purple;


proc format;
   percent pctfmt (round) 0-high='000%';
run;

/* Define a legend */

legend1 label=("my pie")

position=(bottom )

offset=(4,)

across=1

value=(color=black)

shape=bar(4,1.5);



proc gchart data=pie;

title "my pie chart";

pie cars /sumvar= percent

clockwise value=none

legend=legend1

percent=inside

radius=25

noheading;

 format percent pctfmt.;   


run;

please help I want only intergers without any decimal places

Re: using proc gchart for pie charts

GraphGuy — Wed, 18 Oct 2017 12:32:56 GMT

I don't think your user-defined-format is running correctly.

proc format;
   percent pctfmt (round) 0-high='000%';
run;

When I try to run it, I get the following error:

237 proc format;
238 percent pctfmt (round) 0-high='000%';
-------
180
ERROR 180-322: Statement is not valid or it is used out of proper order.

NOTE: The previous statement has been deleted.
239 run;

Re: using proc gchart for pie charts

GraphGuy — Wed, 18 Oct 2017 12:40:20 GMT

If you were letting Gchart calculate the percent values, I don't think you can control the format (number of decimal places).

But since it appears you're pre-calculating the values of the percent variable, you should be able to control the number of decimal places with a format statement. Rather than writing your own user-defined-format, I would recommend just using the sas-supplied percent format.

Here's some code that shows letting Gchart calculate the percent (where you can't control the format), and then pre-calculating the percent value (where you can control it with SAS' percent format):

title "Using automatically-calculated percent";
title2 "(can't control format)";
proc gchart data=shoes_summarized;
pie region / type=sum sumvar=sales percent=outside value=none noheading other=0;
run;

proc sql noprint;
create table shoes_summarized as
select unique region, sum(sales) as sales
from sashelp.shoes
group by region;
create table shoes_summarized as
select unique region, sales, sum(sales) as total_sales
from shoes_summarized;
quit; run;
data shoes_summarized; set shoes_summarized;
percent=sales/total_sales;
run;

title "Using manually pre-calculated percent";
title2 "(can control format)";
proc gchart data=shoes_summarized;
format percent percent7.0;
pie region / type=sum sumvar=percent value=outside slice=none noheading other=0;
run;

Re: using proc gchart for pie charts

Anita_n — Wed, 18 Oct 2017 20:42:06 GMT

Okay thanks a lot, I will try your suggetions and leave a feedback.

I probably can't control this because gchart is calculating the percent for me.

Thanks for the idea.

Re: using proc gchart for pie charts

Anita_n — Mon, 23 Oct 2017 12:31:44 GMT

Thanks a lot RobertAllison_S, your suggested method did work. It looks very nice

Re: using proc gchart for pie charts

Kimi2 — Tue, 24 Sep 2019 10:37:47 GMT

Dear Robert,

This is a very helpful programme.

Is it possible to do the same with "proc template; define statgraph pie" ?

Many thanks,

Kim

Re: using proc gchart for pie charts

DanH_sas — Tue, 24 Sep 2019 14:37:54 GMT

The second approach from @GraphGuy should also work for PIECHART in ODS Graphics. Just put your FORMAT statement with the PROC SGRENDER call.