SAS中文论坛

标题: 排序不能之问题? [打印本页]

作者: shiyiming    时间: 2010-7-30 18:41
标题: 排序不能之问题?
请问各位前辈,我现在有一个排序的问题,不知应如何解决?我在进行排序时,无法排序,并出现错误讯息,请问这是代表什么意思,我该如何解决并顺利完成排序呢?

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    时间: 2010-7-30 23:19
标题: Re: 排序不能之问题?
娶个或者猜个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    时间: 2010-8-3 20:29
标题: Re: 排序不能之问题?
这问题我已经决解完成了,因为我所排序的变量中有许多空值,造成无法排序的问题,因此我此它的空值补上数字后就可以排序了。也谢谢前辈的指教!
作者: shiyiming    时间: 2010-8-3 21:10
标题: Re: 排序不能之问题?
to benny10
缺失值和是否能够排序有什么关系?还望指教。我感觉不是问题的关键。
作者: shiyiming    时间: 2010-8-5 20:16
标题: Re: 排序不能之问题?
其实我也不清楚,因为我是将遗漏的部分补齐后就可以执行排序的功能,所以是不是排序的问题,我也说不准,也请知道的前辈可能帮忙解答。




欢迎光临 SAS中文论坛 (https://mysas.net/forum/) Powered by Discuz! X3.2