Sorry for the tags. Newbee with my first three questions to this user community. The project is all done whithin EG, user generates graphs and charts exported to SAS BI. Here is my code for the format and the proc tabulate PROC FORMAT ; PICTURE pctfmt(round)low - < 0 = ' 0009.9%' (prefix='-') 0 - high = ' 0009.9%'; VALUE trafficfmt low - < 42.0 ='lightred' 42.0 - 45.0 ='lightorange' 45.0 - 55.0 ='lightgreen' 55.0 - 58.0 ='lightorange' 58.0 - 100 = 'lightred' RUN; PROC TABULATE DATA=DATA_SALES ; VAR Actual Previous ; CLASS Product / ORDER=UNFORMATTED MISSING; TABLE Product={LABEL=''} ALL={LABEL='Total' STYLE={Background=lightgray}} * {STYLE={Background=lightgray}}, Actual={LABEL='Actual'}*F=COMMAX12.* Sum={LABEL=''} Actual={LABEL=' '} *F=pctfmt.* COLPCTSUM<Actual>={LABEL='%'} *F=pctfmt. Previous={LABEL='Previous'}*f=COMMAX12.* Sum={LABEL=' '} Previous={LABEL=''} * COLPCTSum<Previous>={LABEL='%'} *F=pctfmt. / BOX={LABEL='Office' STYLE={FONT_FACE='Arial' FONT_SIZE=10PT FONT_WEIGHT=BOLD FONT_STYLE=ROMAN FOREGROUND=#FFFFFF BACKGROUND=#333333}} ; ; RUN; RUN; QUIT; TITLE; FOOTNOTE;
... View more