Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

compress for large tables

Posted on 2011-09-08
3
Medium Priority
?
436 Views
Last Modified: 2013-11-16
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
Comment
Question by:sam2929
3 Comments
 
LVL 11

Accepted Solution

by:
theartfuldazzler earned 2000 total points
ID: 36502010
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
 

Author Comment

by:sam2929
ID: 36502597
ok  any idea where to do compress in di studio on tables
0
 
LVL 7

Expert Comment

by:d507201
ID: 36502918
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

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller singl…
This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
Suggested Courses

971 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question