Specifies whether and when SAS procedures generate SQL for in-database processing of source data.
| Valid in: | SAS/ACCESS LIBNAME statement |
|---|---|
| Category: | Data Set Control |
| Default: | none |
| Restrictions: | A value of NONE or DBMS modifies only the primary state that is specified on the system option. |
| If you are using the Metadata LIBNAME Engine, the only valid SQLGENERATION= modifiers are NONE and DBMS. The engine ignores the DBMS=, EXCLUDEDB=, and EXCLUDEPROC= modifiers. | |
| Data source: | Amazon Redshift, Aster, DB2 under UNIX and PC Hosts, DB2 under z/OS, Google BigQuery, Greenplum, Hadoop, HAWQ, Impala, JDBC, Microsoft SQL Server, Netezza, Oracle, PostgreSQL, SAP HANA, Snowflake, Spark, Teradata, Vertica, Yellowbrick |
| Note: | Support for Google BigQuery, Spark, and Yellowbrick was added in SAS 9.4M7. |
| See: | SQLGENERATION= system option, Precedence of Values for SQLGENERATION= LIBNAME and System Options, SAS In-Database Products: Administrator’s Guide |
Table of Contents