topic Re: Keeping the colors for category constant at all times in SAS Programming

Keeping the colors for category constant at all times

mmohotsi — Wed, 17 Sep 2025 10:00:20 GMT

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

Re: Keeping the colors for category constant at all times

PaigeMiller — Wed, 17 Sep 2025 10:36:21 GMT

https://communities.sas.com/t5/Graphics-Programming/PROC-SGPLOT-How-to-get-consistent-colors-across-BY-groups/td-p/668774

Re: Keeping the colors for category constant at all times

mmohotsi — Wed, 17 Sep 2025 11:08:42 GMT

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

Re: Keeping the colors for category constant at all times

PaigeMiller — Wed, 17 Sep 2025 11:51:52 GMT

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

Re: Keeping the colors for category constant at all times

mmohotsi — Wed, 17 Sep 2025 15:41:10 GMT

Thanks PaigeMiller

This is the solution to my challenge

Regards

mmohotsi

Re: Keeping the colors for category constant at all times

PaigeMiller — Thu, 18 Sep 2025 12:41:28 GMT

@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.