Data Set Options for Hadoop

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

SAS/ACCESS Data Set Options for Hadoop

Option

Default Value

ANALYZE= data set option

LIBNAME option value

BL_FORMAT= data set option

TEXT

BULKLOAD=

YES

COLUMN_DELIMITER=

\001 (Ctrl-A)

DBCONDITION=

none

DBCREATE_TABLE_EXTERNAL=

NO

DBCREATE_TABLE_LOCATION=

depends on your Hadoop cluster configuration

DBCREATE_TABLE_OPTS=

LIBNAME option value

DBFORCE=

NO

DBGEN_NAME=

DBMS

DBLARGETABLE=

none

DBMAX_TEXT=

1024

DBMAX_TEXT_TYPES=

LONG

DBNULL=

none

DBSASLABEL=

COMPAT

DBSASTYPE=

see Data Types for Hadoop

DBTYPE=

see Data Types for Hadoop

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

READ_METHOD=

none

READBUFF=

LIBNAME option value

SASDATEFMT=

see Data Types for Hadoop

SCHEMA=

LIBNAME option value

SCRATCH_DB=

none

TRANSCODE_FAIL=

ERROR

Last updated: February 3, 2026