Previous Page | Next Page

The ACCESS Procedure for Relational Databases

ASSIGN Statement


Indicates whether SAS variable names and formats are generated
Applies to: access descriptor
Interaction: FORMAT, RENAME, RESET, UNIQUE
Default: NO

ASSIGN <=>YES | NO | Y | N;

YES

generates unique SAS variable names from the first eight characters of the DBMS column names. If you specify YES , you cannot specify the RENAME, FORMAT, RESET, or UNIQUE statements when you create view descriptors that are based on the access descriptor.

NO

lets you modify SAS variable names and formats when you create an access descriptor and when you create view descriptors that are based on this access descriptor.


Details

The ASSIGN statement indicates how SAS variable names and formats are assigned:

Each time the SAS/ACCESS interface encounters a CREATE statement to create an access descriptor, the ASSIGN statement is reset to the default NO value.

When you create an access descriptor, use the RENAME statement to change SAS variable names and the FORMAT statement to change SAS formats.

When you specify YES, SAS generates names according to these rules:

Previous Page | Next Page | Top of Page