The DBLOAD Procedure

RENAME Statement

Renames PC file columns that are associated with the listed SAS variables.
Alias: COLUMN
Restriction: An editing statement, such as RENAME, must be specified after the database-description statements when you create and load a PC file.
Interaction: DELETE, LABEL, RESET
Note: If you omit RENAME, column names default to the corresponding SAS variable names, unless you specify a LABEL statement.

Syntax

RENAME variable-identifier-1=column-name-1 <...variable-identifier-n=column-name-n>;

Details

The column-name must be a valid PC file column name. If the column name includes lowercase characters, special characters, or national characters, you must enclose the column name in quotation marks.
The variable-identifier can be a SAS variable name or the positional equivalent from the LIST statement. The positional equivalent is the number that represents where to place the variable in the data set.
You can rename as many variables as you want in one RENAME statement. The RENAME statement overrides the LABEL statement for columns that are renamed.

Example

The RENAME statement renames the column associated with the third SAS variable.
RENAME 3="employname";