Question 1

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

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 4

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 5

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