Quiz

Select the best answer for each question. After completing the quiz, check your answers using the answer key in the appendix.
  1. A Cartesian product is returned when
    1. join conditions are not specified in a PROC SQL join.
    2. join conditions are not specified in a PROC SQL set operation.
    3. more than two tables are specified in a PROC SQL join.
    4. the keyword ALL is used with the OUTER UNION operator.
  2. Given the PROC SQL query and tables shown below, which output is generated? 
    proc sql;
   select *
      from store1, 
      store2
      where store1.wk=
            store2.wk;
    Store 1 and Store 2 Tables
  3. Given the PROC SQL query and tables ...

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

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial