DELETE

DELETE

Does not load specified variables into the new table.

Optional statement

Syntax
Details

Syntax

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

Details

The DELETE statement drops the specified SAS variables before the DBMS table is created. The variable-identifier argument can be either the SAS variable name or the positional equivalent from the LIST statement. The positional equivalent is the number that represents the variable's place in the data set. For example, if you want to drop the third variable, submit the following statement:

delete 3;

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

Even if you drop a variable from the list of variables, the positional equivalents of the variables do not change. For example, if you drop the second variable, the third variable is still referenced by the number 3, not 2.

An editing statement, such as DELETE, must be specified after the database connection statements when you create and load a DBMS table. See LOAD for more information.

Chapter Contents
Previous
Next
Top of Page