topic Re: single cell trafficlight format in SAS Programming

single cell trafficlight format

loli — Mon, 29 Oct 2012 13:29:08 GMT

I have the following example output table, where 1,2,3,4 are columns for:1) total sales 2012 2) % of total regions 3)Total sales for 2011 and 4) % for total region

this is created by grouping different regions for the company. I would like to create a single cell trafficlight with Proc tabulate. that will affect the column 2012 percentage only for the North region as shown below. (I have the format done, I just need to know how to single specify North and the value of the single % representation). If possible, I would like to keep using pro Tabulate and not proc Report.

North	16.220 37.5% 71.394 39.3%
South	10.797 24.9% 37.095 20.4%
East	5.938 13.7% 27.072 14.9%
West	2.490 5.8% 11.846 6.5%
NorthE	4.001 9.2% 18.016 9.9%
SouthE	3.857 8.9% 16.357 9.0%
Total	43.303 100.0% 181.780 100.0%

Re: single cell trafficlight format

ballardw — Mon, 29 Oct 2012 15:31:40 GMT

An example of your color background format name and the table statement used to create the table will be helpful to provide specific advise.

BTW, why did you set tag for enterprise guide, gchart and functions when this question doesn't relate to any of those topics?

Re: single cell trafficlight format

loli — Tue, 30 Oct 2012 09:06:51 GMT

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;