Specifies whether the SQL procedure replaces references to the DATE, TIME, DATETIME, and TODAY functions in a query with their equivalent constant values before the query executes.
| Valid in: | configuration file, SAS invocation, OPTIONS statement, SAS System Options window |
| Categories: | Files: SAS Files |
| System administration: SQL | |
| PROC OPTIONS GROUP= | SASFILES |
| SQL | |
| 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 that the SQL procedure is to replace references to the DATE, TIME, DATETIME, and TODAY functions with their equivalent numeric constant values.
specifies that the SQL procedure is not to replace references to the DATE, TIME, DATETIME, and TODAY functions with their equivalent numeric constant values.
select x from &lib..c where (put(bday, date9.) = put(today(), date9.));