|SAS System Options|
|Valid in:||configuration file, SAS invocation, OPTIONS statement, SAS System Options window|
|Category:||Files: SAS Files|
|System administration: SQL|
|System administration: Performance|
|Interaction:||If the SQLREDUCEPUT= system option is set to NONE, conditions for both the SQLREDUCEPUTVALUES= and SQLREDUCEPUTOBS= system options must be met in order for the SQL procedure to consider optimizing the PUT function.|
|PROC OPTIONS GROUP=||SASFILES|
|SQLREDUCEPUTVALUES= n | nK | nM | nG | nT | hexX | MIN | MAX|
specifies the number of SAS format values that can exist in a PUT function expression, where n is an integer that can be allocated in multiples of 1 (bytes); 1,024 (kilobytes); 1,048,576 (megabytes); 1,073,741,824 (gigabytes); or 1,099,511,627,776 (terabytes). For example, a value of 8 specifies eight buffers, and a value of 3k specifies 3,072 buffers.
|Default:||0, which indicates that there is no minimum number of SAS format values that can exist in a PUT function expression.|
|Interaction:||If the number of format values in a PUT function expression is greater than this value, the SQL procedure does not optimize the PUT function.|
specifies the number of SAS format values that can exist in a PUT function expression. You must specify the value beginning with a number (0-9), followed by an X. For example, the value 2dx specifies 45 buffers.
sets the number of SAS format values that can exist in a PUT function expression to 0. A value of 0 indicates that there is no minimum number of SAS format values that are required. This is the default.
sets the maximum number of SAS format values that can exist in a PUT function expression to 5,000.
Some formats, especially user-defined formats, can contain many format values. Depending on the number of matches for a given PUT function expression, the resulting expression can list many format values. If the number of format values becomes too large, the query performance can degrade. When the SQLREDUCEPUT= system option is set to NONE, the SQL procedure considers the value of both the SQLREDUCEPUTVALUES= and SQLREDUCEPUTOBS= system options and determines whether to optimize the PUT function.
"Improving Query Performance" in the SAS SQL Procedure User's Guide