BL_KEEPIDENTITY= Data Set Option

Determines whether the identity column that is created during bulk loading is populated with values that Microsoft SQL Server generates or with values that the user provides.

Valid in: DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
Categories: Bulk Loading
Data Set Control
Default: LIBNAME option value
Restriction: This option is valid only when you use the Microsoft SQL Server provider.
Requirement: To specify this option, you must first specify BULKLOAD=YES.
Data source: OLE DB
See: BL_KEEPIDENTITY= LIBNAME option, BULKLOAD= data set option

Table of Contents

Syntax

BL_KEEPIDENTITY=YES | NO

Syntax Description

YES

specifies that the user must provide values for the identity column.

NO

specifies that the Microsoft SQL Server generates values for an identity column in the table.

Last updated: February 3, 2026