Contents
About
What's New in the SAS 9.2 Scalable Performance Data Engine
Usage
Overview: The SPD Engine
Introduction to the SPD Engine
SPD Engine Compatibility
Using the SMP Computer
Organizing SAS Data Using the SPD Engine
Comparing the Default Base SAS Engine and the SPD Engine
Interoperability of the Default Base SAS Engine and the SPD Engine Data Sets
Sharing the SPD Engine Files
Features That Enhance I/O Performance
Features That Boost Processing Performance
The SPD Engine Options
Creating and Loading SPD Engine Files
Introduction for Creating and Loading SPD Engine Files
Allocating the Library Space
Efficiency Using Disk Striping and Large Disk Arrays
Converting Default Base SAS Engine Data Sets to SPD Engine Data Sets
Creating and Loading New SPD Engine Data Sets
Compressing SPD Engine Data Sets
SPD Engine Component File Naming Conventions
Efficient Indexing in the SPD Engine
Reference
SPD Engine LIBNAME Statement Options
Introduction to the SPD Engine LIBNAME Statement
Syntax
ACCESS= LIBNAME Statement Option
BYSORT= LIBNAME Statement Option
DATAPATH= LIBNAME Statement Option
ENDOBS= LIBNAME Statement Option
IDXBY= LIBNAME Statement Option
INDEXPATH= LIBNAME Statement Option
METAPATH= LIBNAME Statement Option
PARTSIZE= LIBNAME Statement Option
STARTOBS= LIBNAME Statement Option
TEMP= LIBNAME Statement Option
SPD Engine LIBNAME Statement Options List
SPD Engine Data Set Options
Introduction to SPD Engine Data Set Options
Syntax
ASYNCINDEX= Data Set Option
BYNOEQUALS= Data Set Option
BYSORT= Data Set Option
COMPRESS= Data Set Option
ENCRYPT= Data Set Option
ENDOBS= Data Set Option
IDXBY= Data Set Option
IDXWHERE= Data Set Option
IOBLOCKSIZE= Data Set Option
LISTFILES= Data Set Option
PADCOMPRESS= Data Set Option
PARTSIZE= Data Set Option
STARTOBS= Data Set Option
SYNCADD= Data Set Option
THREADNUM= Data Set Option
UNIQUESAVE= Data Set Option
WHERENOINDEX= Data Set Option
SPD Engine Data Set Options List
SAS Data Set Options That Behave Differently with the SPD Engine Than with the Default Base SAS Engine
SAS Data Set Options Not Supported by the SPD Engine
SPD Engine System Options
Introduction to SPD Engine System Options
Syntax
COMPRESS= System Option
MAXSEGRATIO= System Option
MINPARTSIZE= System Option
SPDEINDEXSORTSIZE= System Option
SPDEMAXTHREADS= System Option
SPDESORTSIZE= System Option
SPDEUTILLOC= System Option
SPDEWHEVAL= System Option
SPD Engine System Options List
SAS System Options That Behave Differently with SPD Engine
Appendix
Recommended Reading
Glossary
Product
Release
Base SAS
9.2
Type
Usage and Reference
Copyright Date
February 2009
Last Updated
30Jan2009