Help using Base SAS procedures

ERROR: Sort execution failure in PROC SQL

Reply
Contributor
Posts: 21

ERROR: Sort execution failure in PROC SQL

Hi,

 

I am using SAS and have been running my code up till now just fine. Tonight I got an error message saying (below) when doing a proc sql. I have looked at previous answers to questions on this topic and have troubleshooted them using that concept but it still doesn't work. Do you have any other suggestions?

 

 

NOTE: The query requires remerging summary statistics back with the original data.
ERROR: Sort execution failure.

 

Valued Guide
Posts: 568

Re: ERROR: Sort execution failure in PROC SQL

Have you tried using Google to find a solution?

Search-query: site:sas.com proc sql  Sort execution failure

First link: https://communities.sas.com/t5/SAS-Procedures/ERROR-Sort-execution-failure-in-PROC-SQL/td-p/262581

 

 

Super User
Posts: 10,238

Re: ERROR: Sort execution failure in PROC SQL

Looks like you ran out of space because of data growth. Optimize your SQL code, or replace it with data/sort steps, if such is possible,

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
Ask a Question
Discussion stats
  • 2 replies
  • 1885 views
  • 0 likes
  • 3 in conversation