topic Re: Delay running code using a dataset modate/created date in SAS Programming

Delay running code using a dataset modate/created date

Paul_Collier — Tue, 11 Feb 2014 10:22:44 GMT

I would like to delay the code I am running using the date modified/created of a key dataset. So, only run once xx dataset is updated for the day.

I have been trying to find if this is possible but cannot see anything obvious.

Does anyone have any tips/suggestions/solutions?

Re: Delay running code using a dataset modate/created date

LinusH — Tue, 11 Feb 2014 11:44:42 GMT

Could you please exemplify? Are there rules on what jobs should run how often etc? What do you mean by delay?

Depending on the complexity of your system, it sounds like you could benefit from using scheduling software.

Re: Delay running code using a dataset modate/created date

Paul_Collier — Tue, 11 Feb 2014 11:53:03 GMT

Thanks for your reply.

Specifically. I run a piece of code on a dataset. This occurs daily but the source dataset is updated at a variable point in the day. It can be 9am or as late as 1pm.

The source data is updated as part of a batch process. My code cannot be included in the batch process so I am looking to delay the running of it until the source data has had the daily updated.

Does this help to clarify the requirement?

Re: Delay running code using a dataset modate/created date

LinusH — Tue, 11 Feb 2014 14:05:43 GMT

If you are not going all in for a scheduler, you could create a code snippet that checks the SAS table for update time (there is a SAS file function available for this), then checks a log table for completed executions. Then terminate the session if not the execution criteria is fulfilled (or do %include or similar call if executions criteria is fulfilled).

Then o course you need to add to the log after a successful execution is done.

Re: Delay running code using a dataset modate/created date

Paul_Collier — Mon, 17 Feb 2014 16:25:17 GMT

Thanks for your reply. That broadly makes sense to me - do you have any pointers as I am still a relative novice sas coder.

thanks very much