BL_DATAFILE_EXISTS= Data Set Option

Lets you load a table from an existing data set.

Valid in: DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
Categories: Bulk Loading
Data Set Control
Default: NO
Restriction: You cannot use this option if you have specified the BL_USE_PIPE= data set option.
Requirement: To specify this option, you must first specify BULKLOAD=YES.
Data source: Greenplum, HAWQ
See: BL_USE_PIPE= data set option, BULKLOAD= LIBNAME option, BULKLOAD= data set option

Table of Contents

Syntax

BL_DATAFILE_EXISTS=YES | NO

Optional Arguments

YES

indicates that the engine opens the specified file in Read mode if the data set already exists.

NO

indicates that the engine creates the specified file and opens it in Load mode if the data set does not already exist.

Last updated: February 3, 2026