INSERTBUFF

Specifies the number of rows in a single insert.
Valid in: DATA and PROC steps
Default: LIBNAME option setting

Syntax

INSERTBUFF=number-of-rows

Syntax Description

number-of-rows
specifies the number of rows to insert. The value must be a positive integer.

Details

SAS allows the maximum number of rows that is allowed by the data source. The optimal value for this option varies with factors such as network type and available memory. You might need to experiment with different values to determine the best value for your site.
When you assign a value greater than INSERTBUFF=1, the SAS notes indicating success or failure of the insert operation might be incorrect. These notes are generated for a single insert. This is also true, when multiple inserts are performed.
Note: PC Files Server does not support INSERTBUFF= option with a value higher than 1 for writing data to Excel. It ignores this option when writing data to Excel.
If the DBCOMMIT= option is specified with a value that is less than the value of INSERTBUFF=, then DBCOMMIT= overrides INSERTBUFF= option.
Note: When you are inserting with the VIEWTABLE window or the FSEDIT or FSVIEW procedure, use INSERTBUFF=1 to prevent the data source interface from trying to insert multiple rows. These features do not support inserting more than one row at a time.