Question 1

According to the global symbol table shown here, what value will a reference to &&teach&crs resolve to?

Options :

A : TEACH3

B : Forest, Mr. Peter

C : None of the above.

D : &TEACH3

Answer: B

Question 2

Which PROC SQL step generates the following output from the tables Certadv.Dogs and Certadv.Pets?

Options :

A :

B :

C :

D :

Answer: D

Question 3

What value will these statements assign to the macro variable Reptile?%let area = "Southeast";%let reptitle = * Sales Report for &area Area *;

Options :

A : * Sales Report for "Southeast" Area *

B : Sales Report for Southeast Area

C : Sales Report for "Southeast" Area

D : *Sales Report for 'Southeast' Area*

Answer: A

Question 4

In which step does the SAS hash object exist?

Options :

A : OPTIONS

B : PROC step

C : a and b only.

D : DATA step

Answer: D

Question 5

The keyword ALL cannot be used with which of the following set operators?

Options :

A : OUTER UNION

B : UNION

C : EXCEPT

D : INTERSECT

Answer: A

Free A00-232 Mock Exam – Practice Online Confidently