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 |
SQL | |
PERFORMANCE |
Syntax | |
Syntax Description | |
Details | |
See Also |
Syntax |
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. |
Range: | 0-5,000 |
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.
Details |
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.
See Also |
System options: | |||||
"Improving Query Performance" in the SAS SQL Procedure User's Guide |
Copyright © 2011 by SAS Institute Inc., Cary, NC, USA. All rights reserved.