How to send SAS email to multiple people

[eagles_dare13]

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?

[RW9 · Accepted solution]

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;

[eagles_dare13]

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?

[Quentin]

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).