Hi   Checkmaster is a work table contains attached data . I want to execute one by one jobs under JOBNAME when the val = 0 and runstatus=N  and then update teh status as per status variable in the code using update_status macro.  My queries are :   1. The condition check always is false  2. Please advise if my call execute statement to include a SAS script is correct or not.     We are using SAS 9.4 in LINUIX Environment .   Below is the code:   opitons symbolgen mlogic mprint MINOPERATOR ; %macro update_status(status=); proc sql; update exeng.EngineExecution set runstatus="&status" where JobName=compress("&&jobs&cnt_h"); quit; %mend update_status; %global loc ; %let loc=/app/ERM/sasdata/logs;   %macro jobex; %let path=/app/scripts/jobs %let extn=sas; %global cnt_h; %global jobs; proc sql; select count(jobname) into :cnt_h separated by ' ' from CHECK_MASTER ; select jobname into :jobs1-:jobs%left(&cnt_h) from CHECK_MASTER; quit; data _null_; set work.CHECK_MASTER; /*call symputx ("val",val);*/ /*call symputx ("runstatus",runstatus);*/ %do i=1 %to &cnt_h; %if ((val=0) AND (Runstatus = 'F' or RUNSTATUS='N' )) %then %do; call execute('%include "&path./&&jobs&i...&extn"'); /*x "&path/&&jobs&i...&extn";*/ status="P"; %end; %end; run; %mend jobex; %jobex;     Log:   MPRINT(JOBEX): data _null_; MPRINT(JOBEX): set work.CHECK_MASTER; SYMBOLGEN: Macro variable CNT_H resolves to 9 MLOGIC(JOBEX): %DO loop beginning; index variable I; start value is 1; stop value is 9; by value is 1. MLOGIC(JOBEX): %IF condition ((val=0) AND (Runstatus = 'F' or RUNSTATUS='N' )) is FALSE     Thanks, Sandhya S ... View more

Hi,   CHECKMASTER is a work table which contains attached data. I want to execute the SH jobs one by one in a  loop through a table when val = 0 and runstatus = N . Then I want to set the runstatus as 'P' using update_status macro. But the condition is always false . Also, I am not too sure if my call execute statement to include a sas code is correct .   Kindly advise why the condition is always false and if my call execute statement to include a sas code is correct   I am using LINUX Environment . SAS Version is 4.4 .  Below is the code: %macro update_status(status=); proc sql; update exeng.EngineExecution set runstatus="&status" where JobName=compress("&&jobs&cnt_h"); quit; %mend update_status; %macro jobex; %let path=/app/scripts/batch; %let extn=sh; %global cnt_h; %global jobs; proc sql; select count(jobname) into :cnt_h separated by ' ' from CHECK_MASTER ; select jobname into :jobs1-:jobs%left(&cnt_h) from CHECK_MASTER; quit; data _null_; set work.CHECK_MASTER; /*call symputx ("val",val);*/ /*call symputx ("runstatus",runstatus);*/ %do i=1 %to &cnt_h; %if ((val=0) AND (Runstatus = 'F' or RUNSTATUS='N' )) %then %do; call execute('%include "&path./&&jobs&i...&extn"'); /*x "&path/&&jobs&i...&extn";*/ status="P"; %update_status(status); %end;x %end; run; %mend jobex; %jobex;   Log:   MPRINT(JOBEX): data _null_; MPRINT(JOBEX): set work.CHECK_MASTER; SYMBOLGEN: Macro variable CNT_H resolves to 9 MLOGIC(JOBEX): %DO loop beginning; index variable I; start value is 1; stop value is 9; by value is 1. MLOGIC(JOBEX): %IF condition ((val=0) AND (Runstatus = 'F' or RUNSTATUS='N' )) is FALSE   Thanks, Sandhya S ... View more

Hi   I am getting below error when executing below stmnt in a macro . Val is numeric and runstatus is character .   %if (val=0) AND (Runstatus = 'F' or RUNSTATUS='' ) %then      ERROR: A character operand was found in the %EVAL function or %IF condition where a numeric operand is required. The condition was: val=1 and runstatus = "F" or ""   Kindly advise.Thanks ... View more

Hi There is a location where all log files of SAS Jobs gets stored (We have LINUX Env)   Also there will be .err files created wheen the job is failed.  The log files name will be like jobname_timestamp   Eg: Job name is J_LOAD Timestamp -when the job runs   Log file name will be J_LOAD_20171115143219.log Error file name will be : J_LOAD_20171115143219.err So its like everytime a job runs , the log file gets created which will be unique because of timestamp.   I have to run a job based on the log file creation of its dependent job. How to check which is the recent log file of a particular SAS Job (All I have is SAS Job name based on which I have to find recent log file ) I dont want to parse entire logs directory as there will lots of log files created.    Using SAS 9.4   Thanks in advance 🙂        ... View more