Help using Base SAS procedures

Sort execution failure

Reply
Occasional Contributor
Posts: 14

Sort execution failure

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
Super Contributor
Super Contributor
Posts: 3,174

Re: Sort execution failure

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

Scott Barry
SBBWorks, Inc.
Occasional Contributor
Posts: 14

Re: Sort execution failure

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
Super Contributor
Posts: 326

Re: Sort execution failure

Hi Tom,

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

Regards,
Milton
Super Contributor
Super Contributor
Posts: 3,174

Re: Sort execution failure

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
Ask a Question
Discussion stats
  • 4 replies
  • 2281 views
  • 0 likes
  • 3 in conversation