Hi SAS experts, I use the sas studio background submit to run my code and here is the log: 402 proc sql;
403 create table xing.outp_serv_sort as
404 select *
405 from xing.outp_serv
406 order by enrolid, svcdate;
ERROR: Sort execution failure.
NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.
407
408 /*remove duplicates w/ the same enrolid and svcdate*/
409 create table xing.outp_serv_noduprecs1 as
410 select distinct enrolid, svcdate
411 from xing.outp_serv_sort
412 order by enrolid, svcdate;
NOTE: Statement not executed due to NOEXEC option.
413
414 /*remove duplicates w/ the same enrolid, svcdate, and procgrp*/
415 create table xing.outp_serv_noduprecs2 as
416 select distinct enrolid, svcdate, procgrp
417 from xing.outp_serv_sort
418 order by enrolid, svcdate, procgrp;
NOTE: Statement not executed due to NOEXEC option.
419 quit;
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE SQL used (Total process time):
real time 1:39.93
cpu time 38.82 seconds It says the sort execution failed (line 402 to 406). The table xing.outp_serv has more than 5 billion observations. Is it due to the table too big and cannot be sorted? How can I fix it? Thanks!
... View more