Architecting, installing and maintaining your SAS environment

No disk space is available for the write operation

Accepted Solution Solved
Reply
Super Contributor
Super Contributor
Posts: 359
Accepted Solution

No disk space is available for the write operation

Hello Friends, 

 Please help,

We are using sas 9.4 on windows and getting below error while running PROC SORT for multiple key varible with big dataset,


ERROR: No disk space is available for the write operation. Filename = C:\xxxxxx\xxxxxxxxxx\AppData\xxxxx\Temp\SAS Temporary
Files\SAS_util0001000019F8_xxxxxxxxxxxxxx\ut19F8000008.utl.

 

I checked some config file and found we have below options set. Is there anything needs to be taken care? Thank you in advance. 

MEMSIZE 2G
SORTSIZE 1G


Accepted Solutions
Solution
‎04-11-2016 11:04 PM
Super User
Posts: 5,437

Re: No disk space is available for the write operation

Doesn't sound likely, but that doesn't matter now, right?
If you can't free up space is the good news that disk is cheap.
Use the TAGSORT in PROC SORT to get it working now. The downside is that it will take much longer to complete.
And don't forget to increase your memory settings.
Data never sleeps

View solution in original post


All Replies
Super User
Posts: 3,260

Re: No disk space is available for the write operation

The error suggests that your C: hard drive has run out of space. Go into Windows Explorer and check the properties of your C: drive - how much free space do you have? You need free space that is around three times the size of your dataset for it to sort properly.

 

Clean up your C: drive by deleting any old temporary files and directories plus anything else you dont need, and empty your Recycle Bin. 

 

Super User
Posts: 5,437

Re: No disk space is available for the write operation

You could probably increase your memory settings a bit. Will improve performance a rsuce the sort spill files a bit.
Go to Windows Task Manager and see how much RAM you got left.
Data never sleeps
Super Contributor
Super Contributor
Posts: 359

Re: No disk space is available for the write operation

Thanks SASKiwi and LinusH for your reply. 

 

Sorting dataset is ~26 gb (where we receive disc space error) and total availble space on C drive is almost same. However, we have old SAS server where similar PROC SORT process running fine with less avaible C drive space and similat dataset size. 

Super User
Posts: 7,852

Re: No disk space is available for the write operation

A SORT will not work if you only have the size of the dataset as free space. You need the space for the output (which will be equal to the input dataset, unless you reduce the number of variables) and the space for the utility file, which will be at least the size of the output dataset unless you use the tagsort= option (stores only key(s) and record pointer in the utility file). If your dataset is stored with the compress=yes option, the utility file will be even bigger, as it is not compressed.

 

I positively do not believe that the same (identical) sort works under the same space constraints on your old server.

 

Clean up your C: drive, and/or add disk space. 26 GB is next to nothing in the age of multi-TB drives.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Solution
‎04-11-2016 11:04 PM
Super User
Posts: 5,437

Re: No disk space is available for the write operation

Doesn't sound likely, but that doesn't matter now, right?
If you can't free up space is the good news that disk is cheap.
Use the TAGSORT in PROC SORT to get it working now. The downside is that it will take much longer to complete.
And don't forget to increase your memory settings.
Data never sleeps
Super User
Posts: 10,044

Re: No disk space is available for the write operation

[ Edited ]

Some thought:

1) Use SPDE engine if you could .

2) Use the following option could enhance proc sort speed.

proc sort sortsize=max noequals 

3)If WORK library don't have enought disk space , you can follow this :

find a enough dish of paritition like D: or E: and create a folder TEMP .and use option :

options user='d:\temp' utilloc='d:\temp';

proc sort...........

 4) Make an index . Once you make it , you don't need proc sort anymore .

 

Super Contributor
Super Contributor
Posts: 359

Re: No disk space is available for the write operation

[ Edited ]

Thanks a lot to all for your time and comment. TAGSORT works fine and we redirected temp work directory as long term solution.

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 7 replies
  • 1984 views
  • 5 likes
  • 5 in conversation