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

Complete the SELECT clause below to create a new column named Profit by subtracting the values of the column Cost from those of the column Price. select fruit,cost,price, ________________

Options :

A : Profit as price-cost

B : profit=price-cost

C : price-cost as Profit

Answer: C

Question 3

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

Options :

A :

B :

C :

D :

Answer: D

Question 4

Which of the following examples correctly defines a macro named Print that defines and resolves parameters named vars and total?

Options :

A :

B :

C :

D :

Answer: D

Question 5

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