1. Input and Output Data SetsThe 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:data ; set ; keep ; total = ;run;1. Multiple Data SetsThe 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:data work.female(drop=height) work.everyone(keep=name weight height); set sashelp.class; if sex=’F’ then output work.female; output work.everyone;run;
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?