topic Need help with sgplot stacked bar chart in Graphics Programming

Need help with sgplot stacked bar chart

James_Yu — Sat, 21 Aug 2021 11:43:24 GMT

Hi I need some helps with sgplot.

I wish to build a couple of stacked bar chart with the code samples as below

proc sgplot data=mydata noborder pctlevel=group;
 by Label notsorted;
 styleattrs datacolors=(bigb  bibg bio brown yellow red) ;
  vbar Day/group=Grade stat= pct groupdisplay=stack fill grouporder=ascending missing;
  xaxis integer values=(1 2 3 4 5 6 7);
run;

At first, I want to make a 100% stacked bar chart (including missing value) on each Day. My data has 5 grade: 0,1,2,3,4 and missing data (display as "." bcs Grade is numeric variable)

And now I encounter 2 problems:

- How can I retain the percentage of other values on the bar on each day if I don't want the percentages of missing value and grade 0 to be displayed on my chart ?

- How can I fix the color code with each value eg I want missing value to be display with bigb color (as the order shown in datacolors= syntax)

Thanks in advance.

Re: Need help with sgplot stacked bar chart

Reeza — Sun, 22 Aug 2021 02:11:27 GMT

Pre process your data so it’s summarized ahead of time. You can control your colours with items by using a data attribute map.

A rough idea how to get the graph started can be found in this post which does a stacked bar chart in the first set of code I posted.
https://communities.sas.com/t5/SAS-Programming/GROTTA-BAR/m-p/762632

Examples of data attribute map.

https://documentation.sas.com/doc/en/vdmmlcdc/8.11/grstatproc/n18szqcwir8q2nn10od9hhdh2ksj.htm#!

Re: Need help with sgplot stacked bar chart

James_Yu — Wed, 25 Aug 2021 15:59:12 GMT

Thanks alot.
This helps me to complete my code