Question 1

Given the STUDENTS data set below:

What will be the values for First. State and Last. State for Ellen's observation?

Options :

A : First. State=0 and Last. State=1

B : First. State=0 and Last.State=0

C : First. State=1 and Last. State=1

D : First. State=1 and Last.State=0

Answer: D

Question 2

Given the following code:

Which variables are created with the BY statement?

Options :

A : State. First and State. Last

B : First. State and Last. State

C : First_State and Last_State

D : First. and Last.

Answer: A

Question 3

Given the following SAS program:

What footnotes appear for the second PROC PRINY report?

Options :

A : Created by HR

B : Draft - Do Not Distribute

Create by HR

C : Draft –Do NOT Distribute

Answer: C

Question 4

Which statements read the input data set SASHELP. SHOES and create the output data set WORK. TOTAL?

Options :

A : data sashalp.shoes;

out work.total;

B : data sashelp.shoes;

output work.total;

C : data work.total;

set sashelp.shoes;

D : data out=work.total;

input sasholp.shoes

Answer: C

Question 5

The data set SASHELP. CARS contains information on different vehicles. How do you correctly write the observations with Type of 'SUV' to the suv data set and Type of 'Sedan' to the sedans data set?

Options :

A : data=SUV data=Sedans;

set sashelp.cars;

if Type = 'SUV' then output SUV;

else if Type = 'Sedan' then output Sedans;

run;

B : data SUV Sedans;

set sashelp.cars;

if Type = 'SUV' then output SUV;

else if Type = 'Sedan' then output Sedans;

run;

C : data SUV;

data Sedans;

set sashelp.cars;

if Type = SUV then output SUV;

else if Type = Sedan then output Sedans;

run;

D : data= (SUV Sedans) ;

set sashelp.cars;

if Type = 'SUV' then output SUV;

else if Type = 'Sedan' then output Sedans;

run;

Answer: B