SAS Certified Professional Prep Guide

Chapter 1: PROC SQL Fundamentals

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: the SELECT clause, the FROM clause, and the ORDER BY clause.
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 ...