Sports Utility Vehicle drivers from across the United States were randomly selected to participate in a study of mileage and gasoline use. Each driver was asked to track the city
DataSet is in the folder
Sports Utility Vehicle drivers from across the United States were randomly selected to
participate in a study of mileage and gasoline use. Each driver was asked to track the city
and highway mileage of their vehicle for seven consecutive days. The SAS data set called
GASMILEAGE includes data about the make and model of the vehicle, advertised gas
mileage, and seven day driving mileage.
a. Examine the names, labels, and attributes of the variables in the SAS data set
GASMILEAGE. Create a data set that subsets these data to the state you live in (or
the state of your choice).
b. Calculate the average daily city miles driven by each driver during the test week and
round this variable to one decimal place. Repeat this for average highway miles.
c. Use the total mileage recorded during the test week and the corresponding
advertised mileage for the vehicle to calculate the total combined number of gallons
consumed in the city and on the highway.
d. Calculate the cost during the test week by using the total gallons consumed and the
current average price of regular gasoline for the state you chose in part a). Round
this variable to two decimal places.
e. Using the cost that you calculated, estimate the number of weeks that it will take
each driver to spend $1,000 on gasoline.
f. View the resulting data set. In a comment in your program, find the first observation
and state the plate ID, average city and highway mileage, cost, and number of weeks
to spend $1,000.(I need this to be done in SAS)