Date:         Thu, 8 Jun 2006 09:31:39 -0700
Reply-To:     Reeza <fkhurshed@HOTMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Reeza <fkhurshed@HOTMAIL.COM>
Organization: http://groups.google.com
Subject:      Re: Memory usage with PROC SORT/out of memory
Comments: To: sas-l@uga.edu
In-Reply-To:  <1149779664.181265.118230@g10g2000cwb.googlegroups.com>
Content-Type: text/plain; charset="iso-8859-1"

If it was out of physical memory, the error would read disk full.  Out
of Memory implies some other error, maybe RAM or the page error.  I'm
currently trying to figure out how to sort a 50GB file and keep running
into similar problems.
Dubro wrote:
> Dear Group,
>
> I use SAS 9.1.3 Base for Windows on a Dell Optiplex Pentium 4 Dual Core
> 3.2 Ghz with 2 GB RAM Machine with WinXP.
> The -work library in SAS is set to an empty 250 GB Hard Disk.
> Now I tried to sort a dataset with 356,802,476 Rows and 23 Columns. The
> data set has 37 GB.
> After expanding some temporary help files (*.UTL) to about 100 GB the
> PROC SORT stops with an error message (out of memory) and an unsorted
> file. See following Sort statement:
>
> proc sort data = shuffle;
>       by userid timestamp;
> run;
>
> After halt the *.UTL file in the tmporary directory has about 70 GB and
> there still is enough space on the hard disc where the temporary
> directory resides.
>
> Why is SAS terminating with an OUT OF MEMORY message?
>
> Any suggestions?
>
> Dubro
> www.dolic.de