排序不能之问题?

shiyiming

请问各位前辈，我现在有一个排序的问题，不知应如何解决?我在进行排序时，无法排序，并出现错误讯息，请问这是代表什么意思，我该如何解决并顺利完成排序呢?

data book5;
set book4;
run;
proc sort data=book5;
   by date ;
run;

223  proc sort data=book5;
224     by date time;
225  run;

ERROR: Utility file write failed.  Probable disk full condition.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: There were 670977 observations read from the data set WORK.BOOK5.
WARNING: The data set WORK.BOOK5 may be incomplete.  When this step was stopped there were 0 observations and 45 variables.
WARNING: Data set WORK.BOOK5 was not replaced because this step was stopped.
NOTE: PROCEDURE SORT used (Total process time):
      real time           7.67 seconds
      cpu time            1.45 seconds


226
227  proc sort data=book5;
228     by date ;
229  run;

ERROR: Utility file write failed.  Probable disk full condition.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: There were 684545 observations read from the data set WORK.BOOK5.
WARNING: The data set WORK.BOOK5 may be incomplete.  When this step was stopped there were 0 observations and 45 variables.
WARNING: Data set WORK.BOOK5 was not replaced because this step was stopped.
NOTE: PROCEDURE SORT used (Total process time):
      real time           3.82 seconds
      cpu time            0.84 seconds

shiyiming

娶个或者猜个date的中间值。
proc sort data = book4(where = (date < middle_date)) out = book5_1; by date;
proc sort; by date time;
run;

proc sort data = book4(where = (date >= middle_date)) out = book5_2; by date;
proc sort; by date time;
run;

data book5;
set book5_1 book5_2; by date time;
run;

如果不行，就分成4部分，8部分，。。。

shiyiming

这问题我已经决解完成了，因为我所排序的变量中有许多空值，造成无法排序的问题，因此我此它的空值补上数字后就可以排序了。也谢谢前辈的指教!

shiyiming

to benny10
缺失值和是否能够排序有什么关系？还望指教。我感觉不是问题的关键。

shiyiming

其实我也不清楚，因为我是将遗漏的部分补齐后就可以执行排序的功能，所以是不是排序的问题，我也说不准，也请知道的前辈可能帮忙解答。