请教各位前辈，小弟目前在运行一sql语法时遇到一个问题，就是运行到最后在log的地方竟出现error的讯息说是排序有问题，但是我之前的code有做排序且log上也没出现问题，那么这个code究竟是有什么问题导致无法运行呢，请各位前辈帮帮忙! (因为我的数据量是比较大，大概是GB以上，会不会是内存不足造成的呢?)

data book1;
infile 'G:\ ddd\0502-3.txt' missover;
input a $ 1-2 b $ 3-4 c $5-6 sno 7-14 no $ 15-20 time 21-26 execution 27 buy 28 sell 29 d 30 e 31 f 32 g 33 p1 34-39 q1 40-47 p2 48-53 q2 54-61 p3 62-67 q3 68-75 p4 76-81 q4 82-89 p5 90-95 q5 96-103 p6 104-109 q6 110-117 p7 118-123 q7 124-131 p8 132-137 q8 138-145 p9 146-151 q9 152-159 p10 160-165 q10 166-173 p11 174-179 q11 180-187 date 188-195;
run;
proc sort data=book1;
by no date time;
run;
data book2;
infile 'e:\ddd\ 0502.txt' missover;
input stock $ 1-6 ooq 7-14 oop 15-20 type $ 21 odate  22-29 otime 30-37 eeq 38-45 eep 46-51 edate  52-59 etime 60-65 bs $ 66 or $ 67 sex $ 68 age 69-70 sex1 71 credit 72 web 73 pi 74 maxdeal 75-82 frequency 83-88 corder 89 noexorder 90
run;

data b;
set book2;
i+1;
id1=put(i,6.);
run;
proc sql ;
create table new  as
select *,abs(time-otime) as timed
from b,book1
WHERE  stock = no and date=odate and otime>time
group by id1
having timed = min(calculated  timed) ;
NOTE: The query requires remerging summary statistics back with the original data.
ERROR: Sort execution failure.
quit;