BookmarkSubscribeRSS Feed
shl007
Obsidian | Level 7

Hi - somehow in my code, even though I'm not setting options to compress datasets, the log file says it is such as below. Any ideas how I can turn off this "automatic" compression and instead invoke it at the END of my code?

 

NOTE: Compressing data set mylib.testdata decreased size by 59.25 percent.
Compressed is 5622 pages; un-compressed would require 13796 pages.

3 REPLIES 3
shl007
Obsidian | Level 7
I just found the culprit in my code, so now I'm wondering how I can invoke the compression at the end of the code and have it compress ALL the datasets the code ran through? Maybe I need to store each dataset in a table, then loop through that table to compress each dataset?
Ksharp
Super User
options compress=no;
Tom
Super User Tom
Super User

@shl007 wrote:

Hi - somehow in my code, even though I'm not setting options to compress datasets, the log file says it is such as below. Any ideas how I can turn off this "automatic" compression and instead invoke it at the END of my code?

 

NOTE: Compressing data set mylib.testdata decreased size by 59.25 percent.
Compressed is 5622 pages; un-compressed would require 13796 pages.


If your datasets are compressing by 60% then you are probably better off leaving the compression on all of the time.  Most SAS jobs are I/O bound and not CPU bound.  So taking a few extra CPU cylces to compress/expand the records from the file is more than offset by the reduced number of disk reads and writes.

SAS Innovate 2025: Call for Content

Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!

Submit your idea!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 1056 views
  • 0 likes
  • 3 in conversation