Before Destination   Copenhagen Boarded Transferred Deplaned Revenue

After Destination   Copenhagen Boarded Transferred Deplaned Revenue

For example, the Laguardia destinations are defined by the variable Dest. The full destination names, as shown in the headings, are provided by the user-defined format $DESNAME.

value $desname 'CPH'='Copenhagen' 'FRA'='Frankfurt' 'LON'='London' 'PAR'='Paris';

To add an image of a flag to each Dest heading cell, add the following to the text strings that specify the destinations: Start with a P tag to force a paragraph break. Add an IMG tag and specify the source image file. (As mentioned before, use double quotes if the text string is in single quotes, or single quotes if the string is in double quotes.)

value $desname 'CPH'='Copenhagen<P><IMG src="denmark.gif">' 'FRA'='Frankfurt<P><IMG src="germany.gif">' 'LON'='London<P><IMG src="uk.gif">' 'PAR'='Paris<P><IMG src="france.gif">';

To have text and images appear correctly together, enclose mixed text and image strings in DIV tags.

value $desname 'CPH'='<DIV>Copenhagen<P><IMG src="denmark.gif"></DIV>' 'FRA'='<DIV>Frankfurt<P><IMG src="germany.gif"></DIV>' 'LON'='<DIV>London<P><IMG src="uk.gif"></DIV>' 'PAR'='<DIV>Paris<P><IMG src="france.gif"></DIV>';

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'='<DIV>Copenhagen<P><IMG src="denmark.gif"></DIV>' 'FRA'='<DIV>Frankfurt<P><IMG src="germany.gif"></DIV>' 'LON'='<DIV>London<P><IMG src="uk.gif"></DIV>' 'PAR'='<DIV>Paris<P><IMG src="france.gif"></DIV>'; value $desback 'CPH'='cxBBDDCC' 'FRA'='cxAACCBB' 'LON'='cx99BBAA' 'PAR'='cx88AA99'; value deplback low-105='lipk' 245-250='vpapb' other='ywh'; value deplflyo low-105='LOW traffic. Cut flights?' 245-250='HIGH traffic. Add flights?' other=' '; run; proc tabulate data=flights.laguardia format=comma9. style={background=ywh}; class dest / style={background=cxCCEEDD font_style=italic}; classlev dest / style={background=$desback.}; var boarded transferred deplaned / style={background=cxCCEEDD}; var revenue / style=<parent>{foreground=black}; table dest*(boarded transferred deplaned*{style={background=deplback. flyover=deplflyo.}} revenue*{style=<parent>}),min max mean sum / box={style={background=cxCCEEDD}}; keyword min max mean sum / style={background=cxCCEEDD font_style=italic}; 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