Date:         Fri, 4 May 2007 12:51:55 -0700
Reply-To:     "Pardee, Roy" <pardee.r@GHC.ORG>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Pardee, Roy" <pardee.r@GHC.ORG>
Subject:      Re: Optimize SAS Data size
In-Reply-To:  A<200705041932.l44Fi0Tv027882@mailgw.cc.uga.edu>
Content-Type: text/plain; charset="us-ascii"

Have a look at this here:

http://support.sas.com/ctx/samples/index.jsp?sid=268

-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
Venu
Sent: Friday, May 04, 2007 12:33 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Optimize SAS Data size

Hi All,
Need quick help ..
Is there any simple approach to :

1. Determine SAS DATA SET SIZE programatically. .

   For ex: If you cLICK -> view -> SAS EXPLORER
    you will know the data set size.

2. Optimize SAS data set .

   1. Calculate the length of the varaible(s) based on the actual length
.
    which is simlar to VARCHAR2 in ORacle.

  2. Then idenify the appropriate length saving some space.

This info is helpful in automating scripts to reduce space and vaoiding
compressed data sets.

Thanks
venu