| What's New |
| Overview |
The SAS 9.2 Scalable Performance Data (SPD) Engine has the following enhancements:
new and enhanced data set options
new and enhanced LIBNAME statement options
new and enhanced system options
These enhancements enable the SPD Engine to perform rapid processing of very large data sets that are stored in partitions across multiple disk volumes.
| SPD Engine Data Set Options |
The COMPRESS= data set option now supports binary compression with the CHAR and BINARY options.
The new ENCRYPT= data set option specifies whether to encrypt an output SPD Engine data set.
The new IDXBY= data set option specifies whether to use indexes when processing BY statements in the SPD Engine. In some cases, this option can enhance performance.
The new LISTFILES= data set option is used only with the CONTENTS procedure. It lists the complete pathnames of all of the component files of an SPD Engine data set.
The PARTSIZE= data set option now expresses the partition size value in gigabytes, terabytes, or the default megabytes. The maximum number of megabytes has increased to 8,796,093,022,207.
| SPD Engine LIBNAME Statement Options |
The ACCESS=READONLY LIBNAME statement option determines the access level of the data source. Using this option prevents writing to the data source.
The new IDXBY= LIBNAME statement option specifies whether to use indexes when processing BY statements in the SPD Engine. In some cases, this option can enhance performance.
The PARTSIZE= LIBNAME statement option now expresses the partition size value in gigabytes, terabytes, or the default megabytes. The maximum number of megabytes has increased to 8,796,093,022,207.
| SPD Engine System Options |
The COMPRESS= system option now supports binary compression with the CHAR and BINARY options.
The MINPARTSIZE= system option now has a default of 16 megabytes, instead of 0 megabytes.
| SPD Engine Compatability |
A new section has been added with information for upgrading from SAS 9.1.3 to SAS 9.2.
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.