BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
eagles_dare13
Obsidian | Level 7

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?

1 ACCEPTED SOLUTION

Accepted Solutions
RW9
Diamond | Level 26 RW9
Diamond | Level 26

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;


View solution in original post

3 REPLIES 3
RW9
Diamond | Level 26 RW9
Diamond | Level 26

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
Obsidian | Level 7

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
Super User

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

BASUG is hosting free webinars Next up: Jane Eslinger presenting PROC REPORT and the ODS EXCEL destination on Mar 27 at noon ET. Register now at the Boston Area SAS Users Group event page: https://www.basug.org/events.

sas-innovate-2024.png

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.

 

Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 6766 views
  • 6 likes
  • 3 in conversation