Referencing a database table in a DATA step or in a PROC SQL or PROC FEDSQL CREATE TABLE statement might result in this error:

ERROR: The XXXXXX table YYYYY has been opened for OUTPUT. This table already exists,
or there is a name conflict with an existing object. This table will not be replaced.  
This engine does not support the REPLACE option.

In this message, XXXXXX represents the database engine name and YYYYY represents the table name.

The error occurs if the database table that you reference already exists.

If you attempt to append rows to the database table that is referenced in the error, use the APPEND procedure or the PROC SQL INSERT statement. Both PROC APPEND and PROC SQL support the BULKLOAD= option, provided that the SAS/ACCESS^® engine for the particular database supports bulk loading.

To prevent the error altogether, drop the database table before you attempt to re-create the table.

Operating System and Release Information