DBLOAD Procedure

DELETE Statement

drops the specified SAS variables before the DBMS table is created

Tip: When you drop a variable, 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. If you drop more than one variable, separate the identifiers with spaces, not commas.

Syntax

Required Argument

variable-identifier

specifies 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 this statement: delete 3;

Last updated: February 3, 2026