For the SQL procedure, specifies the engine type to use to optimize a PUT function in a query. The PUT function is replaced 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 “Restricted Options” in Chapter 1 of SAS System Options: Reference. |
specifies to consider the optimization of all PUT functions, regardless of the engine that is used by the query to access the data.
specifies to not optimize any PUT function.
specifies to consider the optimization of all PUT functions in a query performed by a SAS/ACCESS engine. This is the default.
| Requirement | The first argument to the PUT function must be a variable that is obtained by a table. The table must be accessed using a SAS/ACCESS engine. |
specifies to consider the optimization of all PUT functions in a query 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.));Here, the SELECT clause is optimized.
select x from &lib..c where (x = '17MAR2011'D);