Chapter Contents

Previous

Next
RENAME

RENAME



Modifies the SAS variable name.

Optional statement
Applies to: access descriptor or view descriptor
Interacts with: ASSIGN, RESET


Syntax
Details

Syntax

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

Details

The RENAME statement sets or modifies the SAS variable name that is associated with a DBMS column. The RENAME statement can be used when creating an access descriptor or a view descriptor.

An editing statement, such as RENAME, must follow the CREATE or UPDATE statement and the database connection statements when you create or update a descriptor. See CREATE for more information on the order of statements.

Two factors affect the use of the RENAME statement: whether you specify the ASSIGN statement when you are creating an access descriptor, and the kind of descriptor you are creating.

The column-identifier argument can be either the DBMS column name or the positional equivalent from the LIST statement, which is the number that represents the column's place in the descriptor. For example, to rename the SAS variable names that are associated with the seventh column and the nine-character FIRSTNAME column in a descriptor, submit the following statement:

rename 7 birthdy  'firstname'=fname;

The DBMS column name (or positional equivalent) is specified on the left side of the expression, with the SAS variable name on the right side. The equal sign (=) is optional. If the column name contains lowercase characters, special characters, or national characters, enclose the name in quotes. You can rename as many columns as you want in one RENAME statement.

When you are creating a view descriptor, the RENAME statement automatically selects the renamed column for the view. That is, if you rename the SAS variable associated with a DBMS column, you do not have to issue a SELECT statement for that column.


Chapter Contents

Previous

Next

Top of Page

Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.