Laguardia Flights by Destination and Revenue, March 4-10 +------------------------------------------------------------------+ | | Min | Max | Mean | Sum | |------------+------------+---------+---------+---------+----------| |Destination | | | | | | |------------+------------| | | | | |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| +------------------------------------------------------------------+

By using the Output Delivery System (ODS), you can highlight the Revenue rows and certain Deplaned values. You can control fonts and colors, embed GIF images, and even change cell appearance according to cell values.

To see the full range of colors in the tables in this lesson, your computer must have a 16-bit or better display. If you have an 8-bit (256 color) display, some colors will not appear as described.

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

This table is the same as the first one. This version, however, uses color to draw your attention to specific items within the data. In addition, the orange and purple cells contain short notes, which Internet Explorer users can read by briefly holding the mouse pointer above the cells. This lesson leads you, step by step, through creating the table you see above. This lesson contains 37 pages and takes approximately 60-90 minutes to complete. Objectives In this lesson, you learn to apply the STYLE= option to table elements apply colors to table cells extend style attributes across cells change the appearance of text apply conditional styles to cells (traffic-lighting) add fly-over text to values pass HTML through to a browser embed images in table cells. Prerequisites This lesson assumes you are familiar with HTML, including the concept and syntax of tags. A great many sources, both online and in print, provide HTML information. You should also have completed the following lessons: Introduction to SAS Programming Working in the SAS Environment Basic Concepts Editing and Debugging SAS Programs Setting Up Your SAS Session Producing Basic Reports Creating Tabular Reports Creating and Modifying Variables Formatting Variable Values Enhancing and Storing Output Enhancing Reports Producing HTML Output