Date:         Sun, 8 Dec 2002 06:33:17 +0000
Reply-To:     sashole@bellsouth.net
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Paul Dorfman <paul_dorfman@HOTMAIL.COM>
Subject:      Re: gotta watch the compression
Comments: To: KevinMyers@AUSTIN.RR.COM
Content-Type: text/plain; format=flowed

Hmmm... Meseemeth I just saw it in the current SASware Ballot in

Base SAS Software
PART I SAS Language
General
....
3 disable data set compression "on the fly" for data sets that will not be
reduced in size by compression

Guess "is" should be rather phrased as "maybe will"...

Kind regards,
----------------
Paul M. Dorfman
Jacksonville, FL
----------------


----Original Message Follows----
From: Kevin Myers <KevinMyers@AUSTIN.RR.COM>

Can't remember whether it is in 8.2 or 9.0, but in some recent version
compression is automatically disabled when it would actually result in an
expansion of data set size.

s/KAM


----- Original Message -----
From: "Wainwright, Andrea" <andrea.wainwright@CAPITALONE.COM>
Newsgroups: bit.listserv.sas-l
To: <SAS-L@LISTSERV.UGA.EDU>
Sent: Saturday, December 07, 2002 2:14 PM
Subject: gotta watch the compression


 > I just noticed the following in a log file:
 >
 > NOTE: Compressing data set Y.SAMPLE increased size by 754.48 percent.
 >       Compressed is 73528 pages; un-compressed would require 8605 pages.
 > NOTE: PROCEDURE SQL used:
 >       real time           19:26.60
 >       cpu time            4:55.63
 >
 > I have seen it increase, but never 7X!
 >
 > Needless to say, I am removing the compress=yes option from this data
set.
 >
 >
 > ********************************
 > Andrea Wainwright
 > Names One
 > Sr. SAS Programmer/Analyst
 >
 >
**************************************************************************
 > The information transmitted herewith is sensitive information intended
only
 > for use by the individual or entity to which it is addressed. If the
reader
 > of this message is not the intended recipient, you are hereby notified
that
 > any review, retransmission, dissemination, distribution, copying or other
 > use of, or taking of any action in reliance upon this information is
 > strictly prohibited. If you have received this communication in error,
 > please contact the sender and delete the material from your computer.


_________________________________________________________________
The new MSN 8: advanced junk mail protection and 2 months FREE*
http://join.msn.com/?page=features/junkmail