Chapter Contents
Previous
Next
|
Chapter Contents |
Previous |
Next |
| RESET |
| Optional statement | |
| Interacts with: | DELETE, LABEL, RENAME, TYPE |
| Syntax | |
| Details |
Syntax |
|
RESET ALL |
variable-identifier-1
<...variable-identifier-n>; |
The RESET statement resets the columns that are associated with
the listed SAS variables to the default DBMS column name, column data type,
and ability to accept null values. If you specify
ALL, all columns are reset
to their default values, and any dropped columns are restored with their default
values. The default values are as follows:
| column name | defaults to the SAS variable name, or to the SAS variable label (if you have used the LABEL statement). |
| column type | is generated from the SAS variable format. |
| nulls | uses the DBMS default value. |
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 reset the column associated with the third SAS variable, submit the following statement:
reset 3;
You can reset as many columns as you want in one RESET statement.
The RESET statement must be used after the LABEL statement for the LABEL statement to take effect.
An editing statement, such as RESET, 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 |
Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.