Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 437
  • Last Modified:

compress for large tables

Hi,
We want to compress huge tables to save space how can we do that and how can we determine if compress worked.

Thanks,
0
sam2929
Asked:
sam2929
1 Solution
 
theartfuldazzlerCommented:
Hi

For large tables, where there is a lot of character variables,

use:

OPTIONS COMPRESS=CHAR;

For large tables, that mostly consist of numeric data, use:

OPTIONS COMPRESS=BINARY;


Note - you can also specifify this as a DATA step option:

DATA test(COMPRESS=CHAR);

The compression will be noted in the LOG after the DATA STEP has run.
0
 
sam2929Author Commented:
ok  any idea where to do compress in di studio on tables
0
 
d507201Database Marketing ConsultantCommented:
The Options Tab in a Loader Properties Dialog Box in SAS Data Integration Studio is used to control Compression.  Use the Additional System Options field to set the COMPRESS= system option.


COMPRESS can be invoked at initialization and in the autoexec.sas, in addition to the Options statement and as a dataset option.
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now