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).
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.