I have a code in SAS that performs several processes, and there is a process that generates a table with 19,985,984 records because it is required, then that table is taken to another process where sql is applied using some joins with another table, when the execution of my code reaches that part, the following messages appear in SAS STUDIO and I really don't know what it can be.
if I select the button "establecer" the whole section is restarted. and I select the button "cancelar" appear this:
Looks like a timeout problem to me. How long does your program run for when this happens? Are you able to check your SAS log for additional information? If so can you post it please. Are you reading the data from an external database by any chance?
I have the timeout configured in the session as 36000, the code starts executing then after another process must be done with the large table that I mentioned but that is where these windows appear, I am not reading the data from a database data, the code executes and lasts about 5 minutes and that is where the windows appear, in the log it shows me this:
I don't get any kind of error or warning
Hmm, 5 minutes isn't very long so maybe there is some other cause. I suggest you open a Tech Support track given this is a SAS Viya problem and likely will require diagnosing of server logs.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.