Hi @Rajeshganta,   To find out more about the special requirements / limitations of using %if in open code then you can read this SAS blog post.     Thanks & kind regards, Amir. ... View more

Why do you not want to use a task scheduler? If you are running SAS locally on your PC then the Windows Task Scheduler is a good choice. If you are using SAS on a remote server then SAS Management Console provides a point-and-click interface to schedule SAS jobs.  ... View more

Along with the other excellent replies, let me suggest that you NEVER name a macro variable beginning with "sys". This prefix is used for SAS system variables, and I guarantee you will CONFUSE THE HECK out of some poor devil who needs to support your program!   Tom ... View more

Hi,   There are several problems with your code.  Instead of writing the whole thing at once, I would develop it in steps, e.g.: Code to send one email with "hello". Code to generate the HTML report you want (PROC TABULATE, or whatever). Code to send one email with a custom HTML report in the body. Code to read a dataset and send multiple emails I would suggest looking at user group papers for examples, this one looked handy: https://support.sas.com/resources/papers/proceedings/pdfs/sgf2008/038-2008.pdf     ... View more

Maxim 1: Read the Documentation. https://documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.4&docsetId=leforinforref&docsetTarget=n0verk17pchh4vn1akrrv0b5w3r0.htm&locale=en  Look under Date and Time for the fitting informat. ... View more

"why you go to such a complicated logic rather"-  my dumb brain fails a lot of time. 😞     @PaigeMiller wrote: May I ask why you go to such a complicated logic rather than the much simpler (and easier to understand) logic I originally stated; or the SQL solution above from @PeterClemmensen?   data want; set have; z=rand('uniform'); run; proc sort data=want; by z; run;   ... View more