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 (May 1999, week 1)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Mon, 3 May 1999 21:24:34 -0400
Reply-To:   Richard DeVenezia <radevenz@IX.NETCOM.COM>
Sender:   "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:   Richard DeVenezia <radevenz@IX.NETCOM.COM>
Organization:   Netcom
Subject:   Re: PROC SORT: Disk Size limitations

Depending on why you 'need' to sort the data, you may not have to at all. Instead a compound index on the three variables you normally want to sort by.

proc datasets lib=mylib; modify mydata; index create sortby3=(var1 var2 var3); run;

any datastep or proc with a by var1 var2 var3; will utilize the index to pull out obs in sorted order.

Rich

Robert Virgile wrote in message <3729FDD2.6A3BA077@mediaone.net>... >If you try this, run it overnight. It sometimes chews up enormous amounts of >CPU time: > >proc sort data=whatever tagsort; >by byvars; > >The tagsort option uses less space, usually at the expense of CPU time. It >sorts just the by variables plus a tag to the observation number, then retrieves >the remaining variables based on the observation number. > >Bob Virgile > > >jgropp1 wrote: > >> I have a data set with 7569504 observations and 7 variables and I'm trying >> to sort it by 3 variables and I'm having trouble with the work space >> available for sorting. The data is approx. 407 MB itself and there is about >> 1.5 GB of remaining space on the hard drive. I figured even if SAS rewrote >> the file 3 times during the sort procedure then the would still leave about >> 300MB of space, however I still run out of disk space. I know that one can >> play around with the Proc Sort options to correct my problem but I am leery >> about changing some parameters without some guidance. I'm using SAS 6.12 >> for Windows on a system with WIN98 350mhz/64mb ram. Any ideas? >> >> Thanks, >> Jeff


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