SAS Programming

DATA Step, Macro, Functions and more
BookmarkSubscribeRSS Feed
sateh
Obsidian | Level 7

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.

sateh_0-1667338268149.png

if I select the button "establecer" the whole section is restarted. and I select the button "cancelar" appear this:

sateh_1-1667338425589.png

 

4 REPLIES 4
SASKiwi
PROC Star

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?

sateh
Obsidian | Level 7

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: 

sateh_0-1667345439493.png

I don't get any kind of error or warning

SASKiwi
PROC Star

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.

ahmedaldorr
Fluorite | Level 6

Hello, I wonder if you had the chance to get this issue resolved, please

I have the same issue

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 4 replies
  • 724 views
  • 1 like
  • 3 in conversation