Data Set Options for Relational Databases

BL_HEADER= Data Set Option

Indicates whether to skip or load the first record in the input data file.

Default value:	NO
Valid in:	DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
DBMS support:	Greenplum

Syntax
Syntax Description
Details
See Also

Syntax

BL_HEADER=YES | NO

Syntax Description

YES: indicates that the first record is skipped (not loaded).
NO: indicates that the first record is loaded.

Details

To specify this option, you must first set BULKLOAD=YES.

You can use this option only when loading a table using an external Web source. When the first record of the input data file contains the name of the columns to load, you can indicate that it should be skipped during the load process.