BULK_BUFFER= Data Set Option

Specifies the number of bulk rows that the SAS/ACCESS engine can buffer for output.
Valid in: DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
Default: 100
Data source: Sybase
See: BULKLOAD= data set option, ENABLE_BULK= LIBNAME option

Syntax

BULK_BUFFER=numeric-value

Syntax Description

numeric-value
specifies the maximum number of rows that are allowed. This value depends on the amount of memory that is available to your system.

Details

This option improves performance by specifying the number of rows that can be held in memory for efficient retrieval from the DBMS. A higher number signifies that more rows can be held in memory and accessed quickly during output operations.