Re: Sort execution failure

TomA · Posted 10-22-2009 02:24 PM

When doing a Left join, I received the following message,
ERROR: Sort execution failure.
I've never seen this happen before. Has anyone else come across this error ?
thanks

sbb · Posted 10-22-2009 04:39 PM

Share the SAS log with the expanded code for a meaningful response.

Scott Barry
SBBWorks, Inc.

TomA · Posted 10-22-2009 09:46 PM

I don't have the log available right now, but I can give some background. We are in the process of upgrading from 9.1 to 9.2 , and are testing some existing code. Since the code hasn't changed, I'm inclined to think that it has something to do with 9.2 . I'll post the log after I've recreated it.

thanks, Tom

milts · Posted 10-22-2009 10:52 PM

Hi Tom,

Have you tried increasing sortsize option? How large is your dataset?

Regards,
Milton

sbb · Posted 10-24-2009 04:52 PM

Suggest searching the SAS support http://support.sas.com/ website for reference information about PROC SORT and performance considerations.

Scott Barry
SBBWorks, Inc.

Google advanced search argument suggestion:
proc sort failure performance 9.2 site:sas.com

Sort execution failure