Chapter 5: Creating and Managing Tables Using PROC SQL

1. Which of the following PROC SQL steps creates a table that contains rows for the level-1 flight attendants only?

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.

Explanation

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.

2. Which of the following statements is used to add new rows to a table?

INSERT

LOAD

VALUES

CREATE TABLE

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.

Explanation

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.

3. Which of the following creates an empty table that contains the 2 columns FullName and Age?

Proc sql; create table work.names (FullName char(25), Age num);

Proc sql; create table work.names as (FullName char(25), Age num);

Proc sql; create work.names (FullName char(25), Age num);

Proc sql; create table work.names set (FullName char(25), Age num);

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.

Explanation

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.

4. Which of the following statements is true regarding the UNDO_POLICY=REQUIRED option?

It must be used with the REQUIRED integrity constraint.

UNDO POLICY=REQUIRED is the default setting for PROC SQL. This setting undoes all inserts or updates if 1 or more rows violate the integrity constraint criteria, and restores the table to its original state before the inserts or updates.

Explanation

UNDO POLICY=REQUIRED is the default setting for PROC SQL. This setting undoes all inserts or updates if 1 or more rows violate the integrity constraint criteria, and restores the table to its original state before the inserts or updates.

5. Which of the following is not a type of integrity constraint?

CHECK

NULL

UNIQUE

PRIMARY KEY

The NOT NULL integrity constraint specifies that data is required and cannot have a null (missing) value.

Explanation

The NOT NULL integrity constraint specifies that data is required and cannot have a null (missing) value.

6. Which of the following displays the structure of a table in the SAS log?

Proc sql; describe contents sasuser.payrollmaster;

Proc sql; describe table sasuser.payrollmaster;

Proc sql; describe * from sasuser.payrollmaster;

The DESCRIBE TABLE statement lists the column attributes for a specified table.

Explanation

The DESCRIBE TABLE statement lists the column attributes for a specified table.

7. Which of the following PROC SQL steps creates a new table by copying only the column structure (but not the rows) of an existing table?

Proc sql; create table work.newpayroll like sasuser.payrollmaster;

Proc sql; create table work.newpayroll copy sasuser.payrollmaster;

Proc sql; create table work.newpayroll describe sasuser.payrollmaster;

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.

Explanation

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.

8. Which of the following PROC SQL steps gives bonuses (in points) to frequent-flyer program members as follows:

a 50% bonus for members who traveled less than 10,000 miles
a 100% bonus for members who traveled 10,000 miles or more?

The UPDATE statement that includes a SET clause is used to modify rows in a table. WHEN-THEN clauses in the CASE expression enable you to update a column value based on specified criteria.

Explanation

The UPDATE statement that includes a SET clause is used to modify rows in a table. WHEN-THEN clauses in the CASE expression enable you to update a column value based on specified criteria.

9. Which of the following statements regarding the ALTER TABLE statement is false?

It allows you to update column attributes.

It allows you to add new columns in your table.

It allows you to drop columns in your table.

It allows you to change a character column to a numeric column.

The ALTER TABLE statement is used to modify attributes of existing columns (include the MODIFY clause), add new column definitions (include the ADD clause), or delete existing columns (include the DROP clause).

Explanation

The ALTER TABLE statement is used to modify attributes of existing columns (include the MODIFY clause), add new column definitions (include the ADD clause), or delete existing columns (include the DROP clause).

10. Which of the following PROC SQL steps deletes rows for all frequent-flyer program members who traveled less than 10,000 miles?

The DELETE statement deletes rows that are specified in the WHERE clause from the table. If no WHERE clause is specified, all rows are deleted. The DROP TABLE statement drops (deletes) an entire table; the syntax shown in option c is not valid.

Explanation

The DELETE statement deletes rows that are specified in the WHERE clause from the table. If no WHERE clause is specified, all rows are deleted. The DROP TABLE statement drops (deletes) an entire table; the syntax shown in option c is not valid.

Chapter 5: Creating And Managing Tables Using Proc SQL