O'Reilly logo

SAS 9.4 SQL Procedure User's Guide, Fourth Edition, 4th Edition by SAS Institute

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required