Date:         Wed, 2 Jul 2008 12:16:04 -0400
Reply-To:     patrice.bourdages@DESJARDINS.COM
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Patrice Bourdages <patrice.bourdages@DESJARDINS.COM>
Subject:      RE Dataset size increasing a lot
Comments: To: guidosagasti@yahoo.com.ar
In-Reply-To:  <164877.41697.qm@web90407.mail.mud.yahoo.com>
Content-Type: text/plain; charset="ISO-8859-1"

It sounds like the original dataset (Data1) is compressed...

In order to find out, open the original dataset in a viewtable, go to the 
menu "Data" and select "Table Attributes". From there, choose the 
"Advanced" tab and look for (check) into the "Attributes (compressed)" 
item.

Hope if will help you out.

Sincerely yours,

Patrice B. :)

P.S.; In order to create a sas dataset in compress mode, you could either 
use "data work.data2 (compress = yes);" or specify the compress option 
like the following "options compress = yes" just before you execute your 

code. The first option is the one I would rather use since the compression 

will only apply to this dataset. The second option will affect all the 
datasets following the options or until you switch it back to "options 
compress = no;".


"SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> a écrit sur 2008-07-02 
12:01:09 :

> Hi list.
>  
> Playing with a dataset I find this issue:
>  
> Original dataset: data1. (Size: 76745 kb). 2000000 obs, 6 vars.
>  
> I made a copy in my hard disk of the same dataset with the name data2.
>  
> Using the following code:
>  
> proc sql;
> delete * from data1;
> quit;
> 
> I got a file with 0 obs, 6 vars and the same size.
>  
> Then I insert the data2 into the data1 to see data1 size with this code:
>  
> proc sql;
> insert into data1
> select * 
> from data2;
> quit;
>  
> The result is a data1 with 2000000 obs. and 6 vars (the same as 
> data2) but with the size doubled.
>  
> Taking a look in the explorer I went to the datasets properties and 
> found in the details the following:
> For data1: Deleted Rows: 2000000.
> Number of dataset pages: 38372.
> For data2: Deleted Rows: 0
> Number of dataset pages: 19186.
> 
> Can anybody help me about dealing with this issue? Because in a real
> scenario the dataset sizes is going to increase and increase in 
> every delete and insert of rows.
>  
> Thanks,
> Guido. 
> 
> 
> 
> 
____________________________________________________________________________________
> ¡Buscá desde tu celular!
> 
> Yahoo! oneSEARCH ahora está en Claro
> 
> http://ar.mobile.yahoo.com/onesearch