Appendix 1
SQL Macro Variables and System
Options
Dictionary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 373
SQLCONSTDATETIME System Option . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 373
SQLGENERATION= System Option . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 374
SQLIPONEATTEMPT System Option . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 377
SQLMAPPUTTO= System Option . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 378
SQLREDUCEPUT= System Option . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 379
SQLREDUCEPUTOBS= System Option . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 380
SQLREDUCEPUTVALUES= System Option . . . . . . . . . . . . . . . . . . . . . . . . . . . . 381
SQLREMERGE System Option . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 383
SQLUNDOPOLICY= System Option . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 383
SYS_SQLSETLIMIT Macro Variable . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 385
Dictionary
SQLCONSTDATETIME System Option
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 SAS System Options: Reference.
Syntax
SQLCONSTDATETIME | NOSQLCONSTDATETIME
373
Get SAS 9.4 SQL Procedure User's Guide, Fourth Edition, 4th Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
