specifies columns to be used to simulate an identity column.
| Valid in: | DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software) |
|---|---|
| Category: | Data Set Control |
| Default: | none |
| Interaction: | The format of the user sequence for this option depends on the value of BULKLOAD. |
| Data source: | Oracle |
| Note: | Support for this data set option was added for SAS 9.4. |
| See: | BULKLOAD= data set option, , BULKLOAD= LIBNAME option |
Table of Contents
specifies the name of an identity column.
specifies the expression that is used to generate the identity column values.
When BULKLOAD=YES, the user sequence should take the following form:
sequence(max,n)When BULKLOAD=NO, the user sequence should take the following form:
<user-created-sequence>.nextvalWhen BULKLOAD=YES, you
provide the name of an identity column and the expression that is
used to generate identity values. You provide the expression in the
form sequence(max,n). This expression says
that the values in the identity column are generated by taking the
maximum identity value and adding the value n.
For example, the expression sequence(max,2) increments
generated identity values by 2.
When BULKLOAD=NO, you
provide the name of an identity column and the expression that identifies
the identity values. You provide the expression in the form user-created-sequence.nextval,
such as t1_id.nextval.