We are using explicit SQL pass through statements to query a large table in Redshift. The Proc SQL completes without a SAS error but has only about half the number of records we were expecting. Our DBA reviewed the Redshift database log and found the query had an out of memory error and stopped fetching additional rows from the table. Since these are production Jobs we need to have the SAS Proc SQL Step fail with an error as we do not want to continue the process with an incomplete data set. Additionally, since this is a "silent" error, our users would never know there was problem. Does anyone know how to pass this Redshift error down to our SAS job? Thanks.
... View more
