Question 1

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

Which clause in the following program is incorrect?

proc sql;

select age,mean(weight) as avgweight

from certadv.employees certadv.health

where employees.id=health.id

group by age;

quit;

Options :

A : SELECT

B : GROUP BY

C : FROM

D : WHERE

Answer: C

Question 4

What is the value of the column Position? Position=prxmatch('/Dutch/','Sawyer Dutch Kenai');

Options :

A : 8

B :

2

C : 7

D : 12

Answer: A

Question 5

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