Question

Do this problem entirely in PROC SQL with the permanent SAS data set sashelp.cars.

• Extract all Ford vehicles into a temporary SAS data set called Fords, but do not display it.
• Query the data set Fords to display the mean vehicle weight grouped by vehicle type.
• Query the data set Fords to display the model name, vehicle weight and the average

Answer 1

The student is asked to use PROC SQL in SAS to manipulate the sashelp.cars dataset, specifically to extract data for Ford vehicles and then calculate and display the mean weight according to vehicle type, as well as the model name, individual weight, and average weight.

Step-by-step explanation:

The question involves using PROC SQL in SAS to work with the sashelp.cars dataset and manipulate it to obtain specific outputs related to Ford vehicles.

The steps include extracting Ford vehicles into a temporary dataset called Fords, then querying this dataset to calculate the mean vehicle weight by vehicle type, and finally, displaying the model name along with the vehicle weight and average weight.

A typical way to solve the first part of this problem would be:

proc sql;
create table Fords as
select *
from sashelp.cars
where Make='Ford';
quit;

To display the mean vehicle weight grouped by vehicle type from the Fords dataset:

proc sql;
select Type, mean(Weight) as MeanWeight
from Fords
group by Type;
quit;

Lastly, to display the model name, vehicle weight, and the average:

proc sql;
select Model, Weight, (select mean(Weight) from Fords) as AverageWeight
from Fords;
quit;