I have a scheduled job flow that runs once a week and calls 50 individual reports. The program looks like this:
options NoSyntaxCheck;
%include 'N:\Organization\Work\Prog1.sas';
%include 'N:\Organization\Work\Prog2.sas';
....
%include 'N:\Organization\Work\Prog50.sas';
I would like some help thinking through the pro's and con's of having one deployed job, that is essentially a driver program versus say 50 individual deployed jobs. One concern I have is macro variables not getting cleared out and affecting subsequent programs. I do have some code in each program that looks like this:
%macro delvars;
data vars;
set sashelp.vmacro;
run;
data _null_;
set vars;
temp=lag(name);
if scope='GLOBAL' and substr(name,1,3) ne 'SYS' and temp ne name then
call execute('%symdel '||trim(left(name))||';');
run;
%mend;
%delvars
The NoSyntaxCheck option was necessary to keep the programming running despite one program having an error. I ran into the situation where the client would post an input file with the incorrect name and it would stop the entire process.
Any input here is appreciated, thank you.