LIBNAME Statement: PC Files on Linux, UNIX, and 64-Bit Microsoft Windows

ERRLIMIT

Specifies the number of errors that are allowed before SAS stops processing and issues a rollback.

Valid in:	DATA and PROC steps
Default value:	1

Syntax
Syntax Description
Details
See Also
Example

Syntax

ERRLIMIT=integer

Syntax Description

INTEGER: is a positive integer that represents the number of errors after which SAS stops processing and issues a rollback.

Details

SAS calls the data source to issue a rollback after a specified number of errors occurs during the processing of inserts, deletes, updates, and appends. If ERRLIMIT= is set to 0, SAS processes all rows, regardless of the number of errors that occur. The SAS log displays the total number of rows processed and the number of failed rows, if applicable.

The DBCOMMIT= option overrides the ERRLIMIT= option. If you specify a nonzero value for the DBCOMMIT= option, rollbacks affected by the ERRLIMIT= option might not be complete. Records already committed by DBCOMMIT= option are not processed again.

Note: This option cannot be used from a SAS client session in a SAS/SHARE environment. [cautionend]

See Also

DBCOMMIT

Example

SAS stops processing and issues a rollback to the data source at the occurrence of the tenth error. The MyDBLib libref was assigned in a prior LIBNAME statement.

DATA mydblib.employee3 (ERRLIMIT=10);
   SET mydblib.employees;
   WHERE salary>40000;
RUN;

Top of Page