Question 1

At the beginning of the execution phase, the value of _N_ is 1, the value of _ERROR_ is 0, and the values of the remaining variables are set to the following:

Options :

A : 1

B : 0

C : undefined

D : missing

Answer: D

Question 2

Which of the following statements can you use in a PROC PRINT step to create this output? 1-1

Options :

A : var month instructors; sum instructors aerclass walkjogrun swim;

B : var month; sum instructors aerclass walkjogrun swim;

C : all of the above

D : var month instructors aerclass; sum instructors aerclass walkjogrun swim;

Answer: B

Question 3

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

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 4

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 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

Free A00-231 Mock Exam – Practice Online Confidently

Buying Options: