For the SQL procedure, specifies the engine type that a query uses for which optimization is performed by replacing a PUT function in a query with a logically equivalent expression.
| Valid in: | configuration file, SAS invocation, OPTIONS statement, SAS System Options window |
| Categories: | Files: SAS Files |
| System administration: SQL | |
| System administration: Performance | |
| PROC OPTIONS GROUP= | SASFILES |
| SQL | |
| PERFORMANCE | |
| Note: | This option can be restricted by a site administrator. For more information, see the section on restricted options in the SAS System Options: Reference. |
specifies that optimization is performed on all PUT functions regardless of any engine that is used by the query to access the data.
specifies that no optimization is to be performed.
specifies that optimization is performed on all PUT functions whose query is performed by a SAS/ACCESS engine. This is the default.
| Requirement | The first argument to the PUT function must be a variable obtained by a table that is accessed using a SAS/ACCESS engine. |
specifies that optimization is performed on all PUT functions whose query is performed by a SAS/ACCESS engine or a Base SAS engine.
none:select x, y from &lib..b where (PUT(x, abc.) in ('yes', 'no'));
select x from &lib..a where (PUT(x, udfmt.) = trim(left('small')));select x from &lib..c where (put(bday, date9.) = put(today(), date9.));