topic Re: Automating SAS: halt code execution at a specified time in SAS Programming

Automating SAS: halt code execution at a specified time

BillJones — Wed, 26 Jun 2013 09:30:28 GMT

Hello,

What's the most efficient way to stop executing a fairly involved program at a specified time? For example if I have a program with several macros and data steps would I use a batch command to stop the code at 7am PST? Or is there an easy way to use a time parameter within SAS that would apply to the entire program (E.g. DO UNTIL loop)? Any help or advice would be greatly appreciated. Thank you!

Regards,

Bill

Re: Automating SAS: halt code execution at a specified time

Ksharp — Wed, 26 Jun 2013 09:40:20 GMT

function : SLEEP() ?

Re: Automating SAS: halt code execution at a specified time

ChrisNZ — Wed, 26 Jun 2013 09:44:41 GMT

If the job is scheduled, you can set the scheduler to kill the job if whatever time condition you choose is met.

Otherwise, both the options you mention are valid.

The batch job has the advantage that you can choose the exact kill time.

Doing it as part of the program means the program has to wait between steps to check, which means:

1) you cannot be certain when a check will be made

2) if a step doesn't complete (infinite loop, processing too slow, bug) the check will never take place.

Re: Automating SAS: halt code execution at a specified time

BillJones — Thu, 04 Jul 2013 06:08:48 GMT

KSharp and Chris: Thanks for the suggestions. I'll kill the job via batch command. This seems to be the most efficient method.

Regards,

Bill