Getting consistent color scheme with freqplot option in PROC FREQ

[sgtilson18]

Hi,

I have created a format using Proc Format for a particular variable. There are 9 values that the variable can take on, so I assign 9 different formats.

I then do a Proc Freq and specify / plots = freqplot(twoway=stacked scale=grouppct) after the tables statement to create stacked bar charts.

For some of the plots that are created, data exists for all 9 different formats and I like this, but for some of the plots, the data underlying the plot only has perhaps

7 or 8 types from the proc format. The color scheme for the plots with all 9 types of formats is different from the color scheme for plots with only, say 7 or 8

types of the format.

How can I ensure that the color scheme is consistent across the plots? Can I force proc freq to plot all 9 of the formats, thereby ensuring that the color scheme

is consistent? Or is there a better way to do this?

Thank you so much!

Sebastian Tilson

[sgtilson18]

I think I've found the answer: this paper by Erin Christen titled "PROC FORMAT is Our Friend" has a section titled "ZERO-FILLING (AKA ‘DUMMYING UP’) OUTPUT DISPLAY" that solves this problem. Thanks to anyone who considered this question.

http://www.lexjansen.com/pharmasug/2006/Tutorials/TU02.pdf