Trying to create a simple pie chart in SAS showing percentages

[SASGeek]

Hello,

I'm trying to create a simple pie chart in SAS to eventually export into Excel as a graph (user request). I'm trying everything I know but I can't get percentages to show and calculate.  Here's what I have

/* Step 1: Create the dataset in desired order */

data test;

    input rating $ count;

    datalines;

    Amber 1000

    Green 450

    Red   6445

    ;

run;

/* Step 2: Define custom colors in the same order */

pattern1 color=orange; /* Amber */

pattern2 color=green;  /* Green */

pattern3 color=red;    /* Red */

/* Step 3: Create the pie chart with percentages */

proc gchart data=test;

    pie rating / sumvar=count

                 type=percent      /* Show percentages */

                 value=inside      /* Place percentages inside slices */

                 other=0

                 noheading

                 legend;

    title "Rating Distribution (Percentages)";

run;

quit;

instead of the numbers (1000, 450, 6445) I want it to show 13%, 6%, and 82%.  And since the values can always flip, I want the first to show amber, 2nd to show green, 3rd to show red even if the percentages are 54%, 22%, and 24%. 

Would someone help me please?  Google isn't my friend this Friday afternoon. Thank you!

[Ksharp · Accepted solution]

Now you could use PROC SGPIE to get pie chart.

title "Regional Sales";
data test;
    input rating $ count;
    datalines;
    Amber 1000
    Green 450
    Red   6445
    ;
run;
proc sgpie data=test;
donut rating / response=count holevalue datalabeldisplay=(percent)
               holelabel="Total Sales" datalabelloc=outside;
run;

title "Regional Sales";
data test;
    input rating $ count;
    datalines;
    Amber 1000
    Green 450
    Red   6445
    ;
run;
proc sgpie data=test;
pie rating / response=count  datalabeldisplay=(percent)
                datalabelloc=inside;
run;

[SASGeek]

That's perfect. Thank you. Really appreciate the help!