SQLREMERGE System Option

Specifies whether PROC SQL can process queries that use remerged data.

Valid in: configuration file, SAS invocation, OPTIONS statement, SAS System Options window
Categories: Files: SAS Files
System administration: SQL
PROC OPTIONS GROUP= SASFILES
SQL
Note: This option can be restricted by a site administrator. For more information, see “Restricted Options” in Chapter 1 of SAS System Options: Reference.
Syntax
Syntax Description
Details
See Also

Syntax

SQLREMERGE | NOSQLREMERGE

Syntax Description

SQLREMERGE

specifies that PROC SQL can process queries that use remerged data.

NOSQLREMERGE

specifies that PROC SQL cannot process queries that use remerged data.

Details

The remerge feature of PROC SQL makes two passes through a table. Data that is created in the first pass is used in the second pass to complete a query. When the NOSQLREMERGE system option is specified, PROC SQL cannot process this remerging of data. If remerging is attempted when the NOSQLREMERGE system option is specified, an error is written to the SAS log.

See Also

Improving Query Performance
Procedure Statement Options:
REMERGE option
summary-function
Copyright © SAS Institute Inc. All rights reserved.