Question 1

Which of the following is false?

Options :

A : By default, the INTO clause in PROC SQL does not remove leading and training blanks before assigning macro variable values.

B : The SYMPUTX routine can be used to create a macro variable during execution of the DATA step.

C : In the DATA step, the SYMPUTX routine automatically converts numeric values to character strings before assigning values to macro variables.

D : The SYMPUTX routine can be used to create a macro variable during execution of a PROC SQL query.

Answer: D

Question 2

Which of the following is false?

Options :

A : By default, the INTO clause in PROC SQL does not remove leading and training blanks before assigning macro variable values.

B : The SYMPUTX routine can be used to create a macro variable during execution of the DATA step.

C : In the DATA step, the SYMPUTX routine automatically converts numeric values to character strings before assigning values to macro variables.

D : The SYMPUTX routine can be used to create a macro variable during execution of a PROC SQL query.

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

If a substring is not found in a string, the FIND function returns which value?

Options :

A : 0

B : 2

C : 1

D : Not found.

Answer: A

Question 5

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

Free A00-232 Mock Exam – Practice Online Confidently