Click here to see the SAS code.
Click here to see the example.

---------------------------------------------------------------

This is a little application (set of tables) I wrote, to help 
people find potential vehicles that would meet their requirements
for the Cash-for-Clunkers trade-in program.

The application could *also* be used by someone looking for a 
car that gets a certain level of gas-mileage! :)

-----

I got the fuel mileage data from the fueleconomy.gov website.
I imported it into SAS tables, and then create html tables 
grouped by certain year & mpg criteria.  There are also links
in the tables, to help you easily launch a google search on 
that make/model vehicle, so you can easily see what it looks like.

I created a custom SAS ODS style to match the color-scheme used
on the fueleconomy.gov website.

-----

Usage Scenario:

I have a 1995 Jeep Cherokee that gets avg 15mpg.

If I'm buying another SUV/Truck, and I want the maximum ($4,500) incentive,
then I need to be buying a new one that gets at least 20mpg.
Therefore I'd be looking at one of the following tables, and then
scrolling down to the various SUV and Truck sections:

   2009 vehicles getting at least 20 mpg
   2008 vehicles getting at least 20 mpg

Or, if I'm buying a Car, and want the maximum ($4,500) incentive,
then I need to be buying a new one that gets at least 25 mpg:

   2009 vehicles getting at least 25 mpg
   2008 vehicles getting at least 25 mpg


Back to Samples Index