Adding Color to Table Cells (4)

Enhancing HTML Tabular Reports

Adding Color to Table Cells

Changing Class Level Headings

As you saw earlier, you can alter the color of a class heading by adding the STYLE= option to your program's CLASS statement. But how do you change the color of class level headings beneath their parent cell?

In the Laguardia table, you specified a background color for the cell containing the variable Dest. Now suppose that you'd like to color the cells containing the values of Dest: CPH, FRA, LON, and PAR.

To apply the STYLE= option to class levels in a table, include a CLASSLEV statement in your program. Add a slash (/) and the STYLE= option to a CLASSLEV statement to change the attributes of class level cells.

General form, simple CLASSLEV statement:

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

where

variable specifies a class variable
attribute specifies a style attribute to alter.

For example, this CLASSLEV statement sets the background color of class level cells to cxAACCBB.

classlev dest / style={background=cxAACCBB};

Your program and its output are shown below. Notice the different results from using the STYLE= option in CLASS and CLASSLEV statements.

When applied to CLASS, the STYLE= option affects a heading cell: Dest.

When applied to CLASSLEV, the STYLE= option affects the levels of a heading: CPH, FRA, LON, PAR.

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}; classlev dest / style={background=cxAACCBB}; var boarded transferred deplaned revenue; table dest*(boarded transferred deplaned revenue), min max mean sum / box={style={background=cxCCEEDD}}; 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