Select the best answer for each question. After completing the quiz, check your answers using the answer key in the appendix.
  1. PROC SQL options are specified in
    1. the PROC SQL statement.
    2. an OPTIONS statement.
    3. a SELECT statement.
    4. the OPTIONS procedure.
  2. Which of the following SQL options restricts the number of rows that PROC SQL takes as input from any single source?
    1. OUTOBS=
    2. INOBS=
    3. OBS=
    4. none of the above
  3. Which PROC SQL step creates the output shown below?
    Table with EmpID, JobCode, LastName, FirstName columns
    Table with row numbers
    1. proc sql nonumber outobs=10; ...

Get SAS Certification Prep Guide, 4th Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.