libname user spde 'SAS-library' temp=yes;
data a; x=1;
run;
proc print data=a;
Feature
|
SPD Engine
|
Default Base SAS Engine
|
---|---|---|
Partitioned data sets
|
yes
|
no
|
Parallel WHERE optimization
|
yes
|
no
|
Lowest locking level
|
member
|
record
|
Concurrent access from
multiple SAS sessions on a given data set
|
READ (INPUT Open mode)
|
READ and WRITE (all
Open modes)
|
Remote computing via
SAS/CONNECT
|
no
|
yes
|
Data transfer via SAS/CONNECT
|
no
|
yes
|
RLS (Remote Library
Services) via SAS/CONNECT
|
no
|
yes
|
Available via SAS/CONNECT
|
no
|
yes
|
Support in SAS/SHARE
|
no
|
yes
|
Automatic sort for SAS
BY processing (sort a temporary copy of the data to support BY processing)
|
yes
|
no
|
User-defined formats
and informats
|
yes, except in WHERE1
|
yes
|
Catalogs
|
no
|
yes
|
Views
|
no
|
yes
|
MDDBs
|
no
|
yes
|
Integrity constraints
|
no
|
yes
|
Data set generations
|
no
|
yes
|
CEDA
|
no
|
yes
|
Audit trail
|
no
|
yes
|
NLS transcoding
|
no
|
yes
|
COMPRESS=
|
YES | NO | CHAR | BINARY
(only if the file is not encrypted)
|
YES | NO | CHAR | BINARY
|
DLCREATEDIR
|
no
|
yes
|
ENCRYPT=
|
cannot be used with
COMPRESS=
|
can be used with COMPRESS=
|
encryption
|
yes
|
yes
|
AES encryption
|
data and index files
only
|
yes
|
FIRSTOBS= system option
and data set option
|
no
|
yes
|
OBS= system option and
data set option
|
yes, if used without ENDOBS= or STARTOBS= SPD Engine options
|
yes
|
EXTENDOBSCOUNTER= system
option and data set option
|
no
|
yes
|
Extended attributes
|
no
|
yes
|
Functions and call routines
|
yes, with some exceptions.
|
yes
|
Move table via OS utilities
to a different directory or folder
|
no
|
yes
|
Observations returned
in physical order
|
no, if BY or WHERE is
present
|
yes
|
DLDMGACTION= system
option and data set option
|
yes, with ABORT | FAIL
| PROMPT | REPAIR, but not with NOINDEX
|
yes
|
1In WHERE processing, functions and call routines are passed to the supervisor for handling. Therefore, they are not processed in parallel. |