The DBLOAD Procedure

DELETE Statement

Prevents variables from being loaded into the new PC file.

Restriction:	An editing statement, such as DELETE, must be specified after the database-description statements when you create and load a file.
Interaction:	RENAME, RESET

Syntax

Details

Example

Syntax

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

Details

The DELETE statement deletes the specified SAS variables from the PC file being created. The variable-identifier can be either the SAS variable name or the positional equivalent from a LIST statement. The positional equivalent is the number that represents the variable's place in the data set.

For example, if you want to delete the third variable, submit this 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.

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

Example

The DELETE statement deletes the third variable. The RENAME statement, includes the third variable, assigns the default type, and assigns EMPNAME as the name. The RENAME statement enables you to include variables that you have previously deleted.

DELETE 3; RENAME 3='empname';