SAS System Options

SQLREMERGE System Option

Specifies whether the SQL procedure can process queries that use remerging of data.

Valid in:	configuration file, SAS invocation, OPTIONS statement, SAS System Options window
Category:	Files: SAS Files
	System administration: SQL
PROC OPTIONS GROUP=	SASFILES
	SQL

Syntax
Syntax Description
Details
See Also

Syntax

SQLREMERGE | NOSQLREMERGE

Syntax Description

SQLREMERGE: specifies that the SQL procedure can process queries that use remerging of data.
NOSQLREMERGE: specifies that the SQL procedure cannot process queries that use remerging of data.

Details

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

See Also

	PROC SQL statement REMERGE option in Base SAS Procedures Guide
	Remerging Data in the summary-function component of the SQL procedure in Base SAS Procedures Guide
	"Improving Query Performance" in the SAS SQL Procedure User's Guide

Top of Page