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: Don Henderson presenting on using hash functions (not hash tables!) to segment data on June 12. Register now at the Boston Area SAS Users Group event page: https://www.basug.org/events.

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

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
  • 6902 views
  • 6 likes
  • 3 in conversation