topic Re: Iterative mail in SAS Programming

Iterative mail

Rajeshganta — Tue, 21 Apr 2020 18:23:24 GMT

I have a data with their performances with different students i want to send mail to each one individually to thier email ids and to their parents

Re: Iterative mail

Quentin — Tue, 21 Apr 2020 18:33:14 GMT

This is definitely possible with SAS. Please post the code you have tried (along with sample data) and describe what is going wrong. If you're not sure where to start, I would try searching user group papers over at lexjansen.com; there will be plenty of papers that present ways to send email from SAS.

Re: Iterative mail

Rajeshganta — Tue, 21 Apr 2020 19:02:11 GMT

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

Re: Iterative mail

Quentin — Tue, 21 Apr 2020 19:06:56 GMT

Sorry, I don't see data or code in your message. I only see one sentence.

Re: Iterative mail

Rajeshganta — Tue, 21 Apr 2020 19:19:54 GMT

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

Re: Iterative mail

Rajeshganta — Wed, 22 Apr 2020 07:44:19 GMT

Please find the attachment of the requirement to give a better solution

Re: Iterative mail

Quentin — Wed, 22 Apr 2020 11:40:59 GMT

Please post the code you have tried and describe what is going wrong. FYI, many people won't read attachments, due to their ability to spread malware.

Re: Iterative mail

Rajeshganta — Wed, 22 Apr 2020 13:03:09 GMT

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

Re: Iterative mail

Quentin — Wed, 22 Apr 2020 14:27:35 GMT

Sorry, if you're unable to share your code, it's too hard to help figure out what is going wrong.

For tips on how to write a clear question that makes it easier for others to help you, please see these articles:

https://communities.sas.com/t5/SAS-Support-Communities/How-to-ask-a-good-question-and-receive-a-fast-reply/ta-p/417192

https://communities.sas.com/t5/Getting-Started/How-to-get-fast-helpful-answers/ta-p/226133

Re: Iterative mail

Rajeshganta — Wed, 22 Apr 2020 15:49:05 GMT

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

Re: Iterative mail

Quentin — Wed, 22 Apr 2020 16:54:43 GMT

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