Terminating an automated script based on a condition

KJazem — Tue, 27 Dec 2022 19:19:06 GMT

Hi.

I have a SAS script that is scheduled to run everyday. I want to terminate the script if a certain condition is satisfied. For example, if it's Sunday, I want to kill the execution of the script at a certain point, and nothing after should execute.

%let _weekday = %sysfunc(weekday(today()));

data _null_;
    if &_weekday. = 1 then do;
        call execute('endsas;');
    end;
    stop;
run;

Would this work? Would this affect anything in the next day schedule run or will that run again fine and check the condition again?

Do you recommend another, more graceful way?

Thank you.

Re: Terminating an automated script based on a condition

Kurt_Bremser — Tue, 27 Dec 2022 21:02:33 GMT

Instead of using CALL EXECUTE to push ENDSAS into the execution queue, you can use the ABORT data step statement. It also allows setting the return code of the SAS program.

topic Terminating an automated script based on a condition in SAS Programming

Terminating an automated script based on a condition

Re: Terminating an automated script based on a condition