Hands-On SAS for Data Analysis

Deleting

The general form of the DELETE statement is as follows:

  DELETE FROM table – name    <WHERE expression>;

Here, we have the following:

• The table name is the table whose records need to be deleted
• WHERE is an optional statement if only certain records from the table need to be deleted

We will try to subset the data before deleting it. Let's delete all the records that were created due to the looping exercise on the dealership data.

Run the following code:

Proc Sql;  Delete From Dealership_looped;               Where i gt 1;Quit;

Did you notice anything wrong in the preceding syntax? The semicolon is in the wrong place. Due to the semicolon before the WHERE clause, all the records will be deleted from the table. SAS won't throw an error, but after ...