SAS Certified Professional Prep Guide

Chapter 6: Advanced SQL Techniques

1. Correct answer: a

   You can use the INTO clause to create one or more macro variables in the SELECT clause. The INTO keyword is followed by a colon (:) and then the macro variable name.
2. Correct answer: c

   You cannot create a macro variable in the same SQL step in which you are calling the macro variable. To create a report that does not contain any duplicate items including the values in the macro variable, use the DISTINCT keyword in the SELECT clause.
3. Correct answer: d

   When storing a value in a single macro variable, PROC SQL preserves leading or trailing blanks. You can use the TRIMMED option in the INTO clause to remove the leading and trailing blanks. Use the INTO keyword followed by a colon ...