https://communities.sas.com/t5/SAS-Procedures/Sort-execution-failure/m-p/76526#M22196 Suggest searching the SAS support <A href="http://support.sas.com/" target="_blank">http://support.sas.com/</A> website for reference information about PROC SORT and performance considerations.<BR /> <BR /> Scott Barry<BR /> SBBWorks, Inc.<BR /> <BR /> Google advanced search argument suggestion:<BR /> proc sort failure performance 9.2 site:sas.com Sat, 24 Oct 2009 20:52:17 GMT sbb 2009-10-24T20:52:17Z https://communities.sas.com/t5/SAS-Procedures/Sort-execution-failure/m-p/76522#M22192 When doing a Left join, I received the following message,<BR /> ERROR: Sort execution failure.<BR /> I've never seen this happen before. Has anyone else come across this error ?<BR /> thanks Thu, 22 Oct 2009 18:24:25 GMT https://communities.sas.com/t5/SAS-Procedures/Sort-execution-failure/m-p/76522#M22192 TomA 2009-10-22T18:24:25Z https://communities.sas.com/t5/SAS-Procedures/Sort-execution-failure/m-p/76523#M22193 Share the SAS log with the expanded code for a meaningful response.<BR /> <BR /> Scott Barry<BR /> SBBWorks, Inc. Thu, 22 Oct 2009 20:39:57 GMT https://communities.sas.com/t5/SAS-Procedures/Sort-execution-failure/m-p/76523#M22193 sbb 2009-10-22T20:39:57Z https://communities.sas.com/t5/SAS-Procedures/Sort-execution-failure/m-p/76524#M22194 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.<BR /> <BR /> thanks, Tom Fri, 23 Oct 2009 01:46:02 GMT https://communities.sas.com/t5/SAS-Procedures/Sort-execution-failure/m-p/76524#M22194 TomA 2009-10-23T01:46:02Z https://communities.sas.com/t5/SAS-Procedures/Sort-execution-failure/m-p/76525#M22195 Hi Tom,<BR /> <BR /> Have you tried increasing sortsize option? How large is your dataset?<BR /> <BR /> Regards,<BR /> Milton Fri, 23 Oct 2009 02:52:46 GMT https://communities.sas.com/t5/SAS-Procedures/Sort-execution-failure/m-p/76525#M22195 milts 2009-10-23T02:52:46Z https://communities.sas.com/t5/SAS-Procedures/Sort-execution-failure/m-p/76526#M22196 Suggest searching the SAS support <A href="http://support.sas.com/" target="_blank">http://support.sas.com/</A> website for reference information about PROC SORT and performance considerations.<BR /> <BR /> Scott Barry<BR /> SBBWorks, Inc.<BR /> <BR /> Google advanced search argument suggestion:<BR /> proc sort failure performance 9.2 site:sas.com Sat, 24 Oct 2009 20:52:17 GMT https://communities.sas.com/t5/SAS-Procedures/Sort-execution-failure/m-p/76526#M22196 sbb 2009-10-24T20:52:17Z