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: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

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