SAS Certified Professional Prep Guide

Chapter 5: Using Subqueries

1. Correct answer: d

   To remove duplicate values from PROC SQL output, you specify the DISTINCT keyword before the column name in the SELECT clause.
2. Correct answer: d

   To list rows that have no data (that is, missing data), you can use either of these other conditional operators: IS MISSING or IS NULL. The NOT EXISTS operator is used specifically with a subquery, and resolves to true if the subquery returns no values to the outer query.
3. Correct answer: b

   When a WHERE clause references a new column that was defined in the SELECT clause, the WHERE clause must specify the keyword CALCULATED before the column name.
4. Correct answer: c

   To determine how PROC SQL calculates and displays output from summary functions, ...