BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
woo
Lapis Lazuli | Level 10 woo
Lapis Lazuli | Level 10

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

1 ACCEPTED SOLUTION

Accepted Solutions
LinusH
Tourmaline | Level 20
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

7 REPLIES 7
SASKiwi
PROC Star

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. 

 

LinusH
Tourmaline | Level 20
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
woo
Lapis Lazuli | Level 10 woo
Lapis Lazuli | Level 10

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. 

Kurt_Bremser
Super User

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.

LinusH
Tourmaline | Level 20
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
Ksharp
Super User

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 😧 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 .

 

woo
Lapis Lazuli | Level 10 woo
Lapis Lazuli | Level 10

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

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

CLI in SAS Viya

Learn how to install the SAS Viya CLI and a few commands you may find useful in this video by SAS’ Darrell Barton.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 7 replies
  • 13024 views
  • 10 likes
  • 5 in conversation