1. Input and Output Data Sets
The SAS data set company.sales has three variables (product, price, and quantity). A new data set work.sales must be created. The new data set needs to contain two variables (product and total). The variable total is the result of price multiplied by quantity.
Complete the following program based on the previous scenario:
total = ;
1. Multiple Data Sets
The SAS data set sashelp.class has five variables (name, sex, age, height, and weight) and 19 observations (9 observations with sex=’F’ and 10 observations with sex=’M’).
Answer the questions based on the previous information and the following program:
work.everyone(keep=name weight height);
if sex=’F’ then output work.female;
a. What is the input data set?
b. How many output data sets are being created?
c. How many observations are in work.female?
d. How many observations are in work.everyone?
e. What variables are in work.female?