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 ...

Get SAS Certification Prep Guide, 4th Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial