HI James, My apologies for the late reply. Out IT just upgraded our SASCI form version 6.5 to v6.6 this week. I had the opportunity to test out your code once again and it does work. Thanks so much for your patience and understanding. I can now share this knowledge with the rest of my colleagues. 🙂 ... View more

Hi James,   much appreciated for all your time.  I used the same code as you, however, when I execute my process node, I still receive the error msg that weekday(today()) is not equal to 6 (Friday)   My SAS CI version is 6.5 hotfix 01   ************** Below is the process node log details   102       +%let DAYOFTHEWEEK = %sysfunc(weekday(%sysfunc(Today()))); 103       +%let THERIGHTDAYOFTHEWEEK=6; 104       +/* debug */ 105       +%put &=DAYOFTHEWEEK; DAYOFTHEWEEK=6 106       +%put &=THERIGHTDAYOFTHEWEEK; THERIGHTDAYOFTHEWEEK=6 107       +%if &DAYOFTHEWEEK ne &THERIGHTDAYOFTHEWEEK  %then %do ; ERROR: The %IF statement is not valid in open code. 108       +%let MAMsg=ERROR: Today is not the right day of the week; 109       +%let MAError = 20000; 110       +%let SYSCC= 20000 ; 111       +%mastatus(&_stpwork.status.txt) ; Return Status in process 8557:   ... View more

Hi James,   When I execute my process node, the same error msg pops up and when I check the log details I see the following info Is there a particular syntax I need to follow if an %IF statement is used ?  Thanks.   /******* PROCESS NODE LOG ******/ 102       +%let DAYOFTHEWEEK = %sysfunc(weekday(%sysfunc(Today()))); 103       +%let THERIGHTDAYOFTHEWEEK =4; 104       +/* debug 105       +*%put &=DAYOFTHEWEEK; 106       +*%put &=THERIGHTDAYOFTHEWEEK; 107       +*/ 108       +%if &DAYOFTHEWEEK ne &THERIGHTDAYOFTHEWEEK  %then %do ; ERROR: The %IF statement is not valid in open code. 109       +%let MAMsg=ERROR: Today is not the right day of the week; 110       +%let MAError = 20000; 111       +%let SYSCC= 20000 ; 112       +%mastatus(&_stpwork.status.txt) ; Return Status in process 8557: SYSCC=20000 MAError=20000 MAMsg=ERROR: Today is not the right day of the week     /************** PROCESS NODE CODE ***************/ %let DAYOFTHEWEEK = %sysfunc(weekday(%sysfunc(Today()))); %let THERIGHTDAYOFTHEWEEK =4; /* debug *%put &=DAYOFTHEWEEK; *%put &=THERIGHTDAYOFTHEWEEK; */ %if &DAYOFTHEWEEK ne &THERIGHTDAYOFTHEWEEK  %then %do ;       %let MAMsg=ERROR: Today is not the right day of the week;            %let MAError = 20000;       %let SYSCC= 20000 ;       %mastatus(&_stpwork.status.txt) ;       %return ;     %end ;   data &outTable; set &inTable; run;     /*--------------------------------------------------------------------------- |  count the number of subjects in the output +--------------------------------------------------------------------------*/ %macount(&outTable); ... View more

Thanks James... much appreciated.   I created a simple test diagram to incorporate the process node code and the result was that the errorr msg appear no matter which value I assign to the variable THERIGHTDAYOFTHEWEEK.   Thanks for all your guidance. ****************** %let DAYOFTHEWEEK = weekday(Today()); %let THERIGHTDAYOFTHEWEEK = 2; %if %NRQUOTE(&DAYOFTHEWEEK) ne %NRQUOTE(&THERIGHTDAYOFTHEWEEK)  %then %do ;       %let MAMsg=ERROR: Today is not the right day of the week;      %let MAError = 20000;       %let SYSCC= 20000 ;       %mastatus(&_stpwork.status.txt) ;       %return ;     %end ;   data &outTable; set &inTable; run; ... View more

Would you by chance have sample code that I could use in my process node to force the campaign process to stop and EXIT ?  thank you. ... View more

Thanks JC.   I was thinking maybe SAS MA would support some sort of code that I could write in a process node EXIT out of the campaign if a condition is not me and not continue on with the logic path.   The reason behind this ask was that campaign that was scheduled to execute on a Monday every week also executed on a Tuesday.  I checked with our IT department and they confirmed no changes were made to the scheduler. In the Execution page of SAS MA, the history tab indicated the campaign was executed by the scheduler and it was not manual.   very strange indeed..., ... View more

Thanks James...much appreciated for the quick turn around. the code works and the explanation was clear and concise. ... View more

Hi Pcapazzi,   I applied your suggestion and it worked even when both DIAGRAM A & DIAGRAM B are within the same campaign diagram.   Much Appreciated 🙂 ... View more

Thanks pcapazzi,   what if both Diagrams A & B are within the same campaign.  How would I then go about to excluding records from DIAGRAM A that exist in DIAGRAM B   Thanks, Keith ... View more