Keeping the colors for category constant at all times

[mmohotsi]

Good day

I have a data set that changes depending on the attributes in the database. I am trying to draw a stack graph for this data set. The data set is as in the attached files. The program below provides a graph with the following colors to the distinct groups:

White color - Out of commission

Yellow color: sampled not scheduled

Blue color :Recommissioned

How do I keep  the colors constant to each of these groups regardless of whether a certain category is available  or not in the extracted data set.

The code I used is as follows:

proc sgplot data = data.Data_Raw pctlevel=group noborder ;
styleattrs datacolors=( deepskyblue yellow white ) ;
vbar PIPELINE / stat=pct group = Screen_0001 groupdisplay=stack name='Barcharts'
barwidth=0.5 ;
keylegend 'Barcharts' / TITLEATTRS=(weight=bold family=Helvetica size=5) position=bottom noborder;
yaxis label='% Composition' LABELATTRS=(weight=normal size=12);
xaxis display=(nolabel) valuesrotate=vertical;
title "Graphical representation" justify=right;
run;

Regards

[PaigeMiller]

https://communities.sas.com/t5/Graphics-Programming/PROC-SGPLOT-How-to-get-consistent-colors-across-...

[mmohotsi · Accepted solution]

This solution is used in the by group scenario. In the data set I have categories are kept in the group = option

[PaigeMiller]

In the link, the colors are assigned to the values of the variable in the GROUP= option. Works with or without a BY variable.

[mmohotsi]

Thanks PaigeMiller

This is the solution to my challenge

Regards

mmohotsi

[PaigeMiller]

@mmohotsi 

Please be kind enough to un-mark your comment as a solution (since it is not a solution in any meaningful sense) and mark the link I provided as the solution.