SPD Engine Data Set Options |
Valid in: | DATA step and PROC step |
Restriction: | Cannot be used with ENCRYPT=YES or ENCRYPT=RC4 |
Related data set options: | IOBLOCKSIZE= Data Set Option and PADCOMPRESS= Data Set Option |
Default: | NO |
Syntax | |
Details | |
Examples | |
Example 1: COMPRESS=BINARY | |
Example 2: COMPRESS=CHAR |
Syntax |
COMPRESS= NO | YES | CHAR | BINARY |
performs no data set compression.
performs the Run Length Compression (SPDSRLC2) on the data set.
performs the Ross Data Compression (SPDSRDC) on the data set.
Details |
When you specify COMPRESS=YES|BINARY|CHAR, the SPD Engine compresses, by blocks, the data component file as it is created. To specify the size of the compressed blocks, use the IOBLOCKSIZE= Data Set Option when you create the data set. To add padding to the newly compressed blocks, specify PADCOMPRESS= Data Set Option when creating or updating the data set. For more information, see Compressing SPD Engine Data Sets.
Examples |
Here is PROC CONTENTS output from the SPD Engine with COMPRESS=BINARY.
The SAS System 1 The CONTENTS Procedure Data Set Name URBANLIB.HOUSING Observations 96754 Member Type DATA Variables 56 Engine SPDE Indexes 0 Created Tuesday, October 02, Observation Length 448 2007 01:16:21 PM Last Modified Tuesday, October 02, Deleted Observations 0 2007 01:16:21 PM Protection Compressed BINARY Data Set Type Point to Observations YES Label Sorted NO Data Representation WINDOWS_32 Encoding wlatin1 Western (Windows) Engine/Host Dependent Information Blocking Factor (obs/block) 146 Disk Compression Name SPDSRDC Data Partsize 134249920 - Compressed Info - Number of compressed blocks 1326 Raw data blocksize 32704 Number of blocks with overflow 0 Max overflow chain length 0 Block number for max chain 0 Min overflow area 0 Max overflow area 0
Here is PROC CONTENTS output from the SPD Engine with COMPRESS=CHAR.
The SAS System 1 The CONTENTS Procedure Data Set Name SALESLIB.COSTS Observations 459568 Member Type DATA Variables 21 Engine SPDE Indexes 0 Created Tuesday, October 02, Observation Length 112 2007 01:26:30 PM Last Modified Tuesday, October 02, Deleted Observations 0 2007 01:26:30 PM Protection Compressed CHAR Data Set Type Point to Observations YES Label Sorted NO Data Representation WINDOWS_32 Encoding wlatin1 Western (Windows) Engine/Host Dependent Information Blocking Factor (obs/block) 585 Disk Compression Name SPDSRLC2 Data Partsize 134249920 - Compressed Info - Number of compressed blocks 1574 Raw data blocksize 32704 Number of blocks with overflow 0 Max overflow chain length 0 Block number for max chain 0 Min overflow area 0 Max overflow area 0
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.