SAS Certification Prep Guide, 4th Edition

Dropping Tables

Overview

To drop (delete) one or more entire tables, use the DROP TABLE statement.

General form, DROP TABLE statement: DROP TABLE table-name-1 <, ... table-name-n>; Here is an explanation of the syntax: table-name specifies the name of a table to be dropped, and can be one of the following: a one-level name a two-level libref.table name a physical pathname that is enclosed in single quotation marks.

Example

In the last few examples, you made several alterations to the temporary table Work.Payrollmaster4. Now you decide that you do not need this table anymore. The following PROC SQL step uses the DROP TABLE statement to drop Work.Payrollmaster4:

 proc sql;
    drop table work.payrollmaster4;

The ...