Specifies whether and when SAS procedures generate SQL for in-database processing of source data.
Valid in: | configuration file, SAS invocation, OPTIONS statement, SAS System Options window |
Category: | System administration: Performance |
Default: | (NONE DBMS='ASTER DB2 GREENPLM NETEZZA ORACLE TERADATA') |
Restriction: | For DBMS= and EXCLUDEDB= values, the maximum length of an engine name is eight characters. For the EXCLUDEPROC= value, the maximum length of a procedure name is 16 characters. An engine can appear only once, and a procedure can appear only once for a given engine. |
Data source: | Aster nCluster, DB2 under UNIX and PC Hosts, Greenplum, Netezza, Oracle, Teradata |
See: | SQLGENERATION= LIBNAME option (includes examples), and also “Running In-Database Procedures” in SAS In-Database Products: User’s Guide |
prevents those SAS procedures that are enabled for in-database processing from generating SQL for in-database processing. This is a primary state.
allows SAS procedures that are enabled for in-database processing to generate SQL for in-database processing of DBMS tables through supported SAS/ACCESS engines. This is a primary state.
specifies one or more SAS/ACCESS engines. It modifies the primary state.
prevents SAS procedures from generating SQL for in-database processing for one or more specified SAS/ACCESS engines.
identifies engine-specific SAS procedures that you do not want to run inside the database.
resets the value to the default that was shipped.
options sqlgeneration=''; options sqlgeneration=(DBMS EXCLUDEDB='DB2'); proc options option=sqlgeneration; run;
options sqlgeneration=''; options SQLGENERATION=(NONE DBMS='Teradata'); proc options option=sqlgeneration; run;