AUTOCOMMIT= Data Set Option

Specifies whether to enable the DBMS autocommit capability.
Valid in: DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
Default: LIBNAME setting
Data source: MySQL, Sybase
See: AUTOCOMMIT= LIBNAME option, DBCOMMIT= data set option

Syntax

AUTOCOMMIT=YES | NO

Syntax Description

YES
specifies that SAS commits all updates, inserts, and deletes immediately after they are executed and that no rollback is possible.
NO
specifies that SAS commits after processing the number of rows that DBCOMMIT= specifies or the default number of rows if you do not specify DBCOMMIT=.