Sort execution failure

[TomA]

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]

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

Scott Barry
SBBWorks, Inc.

[TomA]

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]

Hi Tom,

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

Regards,
Milton

[sbb]

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