For the SQL procedure, when the SQLREDUCEPUT= system option is set to DBMS, BASE, or ALL, specifies the maximum number of SAS format values that can exist in a PUT function expression for PROC SQL to optimize the PUT function in a query.
| Valid in: | configuration file, SAS invocation, OPTIONS statement, SAS System Options window |
| Categories: | Files: SAS Files |
| System administration: SQL | |
| System administration: Performance | |
| PROC OPTIONS GROUP= | SASFILES |
| SQL | |
| PERFORMANCE | |
| Interaction: | If the SQLREDUCEPUT= system option is set to DBMS, BASE, or ALL, conditions for both the SQLREDUCEPUTVALUES= and SQLREDUCEPUTOBS= system options must be met for PROC SQL to optimize the PUT function. |
| Note: | This option can be restricted by a site administrator. For more information, see “Restricted Options” in Chapter 1 of SAS System Options: Reference. |
specifies the maximum number of SAS format values that can exist in a PUT function expression for PROC SQL to optimize the PUT function in a query.
| Default | 100 |
| Range | 100 – 3,000 |
| Requirement | n must be an integer |
| Interaction | If the number of SAS format values in a PUT function expression is greater than this value, PROC SQL does not optimize the PUT function. |