Hi folks, When running PROC SQL and an error occurs, how to tell SAS to ignore the error, pause for a few seconds, and rerun the query? The background is: I'm pulling data from the server using PROC SQL. However, the server is not stable and sometimes the connection error occurs (as the picture shows below). Simply rerun the query can resolve the issue. But since it's a loop of many queries wrapped in a macro function, also it takes hours to run through the whole loop, it's not feasible to stop rerun the query manually. So I'm wondering if I can add this logic to this marco: If connection error occurs -> hold for a few seconds -> rerun the query that the error occurs -> next iteration Thank you! The second query is almost the same as the previous one, and runs right after it. But due to connection issue, the second query doesn't run through
... View more