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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.