The DBLOAD Procedure

LIMIT Statement

Limits the number of observations that can be loaded into the new file.
Default: 5000
Restrictions: The load-limit must be a nonnegative integer.

If you omit the LIMIT statement, a maximum of 5,000 observations are inserted.

Note: To load all observations from your input data set, specify LIMIT=0.
Syntax
Details

Syntax

LIMIT=load-limit;

Details

The LIMIT= statement places a limit on the number of observations that can be loaded into the new DBMS table. The load-limit argument must be a nonnegative integer. To load all observations from your input data set, specify LIMIT=0.
The maximum number for the limit statement varies with each PC file.
Copyright © SAS Institute Inc. All rights reserved.