Question 1

Which PROC MEANS program creates the report below?

Options :

A : proc means data-sashelp. shoes sum mean;

var Sales;

Class Product;

run;

B : proc means data=sashelp. 'shoes

var Sale;

group Product;

run/

C : Pror moans data-uashelp . shoes sum mean nobe;

by sales;

class product

D : proc means data-esea= ashelp. shoes.

sum Salad;

mean Sales;

by product;

run."

Answer: A

Question 2

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 3

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 4

Which PROC MEANS program creates the report below?

Options :

A : proc means data-sashelp. shoes sum mean;var Sales;Class Product;run;

B : proc means data=sashelp. 'shoesvar Sale;group Product;run/

C : Pror moans data-uashelp . shoes sum mean nobe;by sales;class product

D : proc means data-esea= ashelp. shoes.sum Salad;mean Sales;by product;run."

Answer: A

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: