Chapter Contents

Previous

Next
UNIQUE

UNIQUE



Generates SAS variable names based on DBMS column names.

Optional statement
Applies to: view descriptor
Interacts with: ASSIGN


Syntax
Details

Syntax

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

Details

The UNIQUE statement specifies whether the SAS/ACCESS interface should generate unique SAS variable names for DBMS columns for which SAS variable names have not been entered.

An editing statement, such as UNIQUE, must follow the CREATE statement when you create a view descriptor. See CREATE for more information on the order of statements.

Note:   The UNIQUE statement cannot be used with the UPDATE statement.  [cautionend]

The UNIQUE statement is affected by whether you specified the ASSIGN statement when you created the access descriptor on which the view is based, as follows:

If duplicate SAS variable names exist in the access descriptor on which you are creating a view descriptor, you can specify UNIQUE to resolve the duplication. When you specify UNIQUE=YES, the SAS/ACCESS interface appends numbers to any duplicate SAS variable names, thus making each variable name unique. (See the rules for default SAS names in ASSIGN.)

If you specify UNIQUE=NO, the SAS/ACCESS interface continues to allow duplicate SAS variable names to exist. You must resolve these duplicate names before saving (and thereby creating) the view descriptor.

Note:   It is recommended that you use the UNIQUE statement and specify UNIQUE=YES . If you omit it or specify UNIQUE=NO and the SAS System encounters duplicate SAS variable names in a view descriptor, your job fails.  [cautionend]

The equals sign (=) is optional in the UNIQUE statement. UN is the alias for UNIQUE.


Chapter Contents

Previous

Next

Top of Page

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