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

AUTOCOMMIT=YES | NO

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=.