topic Re: How to send SAS email to multiple people in ODS and Base Reporting

How to send SAS email to multiple people

eagles_dare13 — Tue, 06 May 2014 15:06:33 GMT

I am using below code to send an email:

data _null_;

file sendit email

from="Support@yahoo.com"

to=("xxx@yahoo.com" )

cc=("yyy@yahoo.com")

subject="Report 123"

importance="High"

attach="/home/report.zip";

put "Regards,";
put "Support Team";
put;

My problem is that the To: field needs to read email addresses from a list (dataset). Now I can loop through a dataset ,pick out each email address and send a separate email to each person.

But what i want is to send a single email with all those names in the To field.

How can I do this?

Re: How to send SAS email to multiple people

RW9 — Tue, 06 May 2014 15:20:25 GMT

Hi,

Two steps. Create your list of emails, then set that in a data _null_ and call execute using that loop:

proc sql;
create table LOOP as
select distinct EMAIL
from WORK.HAVE;
quit;

data _null_;
set loop end=last;
if _n_=1 then do;
    call execute('data _null_;
                    file sendit email
                    from="Support@yahoo.com" to=("'||strip(email)||'"');
end;
else do;
    call execute(',"'||strip(email)||'"');
end;
if last then do;
    call execute(') cc=("yyy@yahoo.com") subject="Report 123"...

end;
run;

Re: How to send SAS email to multiple people

eagles_dare13 — Tue, 06 May 2014 19:52:54 GMT

Thanks. Can you tell me what is the purpose of this symbol?

In sql, we use this to concatenate strings, what is the purpose in this context?

Re: How to send SAS email to multiple people

Quentin — Tue, 06 May 2014 20:11:39 GMT

It's the same concatenation operator as you would expect.

For example, you have a string literal 'data _null_; file sendit... ', concatenated to the value of the EMAIL dataset variable, concatenated to another string literal "'" (a single quote mark).