Previous Page | Next Page

SAS System Options

SQLREDUCEPUTVALUES= System Option



For the SQL procedure when the SQLREDUCEPUT= system option is set to NONE, specifies the maximum number of SAS format values that can exist in a PUT function expression in order for PROC SQL to consider optimizing the PUT function in a query.
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


Syntax Description

n | nK | nM | nG | nT

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.
hexX

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.

MIN

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.

MAX

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:

SQLREDUCEPUT= System Option

SQLREDUCEPUTOBS= System Option

"Improving Query Performance" in the SAS SQL Procedure User's Guide

Previous Page | Next Page | Top of Page