LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (July 2008, week 1)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Wed, 2 Jul 2008 12:56:57 -0400
Reply-To:     Nathaniel.Wooding@DOM.COM
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Nat Wooding <Nathaniel.Wooding@DOM.COM>
Subject:      Re: RE Dataset size increasing a lot
Comments: To: guidosagasti@yahoo.com.ar
In-Reply-To:  <726022.9665.qm@web90401.mail.mud.yahoo.com>
Content-Type: text/plain; charset="ISO-8859-1"

Have you compared the widths of the character variables in the two files?

Nat Wooding Environmental Specialist III Dominion, Environmental Biology 4111 Castlewood Rd Richmond, VA 23234 Phone:804-271-5313, Fax: 804-271-2977

Guido Sagasti <guidosagasti@YAH OO.COM.AR> To Sent by: "SAS(r) SAS-L@LISTSERV.UGA.EDU Discussion" cc <SAS-L@LISTSERV.U GA.EDU> Subject Re: RE Dataset size increasing a lot 07/02/2008 12:53 PM

Please respond to guidosagasti@yaho o.com.ar

Thanks Patrice but the files are not compressed...

--- El mié 2-jul-08, patrice.bourdages@desjardins.com <patrice.bourdages@desjardins.com> escribió:

De: patrice.bourdages@desjardins.com <patrice.bourdages@desjardins.com> Asunto: RE Dataset size increasing a lot Para: guidosagasti@yahoo.com.ar Cc: SAS-L@LISTSERV.UGA.EDU Fecha: miércoles, 2 de julio de 2008, 1:16 pm

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

____________________________________________________________________________________

¡Buscá desde tu celular!

Yahoo! oneSEARCH ahora está en Claro

http://ar.mobile.yahoo.com/onesearch

CONFIDENTIALITY NOTICE: This electronic message contains information which may be legally confidential and/or privileged and does not in any case represent a firm ENERGY COMMODITY bid or offer relating thereto which binds the sender without an additional express written confirmation to that effect. The information is intended solely for the individual or entity named above and access by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution, or use of the contents of this information is prohibited and may be unlawful. If you have received this electronic transmission in error, please reply immediately to the sender that you have received the message in error, and delete it. Thank you.


Back to: Top of message | Previous page | Main SAS-L page