search:

SAS(R) 9.2 SQL Procedure User's Guide

Product	Release
Base SAS	9.2

Deleting a Table

To delete a PROC SQL table, use the DROP TABLE statement:

proc sql;
   drop table sql.newcountries;