SAS server 'Viya' taking longer to respond

[ketan_korde]

Hello everyone,
I am performing a left join in SAS EG using PROC SQL and it is giving me a following message after some time:
"A request to server 'Viya' has taken longer to respond than the 60 minutes threshold.....Wait for connection or Disconnect"

After increasing the wating time by again 60 minutes same message is shown.

It would be very helpful if anyone have solution for this.

Thank you.

[Kurt_Bremser]

Please post the complete (all code and messages) log of the PROC SQL step by copy/pasting it into a window opened with this button:

[ketan_korde]

Hi, in my case log is not generated only the message that I mentioned pops up and the code is:

proc sql;

create table Want as
select a.*,b.*
from Lib1.Have1 a
left join Lib2.Have2 b
on trim(upcase (a.ID))=trim(upcase(b.ID)) and trim (upcase (a.MemberNo))=trim(upcase(b.MemberNo))
AND a.Date_Received between b.'Start Date'n and b. 'End Date'n
AND a.Date_Received between b.policy_startdate and b.policy_ enddate
AND a.Date_Received between b.policy_start_date and b.policy_end_date;

QUIT;

Left Data contains 90,00,32 and Right Data 8,10,74,788

[SASKiwi]

What does your SAS log show? That your PROC SQL query never completes or something else? My guess is that the query never completes and that EG is prompting you if you want to continue running it or not.

What type of solution do you want? For the message not to pop up every 60 minutes, which I suspect might be an EG setting, or for your query to run faster so it completes in less than 60 minutes avoiding the message?

[ketan_korde]

Yes, it never completes and SAS log doesn't show anything only the message of 60 minutes

[SASKiwi]

Please post your program in that case.

[ketan_korde]

proc sql;

create table Want as
select a.*,b.*
from Lib1.Have1 a
left join Lib2.Have2 b
on trim(upcase (a.ID))=trim(upcase(b.ID)) and trim (upcase (a.MemberNo))=trim(upcase(b.MemberNo))
AND a.Date_Received between b.'Start Date'n and b. 'End Date'n
AND a.Date_Received between b.policy_startdate and b.policy_ enddate
AND a.Date_Received between b.policy_start_date and b.policy_end_date;

QUIT;

Left Data contains 90,00,32 and Right Data 8,10,74,788

[SASKiwi]

Do LIB1 and LIB2 point to external databases by any chance? If so it is possible that SAS can't push the functions you are using and so is reading all data to SAS first before joining. What happens if you remove the TRIM and UPCASE functions?