Can you choose an SUV based on MPG?

3

I think it's time to replace my 2008 Prius. It has served me well, been basically maintenance-free, and gotten good gas mileage ... so, why not just get a newer Prius? Well, I've got the itch to get back into an SUV for my daily driver (I had a Bronco II, a CJ7, and a Cherokee in the past). I like that SUVs have the extra room, the ground clearance, 4wd, roof rack & towing capability, and a bit more oomph than the 110 horsepower Prius. But are there any SUVs that get decent gas mileage? ... Let's create some graphs to find out!

Before we get started, here's a picture of my 'extra' vehicle. It's a huge SUV, and does not get great MPG. It's perfect for hauling my DJ gear, and my 20ft+ racing boats. But I think it's too big & inefficient to use as my daily driver.

MPG Data

If we're going to consider MPG as a factor for choosing an SUV, where do you find MPG data? Fortunately there's a web site where you can download a csv file, and then import it into SAS (here's the code if you'd like to see the details).

Graphing Code

I wrote a bit of code to loop through all the different kinds of vehicles (using a 'by' statement), and create a graph for each one. For the most part it's just a regular scatter plot ... except I annotate a diagonal line (so you can easily see if there is much difference between city and highway MPG), and I also annotate some green reference lines so you can easily see which vehicles are above/below 30 MPG.

title1 c=gray33 h=12pt "#byval(class)";
proc sgplot data=plotdata nowall sganno=anno_diagonal;
label mpg_hwy='Highway';
label mpg_city='City mpg';
by order class2 class;
scatter y=mpg_hwy x=mpg_city /
   markerattrs=(color=cx0000ff size=8pt) transparency=.5
   tip=(long_string) tiplabel=('Data')
   url=link;
yaxis labelpos=top display=(noticks) values=(0 to 60 by 10)
   valueattrs=(color=gray33 size=9pt) labelattrs=(color=gray33 size=9pt)
   grid gridattrs=(color=graydd) offsetmin=0 offsetmax=0;
xaxis display=(noticks) values=(0 to 60 by 10)
   valueattrs=(color=gray33 size=9pt) labelattrs=(color=gray33 size=9pt)
   grid gridattrs=(color=graydd) offsetmin=0 offsetmax=0;
run;

Graphs

Here's a screen capture of a few of the graphs. Click the image below to see the interactive version, where you can hover your mouse over the markers to see the vehicle make & model, and click the markers to jump to a table showing all the details. (The interactive version has all vehicles - not just SUVs.)

Tables

The graphs above show that these vehicles tend to have similar MPG. And therefore they overprint each other in the graph. Therefore it is often helpful to look at the data in a table. When you click the markers in the graphs, it drills-down to a table like the one below. You can then click the model in the table to launch a Google search for that vehicle.

Final Decision

What SUVs have I narrowed it down to? ... I'm leaning towards a Jeep Renegade or Grand Cherokee, or a Subaru Outback or Forester. And how did MPG play into my decision? I guess when it came down to it, I gave more weight to other factors, than I did to MPG. But at least now I know! 🙂

 

Tags mpg SGPLOT
Share

About Author

Robert Allison

The Graph Guy!

Robert has worked at SAS for over a quarter century, and his specialty is customizing graphs and maps - adding those little extra touches that help them answer your questions at a glance. His educational background is in Computer Science, and he holds a BS, MS, and PhD from NC State University.

Related Posts

3 Comments

    • Robert Allison

      Yep - I've been following this data for *many* years, and I re-generate my plots as the new data becomes available (different manufacturers release the data at different times for the upcoming year).

      In this most recent round of graphs, I'm now using the new Proc SGplot, rather than Proc Gplot. 🙂

Back to Top