DELETE

DELETE

Prevents variables from being loaded into the new PC file.

Optional statement

Interacts with: RENAME, RESET

Syntax
Details

Syntax

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

Details

The DELETE statement drops the specified SAS variables from the PC file being 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-description statements when you create and load a file. See LOAD for more information.

Chapter Contents
Previous
Next
Top of Page