|SAS System Options|
|Valid in:||configuration file, SAS invocation, OPTIONS statement, SAS System Options window|
|Category:||Files: SAS Files|
|System administration: SQL|
|PROC OPTIONS GROUP=||SASFILES|
|SQLREMERGE | NOSQLREMERGE|
specifies that the SQL procedure can process queries that use remerging of data.
specifies that the SQL procedure cannot process queries that use remerging of data.
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.
PROC SQL statement REMERGE option in Base SAS Procedures Guide
"Improving Query Performance" in the SAS SQL Procedure User's Guide