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
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
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.
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)
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
Sent: Thursday, 5 April 2007 9:35 AM
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 .. :(
--- "Paul A. Thompson" <email@example.com> 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
> Paul A. Thompson, Ph.D.
> Division of Biostatistics, Washington University School of Medicine
> 660 S. Euclid, St. Louis, MO 63110-1093
> -----Original Message-----
> From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
> 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.
> 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
> Yahoo! India Answers: Share what you know. Learn something new
Yahoo! India Answers: Share what you know. Learn something new
************** IMPORTANT MESSAGE *****************************
This e-mail message is intended only for the addressee(s) and contains information which may be
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.