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
|
SQLREMERGE | NOSQLREMERGE
|
- 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.
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.
Copyright © 2011 by SAS Institute Inc., Cary, NC, USA. All rights reserved.