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

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

Question 3

Which sentence is true regarding the VALUE statement in the FORMAT procedure?

Options :

A : The keyword UNKNOWN can be specified on the VALUE statement.

B : Numeric format names in the VALUE statement must begin with a $ sign.

C : The VALUE statement can create numeric and character formats.

D : The VALUE statement uses the LIB= option to specify the location of the format.

Answer: C

Question 4

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

Question 5

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

Free A00-215 Mock Exam – Practice Online Confidently

Buying Options: