DELETE

DELETE

Does not load specified variables into the new database

Optional statement

Applies to: New database

Syntax
Details

Syntax

DELETE variable-identifier<...variable-identifier-n>;

Details

The DELETE statement indicates you want to delete (drop) the specified variables from the load. By default, all SAS variables will be loaded unless you specify a DELETE statement.

The variable-identifier can be either the SAS variable name or the positional equivalent in the LIST output, which is the number that represents the variable's place in the data file. For example, if you want to delete the third variable, issue the following statement:

    delete 3;

You can delete as many variables as you want in one DELETE statement. If you delete more than one variable, separate the identifiers with spaces, not commas.

Note: Even if you delete a variable from the table, this does not change the positional equivalents of the variables. For example, if you delete the second variable, the third variable is still referenced by the number 3, not 2. [cautionend]

Chapter Contents
Previous
Next
Top of Page