At 12:27 PM 10/9/2001 -0600, Jack Hamilton wrote: >You might not have enough disk space to perform a normal sort. Two >alternative you might try: > >1) Rather than sorting the data set, create an index. Unfortunately, this >can also be quite large. > >2) Rather than using the standard sort, use tagsort: "PROC SORT TAGSORT >data=", etc. This can take longer than a regualr sort but is supposed to >use less temporary disk space.

This isn't meant to be cute, simply another option:

At today's prices, grab another large ( > 36GB ) drive; IDE's are especially inexpensive.

And Rich (the original poster), I believe the rule of thumb is that you'll roughly need 3 times the space of what you're sorting - use this to guage all your options.

Note: Other's might have a slightly different "ratio" - anyone?

>-- >JackHamilton@FirstHealth.com >Development Manager, Technical Group >METRICS Department, First Health >West Sacramento, California USA > > > >>> Rich <shpzh2000@YAHOO.COM> 10/09/2001 11:10 AM >>> >Dear all, > >I am working with a 8GB dataset under SAS 8.0 on a Windows NT under >NTFS sytem. I need to sort the data set according to 2 variables. I >have 22GB free space in the hard drive. During the sorting, a >temporary system utility file with size 18GB is created. Then the >process stopped because of "OUT OF RESOURCE". > >What should I do with it? Thanks a lot. > >Rich

------------------------------------------------------------ William W. Viergever Voice : (916) 483-8398 Viergever & Associates Fax : (916) 486-1488 Sacramento, CA 95825 E-mail : wwvierg@attglobal.net ------------------------------------------------------------