Data Set Options for Aster

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

SAS/ACCESS Data Set Options for Aster

Option

Default Value

BL_DATAFILE=

none

BL_DATAFILE_PATH=

none

BL_DBNAME=

none

BL_DELETE_DATAFILE=

YES

BL_DELIMITER=

\t (the tab symbol)

BL_ESCAPE=

\

BL_HOST=

none

BL_OPTIONS=

none

BL_PATH=

none

BL_QUOTE=

"

BULKLOAD=

NO

BULKUNLOAD=

LIBNAME option value

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

DBPROMPT=

LIBNAME option value

DBSASTYPE=

see Data Types for Aster

DBTYPE=

see Data Types for Aster

DIMENSION=

NO

ERRLIMIT=

1

IGNORE_READ_ONLY_COLUMNS=

NO

INSERTBUFF=

LIBNAME option value

NULLCHAR=

SAS

NULLCHARVAL=

A blank character

PARTITION_KEY=

none

PRESERVE_COL_NAMES=

LIBNAME option value

QUERY_TIMEOUT=

LIBNAME option value

READBUFF=

LIBNAME option value

SASDATEFMT=

none

SCHEMA=

LIBNAME option value

Last updated: February 3, 2026