Hi
I would have expected that in the example below binary compression reduces the size of the data set more than character compression.
Actually the opposite is true (SAS9.2, Win7, 64Bit):
NOTE: Compressing data set WORK.HAVEB decreased size by 45.84 percent.
Compressed is 645 pages; un-compressed would require 1191 pages.
NOTE: Compressing data set WORK.HAVEC decreased size by 51.97 percent.
Compressed is 572 pages; un-compressed would require 1191 pages.
data haveB(COMPRESS=binary);
do i=1 to 1000000 by 10;
a=' x ';
output;
end;
run;
data haveC(COMPRESS=yes);
do i=1 to 1000000 by 10;
a=' x ';
output;
end;
run;
Can someone explain me this behaviour?
Thanks
Patrick
Message was edited by: Patrick