Optional arguments for the SQLGENERATION= system option are ignored when using the MLE engine


When you use the MLE engine, optional arguments that are specified with the SAS® system option SQLGENERATION= are ignored. These optional options include DBMS=, EXCLUDEDB=, and EXCLUDEPROC=.

In order to have SAS procedures that have been enabled for SAS® In-Database processing be passed to the database management system (DBMS) for processing, use SQLGENERATION=DBMS. By default, the option is set to (NONE DBMS='TERADATA DB2 ORACLE NETEZZA ASTER GREENPLUM HADOOP').

There is no workaround for this issue.