322 RESET Statement Appendix 2
Details
The RENAME statement changes the names of the DBMS columns that are
associated with the listed SAS variables. If you omit the RENAME statement, all the
DBMS column names default to the corresponding SAS variable names (unless the
LABEL statement is specified).
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 rename
the column associated with the third SAS variable, submit the following statement:
rename 3=employeename;
Note: The column-name argument must be a valid DBMS column name. If the
column name includes lowercase characters, special characters, or national characters,
you must enclose the column name in single or double quotation marks. If no quotation
marks are used, the DBMS column name is created in uppercase. To preserve case, use
the following syntax:
rename 3=’"employeename"’
The RENAME statement enables you to include variables that you have previously
deleted. For example, suppose you submit the following statements:
delete 3;
rename 3=empname;
The DELETE statement drops the third variable. The RENAME statement includes
the third variable and assigns the name
EMPNAME and the default column type to it.
You can list as many variables as you want in one RENAME statement. The
RENAME statement overrides the LABEL statement for columns that are renamed.
COLUMN is an alias for the RENAME statement.
RESET Statement
Resets column names and data types to their default values
Interacts with:
DELETE, LABEL, RENAME, TYPE
RESET ALL | variable-identifier-1 <…variable-identifier-n>;
Details
The RESET statement resets the columns that are associated with the listed SAS
variables to the default values for 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
