The CREATE TABLE statement
enables you to store your results in a SAS table instead of displaying
the query results as a report.
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.
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.
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 SQL, VALUES is a clause, and the CREATE
TABLE statement is used to create a table.
Correct answer: b
The DESCRIBE TABLE statement
lists the column attributes for a specified table.
Correct answer: a
The CREATE TABLE statement
can include column specifications to create an empty table. The entire
group of column specifications must be enclosed in a single set of
parentheses. You must list each column's name, data type, and
(for character columns) length. The length is specified as an integer
in parentheses. Multiple column specifications must be separated by
commas.