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