SAS 9.4 Scalable Performance Data Engine Reference

SAS ® 9.4 Scalable Performance Data Engine: Reference


SAS 9.4 Scalable Performance Data Engine Reference - cover page
Brand
SAS
Document type
User Manual
Language
English
Pages
128
File format
PDF
File size
964 KB
Published
26 October, 2023
Updated
26 October, 2023
MD5 checksum
DE55608F134EDD6BD18B7816AD38A967

About this manual

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.

What's inside

  • Overview: The SPD Engine
  • Creating and Loading SPD Engine Files
  • SPD Engine LIBNAME Statement
  • SPD Engine Data Set Options
  • SPD Engine System Options
  • What's New in SAS 9.4 Scalable Performance Data Engine

Specifications

System OptionsSPDEWHEVAL=COST | EVAL1 | EVAL3EVAL4
Supported PlatformsUNIX, Windows, z/OS (ZFS file system only)

Frequently asked questions

What is the SPD Engine used for?

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.

What is the default evaluation strategy for WHERE expressions?

The default evaluation strategy is COST, which analyzes the WHERE expression and available indexes to determine the optimal strategy, minimizing thread overhead.

Download PDF (964 KB)

More SAS Manuals


View all SAS manuals →