ERRLIMIT=

ERRLIMIT=

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

Default value: 1

See Also: DBCOMMIT=

Syntax
Details

Syntax

ERRLIMIT=integer

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

Details

SAS calls the DBMS to issue a rollback after the 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. SAS displays the total number of rows processed and the number of failed rows, if applicable, in the log.

If you use the DBCOMMIT= option, DBCOMMIT= overrides the ERRLIMIT= option.

Note: If you specify a value for DBCOMMIT= other than zero, rollbacks affected by the ERRLIMIT= option might not include records that are processed unsuccessfully because they were already committed by DBCOMMIT=. [cautionend]

In the following example, SAS stops processing and issues a rollback to the DBMS at the occurrence of the tenth error.

data mydata;
   set mydb.dept(errlimit=10);
   where salary > 40000;
run;

Chapter Contents
Previous
Next
Top of Page