SAS System Options That Behave Differently with the SPD Engine Than with the Default Base SAS Engine

MSGLEVEL=I
produces WHERE optimization information in the SAS log.
COMPRESS=
cannot perform user-defined compression.
DLDMGACTION=
does not support DLDMGACTION=NOINDEX, but does support ABORT, FAIL, PROMPT, and REPAIR.
DLCREATEDIR
does not work with the SPD Engine.
ERRORS=MAX
sets the maximum number of observations to 2147483647 for which SAS can issue error messages.
FIRSTOBS=
cannot be used in the SPD Engine.
SORTPGM=
using the BEST option can cause performance issues.
VALIDMEMNAME=
has the following restrictions on member name when you use VALIDMEMNAME=EXTEND:
  • a member name cannot have a period, such as class.group.
  • a member name cannot start with $, such as$class.
VALIDVARNAME=
cannot create an index or composite index on a variable if the variable name contains any of the following special characters:
"  *  |  \  :  /  <  >  ?  -