SAS Certified Professional Prep Guide

Chapter 2: Creating and Managing Tables

1. Correct answer: c

   The CREATE TABLE statement enables you to store your results in a SAS table instead of displaying the query results as a report.
2. Correct answer: b

   The CREATE TABLE statement that includes a LIKE clause copies the column names and attributes from an existing table into a new table. No rows of data are inserted.
3. Correct answer: a

   The CREATE TABLE statement that includes the AS keyword and query clauses creates a table and loads the results of the query into the new table. The WHERE clause selects only the rows for the level-1 flight attendants.
4. Correct answer: a

   The INSERT statement is used to insert new rows into a new or existing table. There is no LOAD statement in PROC ...