I'm not sure how to explain this. I'm currently running a script to see which items have updated in a report. There is a column named "updated" which is set to 'Yes' if it has updated and 'No' if its not. i am required to send an email out every day with a full report which i attach in an email using SAS. the script is kicked off every 30 minutes. What i'm trying to do is add a check to say if there are no records for updated = 'No' then no email should send out. the problem is i still need to send out an initial email once a day.    this is what i'm using for my check:   i would like to schedule    %macro check();                           proc sql noprint;                       select count(*) into: chk               from mydata;                            quit;                                     %IF &CHK > 0 %THEN %DO;                 proc export data=work.mydata                 outfile='D:\folder\test\mydata.csv'      dbms = csv replace;                     delimiter=';' ;                    run;                                    filename mymail email "me.me@email.com" subject="My Mail to You"                attach='D:\folder\test\mydata.csv';          data _null_;                            file mymail;                       run;                                      %END;                                     %mend check;                              %check();    ... View more