11-07-2016 05:32 AM
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.
11-07-2016 06:35 AM
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.