topic Re: Email to be triggered when every 100 iterations are done in SAS Enterprise Guide

Email to be triggered when every 100 iterations are done

Thanu — Fri, 28 Jul 2017 07:58:13 GMT

Hi Everyone,

It would be great If somene helps me out in this.

When a macro is running, I would like an email to be sent to me after each 100 iterations have completed.
So for the example below I would receive 10 emails…one for each time it completes another 100. It has to be dynamic so that, it emails after each 100 iterations regardless of how many have run till then.

I think can we use the mod function? If so , what is the logic. How can I insert it into the below macro.

%macro macrhlp();
%do i=1 %to 1000;

/*when 100 have run then do following*/
filename mymail email "myemail@email.com" subject="100 have run";
data _null_;file mymail;put '100 have run';run;
/*when 200 have run then do following*/
filename mymail email "myemail@email.com" subject="200 have run";
data _null_;file mymail;put '200 have run';run;

%end;
%mend;

% macrhlp;

Thanks,

Thanu.

Re: Email to be triggered when every 100 iterations are done

Kurt_Bremser — Fri, 28 Jul 2017 08:19:40 GMT

%macro macrhlp();
%do i=1 %to 1000;

  %if %sysfunc(mod(&i,100)) = 0 %then %do;
    filename mymail email "myemail@email.com" subject="&i have run";
    data _null_;file mymail;put "&i have run";run;
  %end;
 

%end;
%mend;

Re: Email to be triggered when every 100 iterations are done

Thanu — Fri, 28 Jul 2017 08:15:52 GMT

Hello, thankyou for this solution. Could you please edit your answer : %sysfunc instead of syfunc.
🙂

TIA
Thanu

Re: Email to be triggered when every 100 iterations are done

Kurt_Bremser — Fri, 28 Jul 2017 08:20:49 GMT

@Thanu wrote:
Could you please edit your answer : %sysfunc instead of syfunc.

Done.