For the SQL procedure, when the SQLREDUCEPUT= system option is set to DBMS, BASE, or ALL, specifies the minimum number of observations that must be in a table 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 | |
Interactions: | If the SQLREDUCEPUT= system option is set to DBMS, BASE, or ALL, conditions for both the SQLREDUCEPUTOBS= and SQLREDUCEPUTVALUES= system options must be met for PROC SQL to optimize the PUT function. |
The SQLREDUCEPUTOBS= system option works only for DBMSs that record the number of observations in a table. If your DBMS does not record the number of observations, but you create row counts on your table, the SQLREDUCEPUTOBS= option will work. | |
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 minimum number of observations that must be in a table for PROC SQL to optimize the PUT function in a query.
Default | 0, which indicates that there is no minimum number of observations in a table for PROC SQL to optimize the PUT function. |
Range | 0–263–1, or approximately 9.2 quintillion |
Requirement | n must be an integer |