The DBLOAD Procedure

RESET Statement

Resets column names and data types, and the ability to accept null values to their default values.

Restriction:	You must use the RESET statement after the LABEL statement for the LABEL statement to take effect.
Interaction:	DELETE, LABEL, RENAME
Note:	You can reset as many columns as you want in one RESET statement.

Syntax

Details

Example

Syntax

RESET ALL | variable-identifier-1<...variable-identifier-n>;

Details

If you specify ALL, all columns are reset to their default values. In addition, any deleted columns are restored with their default values. An editing statement, such as RESET, must be specified after the database-description statements when you create and load a PC file.

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.

Example

The RESET statement resets the column associated with the third SAS variable

RESET 3;