topic Proc gchart pie chart rounding percents in Graphics Programming

Proc gchart pie chart rounding percents

vegan_renegade — Tue, 26 Nov 2019 17:07:35 GMT

Hello all, first time poster here. I am successfully getting a pie chart output with proc gchart in SAS 9.4, but I'd like to round the percents to whole numbers, but I cannot find an option to do this within proc gchart from researching online. The codes and outputs follow below. I am still a rather beginner SAS user, so perhaps there are other ways. Thank you.

/*Pie chart - Time Living in the US if Born Outside US.*/
title1 'Time Living in the US if Born Outside US';
proc gchart data=cohortb2019_Q2;
pie years_group    /*variable*/ 
/ 
type=freq            /*Statistic being analyzed. In this case, it's counts*/
percent=inside       /*Adds percent inside pie chart*/
radius=25            /*Size of the pie chart*/
woutline=1           /*Size of outline*/
angle=100            /*Angle of the pie chart*/
coutline=white       /*Color of pie lines*/
plabel=
	(height=1.4  /*Size of text*/ 
	 color=black /*Color of text*/
	 font='Georgia/bold') /*Font*/
noheading;           /*Excludes the heading that indicates what variables are being run*/
run;
quit;

The output is:

I'd like the percents to be 27%, 18%, etc. (rounded). I also have a frequency table code:

/*Outputs frequencies for country of origin (birth).*/
proc freq data=cohortb2019_Q2;
tables born_abroad country_born /missing;
title 'Born Abroad?';
run;

And the output being:

Re: Proc gchart pie chart rounding percents

Reeza — Tue, 26 Nov 2019 17:51:26 GMT

If you can switch to SGPIE there's the statfmt that allows you to specify the format of the variable.

Re: Proc gchart pie chart rounding percents

GraphGuy — Wed, 27 Nov 2019 19:38:07 GMT

If you're wanting to have complete control over the format of the value shown in a Gchart pie chart, I would recommend pre-calculating your statistic, and then only showing that 1 value on the pie. For example...

data summarized;
length country $20;
input my_pct country;
datalines;
.2727 Philippines
.1818 USA
.0909 China
.0909 Eritrea
.0909 Guam
.1818 Mexico
;
run;

title1 'Time Living in the US if Born Outside US';
proc gchart data=summarized;
format my_pct percent7.0;
pie country /
type=sum sumvar=my_pct
value=inside
radius=25
woutline=1
angle=100
coutline=white
plabel=(height=1.4 color=black font='Georgia/bold')
noheading;
run;

Re: Proc gchart pie chart rounding percents

vegan_renegade — Fri, 29 Nov 2019 05:33:43 GMT

Thank you, I actually tried using a percent format just like you did here, but the problem is it makes my counts disappear in the pie chart (see my original post, it shows the counts). I want the counts to stay.

Re: Proc gchart pie chart rounding percents

GraphGuy — Wed, 04 Dec 2019 13:05:18 GMT

Yep - that's where the "only showing that 1 value on the pie" caveat comes in. 🙂