I'm using pattern assignments in gchart for observations in 6 categories - I have patterns 1-6. I'm also creating multiple charts at once using the "by" statement (one chart for each group). If a group does not have an observation in a category, then SAS reassigns what category a pattern refers to, and thus changes the color dynamic for the whole graph. So, I'm making 50 graphs (one for each state), and I'm getting ~50 different color schemes for categories. Is there a way to assign the colors to the categories, non-dynamically? Code: pattern1 v=solid c=yellow; pattern2 v=solid c=stlg; pattern3 v=solid c=steel; pattern4 v=solid c=LIPB; pattern5 v=solid c=orange; pattern6 v=solid c=lightgray; proc gbarline data=six; by state; bar graphcode/ sumvar= pcr_count subgroup = subtype clipref width=5 FRAME MIDPOINTS=5 TO 58 BY 1 type=sum coutline=black raxis=axis1 maxis=axis2 legend=legend1; plot / sumvar=flupos type=mean axis=axis3 legend=legend2; run;quit; ... View more

I am trying to insert a calculation into the plot statement in gbarline. I have code that successfully produces my stacked bars, but I cannot get the line to be a percentage. The datafile contains one record per observation, which seems to be necessary for the bars to stack correctly. Is it possible for the line to be a calculation? I've tried putting the calculation into the plot stmt: plot / type=percent (flupos/pcr_count) I've also tried putting the necessary denominator in the where statement as below. proc gbarline data=six; bar graphcode/ sumvar= ili subgroup = subtype clipref width=5 FRAME MIDPOINTS=6 TO 58 BY 1 type=sum coutline=black raxis=axis1 maxis=axis2 legend=legend1; plot flupos / type=percent axis=axis3 legend=legend2; where ili=1 and pcr_count=1; format subtype subtype. graphcode graphcode.; run;quit; ... View more