<div>
ok &nbsp;any idea where to do compress in di studio on tables
</div>


ok  any idea where to do compress in di studio on tables

<div>
The Options Tab in a Loader Properties Dialog Box in SAS Data Integration Studio is used to control Compression. &nbsp;Use the Additional System Options field to set the COMPRESS= system option.<br />
<br />
<br />
COMPRESS can be invoked at initialization and in the autoexec.sas, in addition to the Options statement and as a dataset option.
</div>


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.

<div>
<div class="content wysiwyg-content">
Hi,<br />
We want to compress huge tables to save space how can we do that and how can we determine if compress worked.<br />
<br />
Thanks,
</div>
</div>


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

compress for large tables

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.