topic Re: Query_timeout in connection Proc sql in SAS Programming

Query_timeout in connection Proc sql

sabya_biswal — Wed, 16 Dec 2020 12:11:24 GMT

Hi ,

Can you please help on how to use query_timeout /timeout option in connection part of proc sql in SAS.

I am specifically looking for Oracle connection, and the purpose is to abort the query execution when it reaches the timeout threshold.

Re: Query_timeout in connection Proc sql

ChrisNZ — Thu, 17 Dec 2020 00:51:45 GMT

> abort the query execution when it reaches the timeout threshold.

I don't think such an option exists on the SAS side. It's usually the Oracle DBAs who set these kinds of limits

Re: Query_timeout in connection Proc sql

ChrisNZ — Thu, 17 Dec 2020 01:13:15 GMT

Actually, the SAS documentation doesn't mention Oracle or ODBC, but ODBC seems to support that option.

See page 19 of http://www.math.wpi.edu/saspdf/accodbc/c01.pdf

When things get cloudy like that. a call to tech support to ask them to answer the question, and to clarify the documentation is often the best option.

What to you get when you try?

Re: Query_timeout in connection Proc sql

SASKiwi — Thu, 17 Dec 2020 05:41:15 GMT

@sabya_biswal - Please post the SAS log including the error you are getting.