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 SAS log displays a message indicating that the table has been dropped:
Table 5.18 SAS Log 
NOTE: Table WORK.PAYROLLMASTER4 has been dropped.
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
13.58.220.83