SQLMAPPUTTO= System Option
Specifies whether the PUT function is mapped to
the SAS_PUT( ) function for a database. This is also possible
where the SAS_PUT( ) function is mapped.
| Valid in: | configuration file, SAS invocation, OPTIONS statement |
| Default: | SAS_PUT |
| Data source: | Aster nCluster, DB2 under UNIX, Greenplum, Netezza, Teradata |
Table of ContentsSyntax
SQLMAPPUTTO= NONE | SAS_PUT | (database.SAS_PUT)
Syntax Description
- NONE
-
specifies to PROC SQL that no PUT mapping is to occur.
- SAS_PUT
-
specifies that the PUT function be mapped to the SAS_PUT( ) function.
- database.SAS_PUT
-
specifies the database name.
Requirements If you specify a database name, you must enclose the entire argument in parentheses. If you specify SQLMAPPUTTO=database.SAS_PUT, database must be the same as the database where the SAS_PUT function is mapped. Tips It is not necessary that the format definitions and the SAS_PUT( ) function reside in the same database as the one that contains the data that you want to format. You can use the database.SAS_PUT argument to specify the database where the format definitions and the SAS_PUT( ) function have been published. The database name can be a multilevel name and it can include blanks.
Details
The format publishing
macros deploy, or 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 most formats that SAS supplies. The SAS_PUT( )
function supports the use of SAS formats. You can use the function
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.