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

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

Question 3

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

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