The LIBNAME Statement for Relational Databases

BL_KEEPNULLS= LIBNAME Option

Indicates how NULL values in Microsoft SQL Server columns that accept NULL are handled during bulk loading.

Default value:	YES
Valid in:	SAS/ACCESS LIBNAME statement
DBMS support:	OLE DB

Syntax

BL_KEEPNULLS=YES | NO

YES: specifies that Microsoft SQL Server preserves NULL values inserted by the OLE DB interface.
NO: specifies that Microsoft SQL Server replaces NULL values that are inserted by the OLE DB interface with a default value (as specified in the DEFAULT constraint).

This option only affects values in Microsoft SQL Server columns that accept NULL and have a DEFAULT constraint.