Compresses SPD Server tables on disk.
| Valid in: | SPD Server |
| Default: | No |
| Restriction: | A server table cannot be encrypted if it is compressed. |
| Interactions: | Corresponding macro variable is SPDSDCMP. If you specify values for both the COMPRESS= table option and the SPDSDCMP macro variable, the SPDSDCMP setting overrides the COMPRESS= setting. |
| Use COMPRESS= in conjunction with the IOBLOCKSIZE= table option. |
specifies that data in a newly created table be compressed by SAS using run-length encoding (RLE). RLE compresses data 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 two arguments are functionally identical and interchangeable.
specifies that the data in a newly created table be 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.
specifies that the data in the table is not to be compressed.
data mylib.CharRepeats(COMPRESS=YES);
length ca $ 200;
do i=1 to 100000;
ca='aaaaaaaaaaaaaaaaaaaaaa';
cb='bbbbbbbbbbbbbbbbbbbbbb';
cc='cccccccccccccccccccccc';
output;
end;
run;
NOTE: Compressing table MYLIB.CHARREPEATS decreased size by 93.34 percent.
data mylib.StringRepeats(COMPRESS=BINARY);
length cabcd $ 200;
do i=1 to 1000000;
cabcd='abcdabcdabcdabcdabcdabcdabcdabcd';
cefgh='efghefghefghefghefghefghefghefgh';
cijkl='ijklijklijklijklijklijklijklijkl';
output;
end;
run;
NOTE: Compressing table MYLIB.STRINGREPEATS decreased size by 97.85 percent.