SAS ® 9.4 Scalable Performance Data Engine: Reference
This document is the official reference for the SAS 9.4 Scalable Performance Data Engine (SPD Engine), a high-performance data engine designed for rapid access to large SAS datasets. It supports parallel processing, automatic sorting, and optimized I/O on SMP and MPP computers. The manual covers SPD Engine compatibility, data set options, LIBNAME statement options, system options, and performance tuning strategies including WHERE expression evaluation strategies.
The SPD Engine is optimized for datasets exceeding operating system limits and supports cross-environment data access (CEDA) in SAS 9.4M5 and later. It includes new features such as AES encryption, block size control, and compression options. The document also details interoperability with default Base SAS Engine data sets and provides guidance on organizing data, backing up files, and using HDFS storage.
| System Options | SPDEWHEVAL=COST | EVAL1 | EVAL3EVAL4 |
|---|---|
| Supported Platforms | UNIX, Windows, z/OS (ZFS file system only) |
The SPD Engine is designed for high-performance data delivery, enabling rapid access to SAS data for processing by organizing data into a streamlined file format that takes advantage of multiple CPUs to perform parallel input functions.
The default evaluation strategy is COST, which analyzes the WHERE expression and available indexes to determine the optimal strategy, minimizing thread overhead.