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).
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.