Question 1

What happens when SAS cannot interpret syntax errors?

Options :

A : Data set variables contain missing values.

B : The DATA step still compiles, but it does not execute.

C : The DATA step does not compile.

D : The DATA step still compiles and executes.

Answer: B

Question 2

If you submit the following program, which output does it create?

proc sort data=cert.loans out=work.loans;

by months amount;

run;

proc print data=work.loans noobs;

var months amount payment;

sum amount payment;

where months<360;

run;

Options :

A :

B :

C :

D :

Answer: D

Question 3

In the data set Work.Invest, what would be the stored value for Year?

data work.invest;

do year=1990 to 2004;

Capital+5000;

capital+(capital*.10);

end;

run;

Options :

A : missing

B : 1990

C : 2005

D : 2004

Answer: C

Question 4

Which program contains an error?

Options :

A : proc print data=stresstest; label totaltime='Total Duration of Test'; drop sumsec; run;

B : data stresstest; set cert.tests; TotalTime=(timemin*60)+timesec; keep id totaltime tolerance; run;

C : proc print data=stresstest(keep=totaltime timemin); label totaltime='Total Duration of Test';run;

D : data stresstest(drop=timemin timesec); set cert.tests; TotalTime=(timemin*60)+timesec; SumSec+totaltime; run;

Answer: A

Question 5

Scenario:

The following code is submitted: data WORK.FINAL_EMPS; set WORK.EMPLOYEE WORK.NEW_EMPS; run; proc print data=WORK.FINAL_EMPS; title 'The RESULTS Data Set'; run; What is the resulting data set?

Options :

A : The RESULTS Data Set nameDeptage TomEngineering36 SallyHR42 Davidengineering30 Mary27

B :

The RESULTS Data Set nameDeptage TomEngineering36 SallyHR42 Davidengineering30 Maryengineering27

C : The RESULTS Data Set nameDeptage TomEngineering36 SallyHR42 Davidengineering30

D : The RESULTS Data Set nameDeptage Mary27 TomEngineering36 SallyHR42 Davidengineering30

Answer: A

Free A00-231 Mock Exam – Practice Online Confidently

Buying Options: