SAS Certification Prep Guide, 4th Edition

Quiz

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?

   

   

   1. proc sql nonumber outobs=10; ...