SAS OnlineTutor HomeFAQ PageSuggested Learning PathsContents+Searchback||next

Enhancing HTML Tabular Reports
Adding Color to Table Cells


Creating the Basic Table in HTML

Let's turn to our example for this lesson, a table that reports the traffic and revenue for four daily flights from Laguardia airport in New York. Before you attempt any customization, take a look at PROC TABULATE output using default ODS HTML settings. (The sample program that follows creates HTML files in the Windows operating environment.) 

     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;
        var boarded transferred deplaned revenue;
        table dest*(boarded transferred deplaned revenue),
              min max mean sum;
        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



  back||next


Copyright © 2002 SAS Institute Inc., Cary, NC, USA. All rights reserved.

Terms of Use & Legal Information | Privacy Statement