Data Set Options for Spark

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

SAS/ACCESS Data Set Options for Spark
Option	Default Value
ANALYZE=	LIBNAME option value
BL_ACCOUNTNAME=	LIBNAME option value
BL_APPLICATIONID=	LIBNAME option value
BL_AWS_CONFIG_FILE=	~/.aws/config (UNIX) C:\Users\<userid>\.aws\config (Windows)
BL_AWS_CREDENTIALS_FILE=	~/.aws/credentials (UNIX) C:\Users\<userid>\.aws\credentials (Windows)
BL_AWS_PROFILE_NAME=	none
BL_BUCKET=	none
BL_COMPRESS=	NO
BL_CONFIG=	none
BL_DEFAULT_DIR=	temporary file directory that the UTILLOC= system option specifies
BL_DELETE_DATAFILE=	YES
BL_DELIMITER=	comma
BL_DNSSUFFIX=	LIBNAME option value
BL_ENCKEY=	none
BL_FILESYSTEM=	LIBNAME option value
BL_FOLDER=	none
BL_FORMAT=	Databricks: CSV Spark in HDFS: Text
BL_FORMAT_OPT=	none
BL_IAM_ASSUME_ROLE_ARN=	none
BL_IAM_ASSUME_ROLE_NAME=	none
BL_IAM_ROLE=	none
BL_KEY=	none
BL_NUM_DATAFILES=	2
BL_REGION=	none
BL_TIMEOUT=	LIBNAME option value
BL_TOKEN=	none
BL_USE_SSL=	none
BULKLOAD=	YES
BULKUNLOAD=	NO
COLUMN_DELIMITER=	\001 (Ctrl-A)
DBCONDITION=	none
DBCREATE_TABLE_EXTERNAL=	NO
DBCREATE_TABLE_LOCATION=	depends on how your Hadoop cluster is configured
DBCREATE_TABLE_OPTS=	LIBNAME option value
DBFORCE=	NO
DBGEN_NAME=	DBMS
DBLARGETABLE=	none
DBMAX_TEXT=	1024
DBMAX_TEXT_TYPES=	LONG
DBSASLABEL=	COMPAT
DBSASTYPE=	see Data Types for Spark
DBTYPE=	see Data Types for Spark
INSERTBUFF=	LIBNAME option value
POST_STMT_OPTS=	none
POST_TABLE_OPTS=	none
PRE_STMT_OPTS=	none
PRE_TABLE_OPTS=	none
QUERY_TIMEOUT=	LIBNAME option value
READBUFF=	LIBNAME option value
SASDATEFMT=	see Data Types for Spark
SCHEMA=	LIBNAME option value
SCRATCH_DB=	none
SUB_CHAR=	none
TRANSCODE_FAIL=	ERROR

Last updated: February 3, 2026