Need help with sgplot stacked bar chart

[James_Yu]

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.

[Reeza · Accepted solution]

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#!

[James_Yu]

Thanks alot.
This helps me to complete my code