Deleting a Data Table

Overview of Deleting a Data Table

Data tables can be deleted only from the SAS Metadata Repository using SAS Management Console. Data tables cannot be deleted from SAS Model Manager using the Data Sources view. If the data table's metadata is deleted from the SAS Metadata Repository using SAS Management Console or the operating system, SAS Model Manager cannot access the data table to view data or to perform any reporting or scoring tasks. In this case, an error message appears.

Note: Only a SAS Administrator or a user with Delete permission can delete data tables using SAS Management Console.

Delete a Data Table in SAS Management Console

To delete a data table in SAS Management Console, follow these steps:

Start SAS Management Console. Connect to your preferred SAS Metadata Repository.
On the Plug-ins tab, expand the following folders:

Environment ManagementData Library ManagerLibraries.
Select the library that contains the data table that you want to delete.
Right-click the data table name in the right pane, and then select Delete from the pop-up menu. The Delete Table dialog box is displayed.
Click OK to delete the data table. The data table is removed from the SAS Metadata Repository library, but it is not physically removed from the operating system.

For more information, see SAS Management Console Help or the SAS Intelligence Platform: System Administration Guide.