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