SAS Certification Prep Guide, 4th Edition

Chapter 1: Performing Queries Using PROC SQL

1. Correct answer: a

   The SELECT clause in the program is written incorrectly. Columns that are listed in the clause must be separated by commas, not just blanks.
2. Correct answer: a

   There are two statements, the PROC SQL statement and the SELECT statement. The SELECT statement contains three clauses.
3. Correct answer: b

   The SELECT clause lists the columns from both tables to be queried. You must use a prefix with the Address column because it appears in both tables. The prefix specifies the table from which you want the column to be read.
4. Correct answer: b

   The ORDER BY clause specifies how the rows are to be sorted. You follow the keywords ORDER BY by one or more column names or numbers, ...