Data Set Options for Microsoft SQL Server

All SAS/ACCESS data set options in this table are supported for Microsoft SQL Server. Default values are provided where applicable. For details, see Data Set Options for Relational Databases.

SAS/ACCESS Data Set Options for Microsoft SQL Server
Option	Default Value
BL_ACCOUNTNAME=	LIBNAME option value
BL_APPLICATIONID=	LIBNAME option value
BL_COMPRESS=	LIBNAME option value
BL_DEFAULT_DIR=	LIBNAME option value
BL_DELETE_DATAFILE=	LIBNAME option value
BL_DELIMITER=	LIBNAME option value
BL_DNSSUFFIX=	LIBNAME option value
BL_FILESYSTEM=	LIBNAME option value
BL_FOLDER=	LIBNAME option value
BL_IDENTITY=	LIBNAME option value
BL_LOG=	LIBNAME option value
BL_MAXERRORS=	LIBNAME option value
BL_NUM_DATAFILES=	2
BL_OPTIONS=	LIBNAME option value
BL_SECRET=	LIBNAME option value
BL_TIMEOUT=	LIBNAME option value
BL_USE_ESCAPE=	LIBNAME option value
BL_USE_LOG=	LIBNAME option value
BULKLOAD=	LIBNAME option value
CURSOR_TYPE=	LIBNAME option value
DATETIME2=	NO
DBCOMMIT=	LIBNAME option value
DBCONDITION=	none
DBCREATE_TABLE_OPTS=	LIBNAME option value
DBFORCE=	NO
DBGEN_NAME=	DBMS
DBINDEX=	NO
DBKEY=	none
DBLABEL=	NO
DBLARGETABLE=	none
DBMAX_TEXT=	1024
DBNULL=	YES
DBNULLKEYS=	LIBNAME option value
DBNULLWHERE=	LIBNAME option value
DBPROMPT=	LIBNAME option value
DBSASLABEL=	COMPAT
DBSASTYPE=	see Data Types for Microsoft SQL Server
DBSLICE=	none
DBSLICEPARM=	NONE
DBTYPE=	see Data Types for Microsoft SQL Server
ERRLIMIT=	1
IGNORE_READ_ONLY_COLUMNS=	NO
INSERT_SQL=	LIBNAME option value
INSERTBUFF=	LIBNAME option value
KEYSET_SIZE=	LIBNAME option value
NULLCHAR=	SAS
NULLCHARVAL=	a blank character
POST_STMT_OPTS=	none
POST_TABLE_OPTS=	none
PRE_STMT_OPTS=	none
PRE_TABLE_OPTS=	none
PRESERVE_COL_NAMES=	LIBNAME option value
QUALIFIER=	LIBNAME option value
QUERY_TIMEOUT=	LIBNAME option value
READBUFF=	LIBNAME option value
READ_ISOLATION_LEVEL=	LIBNAME option value
READ_LOCK_TYPE=	LIBNAME option value
SASDATEFMT=	none
SCANSTRINGGCOLUMNS=	LIBNAME option value
SCHEMA=	LIBNAME option value
UPDATE_ISOLATION_LEVEL=	LIBNAME option value
UPDATE_LOCK_TYPE=	LIBNAME option value
UPDATE_SQL=	LIBNAME option value

Last updated: February 3, 2026