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.
%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;
%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;
@Thanu wrote:
Could you please edit your answer : %sysfunc instead of syfunc.
Done.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.