The ACCESS Procedure for Relational Databases UNIQUE Statement 307
If you have multiple selection criteria, enter them all in one SUBSET statement, as
in the following example:
subset where firstorder is not null
and country = ’USA’
order by country;
Unlike other ACCESS procedure statements, the SUBSET statement is case
sensitive. The SQL statement is sent to the DBMS exactly as you type it. Therefore,
you must use the correct case for any DBMS object names. See the SAS/ACCESS
documentation for your DBMS for details.
SAS does not check the SUBSET statement for errors. The statement is verified only
when the view descriptor is used in a SAS program.
If you specify more than one SUBSET statement per view descriptor, the last
SUBSET overwrites the earlier SUBSETs. To delete the selection criteria, submit a
SUBSET statement without any arguments.
TABLE= Statement
Identifies the DBMS table on which the access descriptor is based
Applies to:
access descriptor
TABLE= <’>table-name<’>;
table-name
a valid DBMS table name. If it contains lowercase characters, special characters, or
national characters, you must enclose it in quotation marks. See the SAS/ACCESS
documentation for your DBMS for details on the TABLE= statement.
Details
This statement is required with the CREATE statement and optional with the
UPDATE statement.
UNIQUE Statement
Generates SAS variable names based on DBMS column names
Applies to: view descriptor
Interacts with: ASSIGN
UNIQUE <=> YES | NO | Y | N;
