Adding Color to Table Cells (2)

Enhancing HTML Tabular Reports

Adding Color to Table Cells

Changing Keyword Headings

You changed the color of the Dest class heading by adding a STYLE= option to your program's CLASS statement. But the table's column headings -- Min, Max, Mean, and Sum -- are keywords for statistics, not data set variables, so you cannot color them by adding a STYLE= option to a CLASS or VAR statement.

To alter keyword heading cells, use the KEYWORD statement with the STYLE= option.

General form, KEYWORD statement:

KEYWORD keyword(s) /
STYLE={attribute-1=value
<...attribute-n=value>};

where

keyword specifies a PROC TABULATE statistic
attribute specifies a style attribute to alter.

For example, if the statistic Sum is used as a table heading, you can color it pale purple by adding the following to the TABULATE procedure:
keyword sum / s={background=pap};

In the case of the Laguardia table, change the Min, Max, Mean, and Sum headings to the same shade of bluish-green used in the Dest cell heading.

keyword min max mean sum / style={background=cxCCEEDD};

Your program and its output look as follows.

ods listing close; ods html path='c:\data' body='laguard.html'; title1 'Laguardia Flights by Destination'; title2 'and Revenue, March 4-10'; proc format; value $desname 'CPH'='Copenhagen' 'FRA'='Frankfurt' 'LON'='London' 'PAR'='Paris'; run; proc tabulate data=flights.laguardia format=comma9.; class dest / style={background=cxCCEEDD}; var boarded transferred deplaned revenue; table dest*(boarded transferred deplaned revenue), min max mean sum; keyword min max mean sum / style={background=cxCCEEDD}; label dest='Destination'; format dest $desname.; run; ods html close; ods listing;

Laguardia Flights by Destination

and Revenue, March 4-10

Min Max Mean Sum

Destination 81 154 131 786

Copenhagen Boarded

Transferred 5 21 13 75

Deplaned 103 177 147 881

Revenue 109,885 196,540 139,951 839,705

Frankfurt Boarded 129 210 170 1,190

Transferred 5 22 13 91

Deplaned 147 237 188 1,314

Revenue 100,987 187,636 142,912 1,000,382

London Boarded 151 241 188 3,760

Transferred 4 18 11 227

Deplaned 114 250 199 3,987

Revenue 106,753 198,744 159,478 3,189,554

Paris Boarded 146 182 161 2,089

Transferred 7 29 16 204

Deplaned 153 227 183 2,378

Revenue 123,456 195,468 151,477 1,969,201

		Min	Max	Mean	Sum
Destination		81	154	131	786
Copenhagen	Boarded	81	154	131	786
	Transferred	5	21	13	75
	Deplaned	103	177	147	881
	Revenue	109,885	196,540	139,951	839,705
Frankfurt	Boarded	129	210	170	1,190
	Transferred	5	22	13	91
	Deplaned	147	237	188	1,314
	Revenue	100,987	187,636	142,912	1,000,382
London	Boarded	151	241	188	3,760
	Transferred	4	18	11	227
	Deplaned	114	250	199	3,987
	Revenue	106,753	198,744	159,478	3,189,554
Paris	Boarded	146	182	161	2,089
	Transferred	7	29	16	204
	Deplaned	153	227	183	2,378
	Revenue	123,456	195,468	151,477	1,969,201