I am attempting to join fairly large data sets (one is over 27 GB) and I keep encountering the following errors. I have successfully run this job in the past, but the slow buildup of data each month appears to have surpassed what my SAS EG is configured for. ERROR: Insufficient space in file WORK.'SASTMP-000000061'.UTILITY. ERROR: File WORK.'SASTMP-000000061'.UTILITY is damaged. I/O processing did not complete. ERROR: There is not enough WORK disk space to store the results of an internal sorting phase. ERROR: An error has occurred. Based on other sources online, I was guided to increase my SORTSIZE and MEMSIZE on the SASv9 config file (I did so by a factor of 5 - certainly more than enough), but this has not resolved the issue. I found this official information from SAS on increasing allocated WORK space, but I do not know what these values mean and I want to be careful before running unknown code. Moreover, the page recommends checking your default WORK library size but does not provide any info on how to do that (nor does anywhere else online I could find). So my two questions are: How do I check my default WORK library size? What do the 500 and 1000 parameters mean in the code provided in the SAS support page? To clear up some outstanding questions you may have, this is running on SAS 9.4 under Enterprise Guide 8.3.3.181. My source files are on my local disk, and I am writing to my local disk. I have checked my work directory in case there were large leftover files from previous jobs. I have also closed the SAS project and then opened and re-ran just this step to make sure my WORK directory is completely empty. I have executed select distinct on the join columns of all tables and found each returns with the same number of original rows (i.e. no duplicates can be generated). I have over 1 TB available on my local disk. Thank you in advance!
... View more