Thank you so much tom, i am able to use the code shared but i need to give else also in this condition that should solve my query for triggering an email only when numver exceed and else it should not execute ... View more

Firstly i have data as  sno name marks email fatheremail 1 abc 95 xxx.gmail fxxx.gmail 2 bcd 65 yyy.gmail fyyy.gmail 3 cda 57 zzz.gmail fzzz.gmail 1st step: data snap; set Work.data; do i=1 to 3 by 1 /*mailer code starts*/ file name message email to =('email') cc=(fatheremail) subject= marks CT="Text/HTML"; ods listing close; ods html body = message rs= none style=normal; /*body of email*/ proc sql; title j=left height 11pt clolour black font="" Quit; Proc Tabulate Data=work.snap; var class marks* sum*F = BESTX12. run; footnote; end; run;     This is the program i am using but getting an error as do loop is not completed ... View more

I have assigned a sno and linked a do loop with number, email script is next to that, snapshot format but it is not working ... View more

Please find the attachment of the requirement to give a better solution ... View more

Data is like Stntid name marks email fatheremail 123 abc 78 123.gmail fath1.gmail 234 bcd 98 234.yahoo fath2.yahoo ... View more

Data is as posted above i want to semd the data individually to student 1 and 2 ... View more

Thank you Mr.KURT BREMSER Can you please suggest me in format for data like Mm/dd/yyyy 03/11/2020 03/12/2020 03/13/2020 ... View more

Data is pulled from database and the date format i m getting is in character which is like 27-02-2020 28-02-2020 29-02-2020 But the date is not recognised by sas as per requirement i have to get the data of yesterday with formula of today()-1 so please help me ... View more