SAS Certified Professional Prep Guide

Quiz

Select the best answer for each question. After completing the quiz, check your answers using the answer key in the appendix.

1. Which statement is false with respect to a set operation that uses the EXCEPT, UNION, or INTERSECT set operator without a keyword?

   1. Column names in the result set are determined by the first table.
   2. To be overlaid, columns must be of the same data type.
   3. To be overlaid, columns must have the same name.
   4. By default, only unique rows are displayed in the result set.
2. The keyword ALL cannot be used with which of the following set operators?

   1. EXCEPT
   2. INTERSECT
   3. UNION
   4. OUTER UNION
3. Which PROC SQL step combines the tables Certadv.Summer and Certadv.Winter to produce the output ...