When you sort data, the source table data is copied to a SAS utility file, and then into a table with the same name as the source, but with an extra extension of ".lck". So a table of 100Gb will need 100Gb of utility space and 100Gb of headroom on the drive with the target library. You don't seem to have that space.

When I have such large pieces of work to do, I try to make sure my previous modules clean up their work tables on completion, which ensures more work space is available for subsequent jobs. That may be an option for you through an inserted code block prior to submitting this code block.

I presume that if you cannot access the source code, then you can't access the SAS invocation either. Otherwise you could use the -work option on the invocation to specify alternative storage.

I expect also that you don't have the option to change the system configuration and mount additional storage on the volume where work is currently held.

You should start considering the process to have the source code changed to specify a different output library from the sort procedure. I presume you need to send this back to the client for such changes.

Kind regards

David

The Moving Finger writes; and, having writ, Moves on: nor all your Piety nor Wit Shall lure it back to cancel half a Line, Nor all your Tears wash out a Word of it

Omar Khayyam (trans: Edward Fitzgerald)

-----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Kumar Sent: Thursday, 5 April 2007 9:35 AM To: SAS-L@LISTSERV.UGA.EDU Subject: Re: Reassign WORK Folder ..

Hi Paul, I understand that Proc Sort may not be needed. But, as I mentioned in my last email, I do not have access to the source code and so I cannot make any changes to it. I have to make it work the way it is now. Till date, the same code has been working on a small amount of data and this is the first time I'm running this on 100GB of data with a 50GB of work space .. :(

Thanks Kumar

--- "Paul A. Thompson" <paul@wubios.wustl.edu> wrote:

> Well, in this circumstance, you may wish to not sort. There are many > other ways to do things which do not involve sorting, and you may wish

> to provide details as to what you wish to do. Perhaps sorting is > optional. > > Paul A. Thompson, Ph.D. > Division of Biostatistics, Washington University School of Medicine > 660 S. Euclid, St. Louis, MO 63110-1093 > 314-747-3793 > paul@wubios.wustl.edu > > -----Original Message----- > From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of > Kumar > Sent: Wednesday, April 04, 2007 5:52 PM > To: SAS-L@LISTSERV.UGA.EDU > Subject: Reassign WORK Folder .. > > Is there any way to reassign the work folder under a different engine > such as SPDE or specify various filesystems to use? The code I'm > running is trying to do a PROC SORT and eventually runs out of work > space. So, I'm trying to spread the WORK library across various file > systems. I am aware that the WORK library cannot be reassigned, but > wondering if anyone has a work around for this. > > I'm looking for something similar to the below (Wish it worked!) .. > > libname WORK ('/user1' '/user2', '/user3'); > > Thanks in advance. > > Kumar > > PS. I'm not looking for suggestions on how I can use PROC SORT to > overcome space restrictions because I have no control over the source > code. > > > > > > > > > > > __________________________________________________________ > Yahoo! India Answers: Share what you know. Learn something new > http://in.answers.yahoo.com/ > >

__________________________________________________________ Yahoo! India Answers: Share what you know. Learn something new http://in.answers.yahoo.com/

************** IMPORTANT MESSAGE ***************************** This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. **************************************************************