05-28-2013 04:00 PM
I've been trying to run a proc sql and get a sort execution failure every time. Here is the code:
create table _temp (drop=evtdate)
as select a.*, a.evtdate as _edate format date9., b.*
from _temp a left join _caldates (drop=time) b
group by a.evtdate
And the error message:
NOTE: SAS threaded sort was used.
ERROR: Sort execution failure.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE SQL used (Total process time):
real time 1:08:58.65
user cpu time 2:08.34
system cpu time 11:55.76
OS Memory 78456k
Timestamp 5/22/2013 12:20:47 PM
The dataset _temp has 9468 observations and 222 variables. The dataset _caldates has 9351 observations and 6 variables. I would not expect these datasets to be too large to cause this problem from what I've seen about the sort execution failure. Any help would be so appreciated! Thanks!