Error: no disk space is available for the write operation.

Reply
New Contributor
Posts: 2

Error: no disk space is available for the write operation.

There is a proc sort in my program . When that program ran in batch it gave error below that proc sort:-

Error: no disk space is available for the write operation. filename=-----------------.utl

 

Why it is so?

And what is this utl file?

I cant find that utl file in that location now.

 

Thanks

Super User
Posts: 7,465

Re: Error: no disk space is available for the write operation.

The .utl file is the so-called utility file that SAS uses during the sort operation, when the sort cannot be performed solely in memory. It is usually stored in WORK and is only present as long as proc sort runs.

The UTILLOC= system option can be used to have this file stored in another location (useful for space and/or performance reasons).

 

If you sort a dataset that was created with compress=yes, the utility file will be uncompressed and therefore grow to the raw size of the uncompressed dataset. In that case, using the tagsort option in proc sort will make the sort possible, as long as you have enough space in the target library.

 

If you were sorting a dataset in WORK, you need 2 times the size of the dataset (original and target) and the space needed for the utility file for the sort to be successful.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Super User
Posts: 19,194

Re: Error: no disk space is available for the write operation.

If you're working in SAS studio via UE or Academics On Demand there are limitations to the size of data that can be processed. 

Ask a Question
Discussion stats
  • 2 replies
  • 296 views
  • 0 likes
  • 3 in conversation