BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
VNguyen
Calcite | Level 5

Hello,

 

I am writing to program to retrieve data from databases (MS SQL, MS Access, etc) using Proc SQL in Base SAS. Since I do not know if the SQL statement may take too long and ends up freezing SAS, I would like to time the excution, i.e have a piece of code directly within the program that tracks how long the query has been running and if it runs for too long (say more than a few minutes) then terminates the execution. Could you please give me some advice?

 

Thank you,

Vi

1 ACCEPTED SOLUTION

Accepted Solutions
Sven111
Pyrite | Level 9

I don't think you can do this from within one SAS program (although I'd love to been shown otherwise!).  I have some code that I created that outputs data (timestamp + descriptive text basically) to a text file (using FILENAME, FPUT, FAPPEND, etc) so I can monitor the process of an ongoing job, and you could probably combine something like that with a shell script that monitors that text file and kills the SAS job if it's not seeing progress.

View solution in original post

1 REPLY 1
Sven111
Pyrite | Level 9

I don't think you can do this from within one SAS program (although I'd love to been shown otherwise!).  I have some code that I created that outputs data (timestamp + descriptive text basically) to a text file (using FILENAME, FPUT, FAPPEND, etc) so I can monitor the process of an ongoing job, and you could probably combine something like that with a shell script that monitors that text file and kills the SAS job if it's not seeing progress.

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

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
  • 1 reply
  • 1320 views
  • 0 likes
  • 2 in conversation