Question 1

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 2

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

Question 3

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 4

What happens if you merge the following data sets by the variable SSN?

Options :

A : The values of Age in the data set 2nd are set to missing.

B :

The values of Age in the data set 1st overwrite the values of Age in the data set 2nd.

C : The DATA step fails because the two data sets contain same-named variables that have different values.

D :

The values of Age in the data set 2nd overwrite the values of Age in the data set 1st.

Answer: D

Question 5

Which of the following statements store your formats in a permanent catalog?

Options :

A :

formtlib='C:\\Users\\Student1\\sas\\formats\\lib';

proc format formtlib ...;

B :

formtlib='C:\\Users\\Student1\\sas\\formats\\lib';

proc formtlib ...;

C :

libname formtlib 'C:\Users\Student1\sas\formats\lib';

proc format lib=formtlib ...;

D :

libname formtlib 'C:\Users\Student1\sas\formats\lib';

format lib=formtlib ...;

Answer: C

Confidently Practice Online with Free A00-231 Exam Cram

Buying Options: