Variable for Compatibility with the Base SAS Engine

Use the SPDSBNEQ= setting to specify the output order of table rows that have identical values in the BY column.

Syntax

SPDSBNEQ=YES|NO

Default: NO

Corresponding Table Option: BYNOEQUALS=

Arguments

YES

outputs rows with identical values in a BY clause in random order.

NO

outputs rows with identical values in a BY clause using the relative table position of the rows from the input table.

Description

SPDSBNEQ=NO configures the SPD Server to imitate the Base SAS engine behavior. If strict compatibility is not required, assign SPDSBNEQ=YES. Random output allows the SPD Server to create indexes and append to tables faster.

Example

Configure the SPD Server so that it output table rows as quickly as possible when processing rows that have identical values in the BY column.

%let SPDSBNEQ=YES;