SPDSBNEQ Macro Variable
Specifies the output order of table rows that have
identical values in the BY column.
| Valid in: |
SPD Server |
| Default: |
NO |
| Restriction: |
Assignments for macro variables with character input
(for example, YES | NO | BINARY arguments) must be entered in uppercase
(capitalized).
|
| Interaction: |
Corresponding table option is BYNOEQUALS=. |
Syntax
Required Arguments
YES
generates rows
with identical values in a BY clause in random order.
NO
generates rows with
identical values in a BY clause using the relative table position
of the rows from the input table.
Details
SPDSBNEQ=NO configures
SPD Server to imitate the
Base SAS engine behavior. If strict compatibility is not required, assign SPDSBNEQ=YES. Random
output enables the server to create indexes and append to tables faster.
Example
Configure the server
so that the table rows are generated as quickly as possible when
processing rows that have identical values in the BY column.
%let SPDSBNEQ=YES;
See Also
SPD Server table options:
Copyright © SAS Institute Inc. All Rights Reserved.
Last updated: February 8, 2017