Use DROP TABLE statements to delete a table and all the data it contains from SAS Data Sets.

DROP TABLE Syntax

The DROP TABLE statement accepts the name of the table to delete, as shown in the following example:

DROP TABLE [ IF EXISTS ] <table_name> 

The following query deletes all MyCustomers data from the server:

DROP TABLE IF EXISTS MyCustomers

Note: DROP TABLE is only supported for tables that correspond to local files in SAS Data Sets. This functionality is not available for cloud-based data sources.