https://communities.sas.com/t5/SAS-Procedures/Max-Query-Time-Exceeded/m-p/21211#M4467 Have you tried to break the query into smaller parts? For example if you are hitting 5 tables can you try to break it into 2 proc sql steps?<BR /> <BR /> I find that helps when I get that error Tue, 10 Jun 2008 20:13:47 GMT deleted_user 2008-06-10T20:13:47Z https://communities.sas.com/t5/SAS-Procedures/Max-Query-Time-Exceeded/m-p/21210#M4466 I'm guessing this is more likely a database issue than a SAS issue, but I'm hoping some other SAS users can help me. I'm using SAS and running a PROC SQL query using ODBC. When I run this query, I'm getting the error:<BR /> <BR /> ERROR: CLI cursor fetch error: [Sybase][ODBC Driver][Adaptive Server IQ]The operation has been cancelled - Max_Query_Time exceeded<BR /> <BR /> From what I can figure out (I'm not the DB Admin), the max_query_time is set to 0 which means unlimited to me.<BR /> <BR /> Has anyone had any experience with query times limiting your ability to query data using SAS? Any recommendations? Tue, 27 May 2008 16:37:06 GMT https://communities.sas.com/t5/SAS-Procedures/Max-Query-Time-Exceeded/m-p/21210#M4466 1162 2008-05-27T16:37:06Z https://communities.sas.com/t5/SAS-Procedures/Max-Query-Time-Exceeded/m-p/21211#M4467 Have you tried to break the query into smaller parts? For example if you are hitting 5 tables can you try to break it into 2 proc sql steps?<BR /> <BR /> I find that helps when I get that error Tue, 10 Jun 2008 20:13:47 GMT https://communities.sas.com/t5/SAS-Procedures/Max-Query-Time-Exceeded/m-p/21211#M4467 deleted_user 2008-06-10T20:13:47Z