Specifies to compress SPD Server tables that are stored on disk.
| Valid in: | SPD Server |
| Default: | NO |
| Restrictions: | A server table cannot be encrypted if it is compressed. |
| Assignments for macro variables with character input (for example, YES | NO | BINARY arguments) must be entered in uppercase (capitalized). | |
| Interactions: | The corresponding table option is COMPRESS=. If you specify values for both the COMPRESS= table option and the SPDSDCMP macro variable, the SPDSDCMP setting overrides the COMPRESS=setting. |
| Used in conjunction with the IOBLOCKSIZE= table option. |
specifies that the rows in a newly created table are compressed by SAS using run-length encoding (RLE). RLE compresses rows by reducing repeated consecutive characters (including blanks) to 2-byte or 3-byte representations. Use the YES or CHAR argument to enable RLE compression for character data. The YES and CHAR arguments are functionally identical and interchangeable.
specifies that the rows in a newly created table are compressed by SAS using Ross Data Compression (RDC). RDC combines run-length encoding and sliding-window compression to compress the file. Use the BINARY argument to compress binary and numeric data. This method is highly effective for compressing medium to large (several hundred bytes or larger) blocks of binary data (numeric variables).
YES, the server compresses newly created tables by blocks, according to the algorithm
specified. To control the amount of compression, use the table option IOBLOCKSIZE=
to specify the number of rows that you want to store in the block. For more information, see IOBLOCKSIZE= Table Option.%let SPDSDCMP=BINARY;