This is irrelevant to the topic, but I am getting an error "Not allowed to post content more than once every 120 seconds" when I try to post a new thread on this forum. My new question for a thread is: I am trying to conduct a proc sql which does a left join, but I get an ERROR: Sort execution failure. I have tried changing the value of sortsize, but that does not seem to work. Modifying the value of memsize is blanked out. I am changing it through Tools > Options > System > System Adminstration > Memory. I have put in options fullstimer msglevel=i ; Some of my log is: NOTE: SAS threaded sort was used. ERROR: Sort execution failure. 40 quit; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SQL used (Total process time): real time 46:15.10 user cpu time 6:09.48 system cpu time 1:10.21 memory 539212.23k OS Memory 561896.00k Timestamp 05/06/2015 11:44:34 PM Step Count 7 Switch Count 0 and 22 quit; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SQL used (Total process time): real time 42:58.80 user cpu time 6:03.10 system cpu time 1:09.32 memory 1247728.63k OS Memory 1269916.00k Timestamp 05/06/2015 10:38:24 PM Step Count 4 Switch Count 0 Usually, it only takes about 25 minutes to get an error so the 40+ mins is a bit different. I don't think the errors are occurring due to a lack of disk space as I have over 25 GB of free space and the two files I am trying to join together are around 3GB and 30 MB respectively. Unless, there is a restriction on the amount of memory Temporary Files can take?
... View more