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?
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;
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;
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?
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).
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.