Specifies whether the PUT function is mapped to the SAS_PUT function for a database. Use this system option to specify an alternative database in which the SAS_PUT function is published.
| Valid in: | configuration file, SAS invocation, OPTIONS statement |
|---|---|
| Category: | Files: SAS Files |
| Default: | SAS_PUT |
| Data source: | Aster, DB2 under UNIX and PC Hosts, Greenplum, Netezza, Teradata |
| See: | SQL_FUNCTIONS= LIBNAME option, SAS In-Database Products: User’s Guide |
Table of Contents
specifies to PROC SQL that no PUT function mapping is to occur.
specifies that the PUT function be mapped to the SAS_PUT function in the database.
specifies the database name where the SAS_PUT function and format definitions reside.
| Requirement | If you specify a database name, you must enclose the entire argument in parentheses. |
|---|
SAS format publishing macros publish the PUT function implementation to the database as a new function named SAS_PUT. The format publishing macros also publish both user-defined formats that you create using PROC FORMAT and formats that SAS supplies. The SAS_PUT function supports the use of SAS formats. You can use it in SQL queries that SAS submits to the database so that the entire SQL query can be processed inside the database. You can also use it in conjunction with in-database procedures.
You can use this option with the SQLREDUCEPUT=, SQLREDUCEPUTOBS, and SQLREDUCEPUTVALUES= system options. For more information about these options, see SAS SQL Procedure User’s Guide.