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, DB2 under UNIX, Greenplum, Netezza, Teradata
Syntax
Syntax Description
Details
See Also

Syntax

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.
You can use this option with the SQLREDUCEPUT=, SQLREDUCEPUTOBS, and SQLREDUCEPUTVALUES= system options. For more information about these options, see the Base SAS Procedures Guide.

See Also

Deploying and Using SAS Formats in Aster nCluster
Deploying and Using SAS Formats in DB2 under UNIX
Deploying and Using SAS Formats in Greenplum
Deploying and Using SAS Formats in Netezza
Deploying and Using SAS Formats in Teradata
BY-Groups
LIBNAME Options:
SQLMAPPUTTO= LIBNAME option in SAS/ACCESS for Relational Databases: Reference
Copyright © SAS Institute Inc. All rights reserved.