topic Re: Write fields of a table to the body of an Email in SAS Enterprise Guide

Write fields of a table to the body of an Email

Rebecca_K — Wed, 16 Oct 2024 18:45:43 GMT

Hello! I'd like to write the contents of a table to an email, any ideas how to go about this?

Here's what I have so far. In the section that reads "PUT RESULTS HERE" I'd like to write:

Member: 12345678901 Amount: 10
Member: 1234567892 Amount: 6
Member: 1234567893 Amount: 5

etc.

DATA WANT;
INPUT MEMBER : $20. AMOUNT : 8. ;
CARDS;
1234567891 10 
1234567892 6
1234567893 5
1122334455 4
;
run;

filename outmail email 
	to=&toEmail. 
	from=&fromEmail. 

	subject="Results are in";

	data _null_;
	file outmail;
	put Here are the results:  ;
/* PUT RESULTS HERE */

run;

Thanks in advance!

Re: Write fields of a table to the body of an Email

SASJedi — Thu, 17 Oct 2024 13:24:57 GMT

Have a look at Tips and Tricks for Sending Emails Using SAS: Q&A, Slides, and On-Demand Webinar - there are several great options and examples provided there.

Re: Write fields of a table to the body of an Email

Rebecca_K — Thu, 17 Oct 2024 14:32:54 GMT

Hi, thanks for the reply. I skimmed through the hour long webinar you suggested, and see that you can write a proc report to an email. I tried to keep it basic to start. Email was sent, but the data from the table did not write. Am I missing something? Here is the code:

filename outmail email 
	to=&toEmail. 
	from=&fromEmail. 

	subject="Results are in";

	data _null_;
	file outmail;
	put "Here are the results:  ";

/* NEW CODE HERE: */
   proc Report data=Want;
   run;


run;

Re: Write fields of a table to the body of an Email

SASJedi — Thu, 17 Oct 2024 20:13:03 GMT

Yes - see pages 10 and 11 of the handout (PDF). The idea is to use ODS to capture the PROC output and write it to your email file:

filename mail email ... ;
ods html(id=email) file=mail style=daisy;
/* PROC output here */
ods html(id=email) close;

Re: Write fields of a table to the body of an Email

Rebecca_K — Thu, 17 Oct 2024 20:22:56 GMT

Thanks for the tip! Question: I am still fairly new, when you said there's a PDF file, how do i find that? I went to the Webinar you linked, but I'm not sure where i can find the file. Much appreciate your help!

Re: Write fields of a table to the body of an Email

Tom — Thu, 17 Oct 2024 22:33:37 GMT

Are you sending one email with all 6 of those data points?

filename out email ....... ;
data _null_;
  file out;
  set want ;
  put member= amount=;
run;

Or are you sending separate emails to each of the members? In which case where are you going to find the email address of where to send it? If you have the address in the dataset then just use EMAIL DIRECTIVES in the data step.

Let's adapt their example to your example. So try something like this:

data have;
  input MEMBER :$20. AMOUNT EMAIL $40. ;
CARDS;
1234567891 10 team1@x.com
1234567892 6  team2@y.com
1234567893 5  team3@z.com
1122334455 4  team3@z.com
;

filename reports email 'Member amount';

data _null_;
  file reports;
  set have ;
  by email ;
  if first.email then do; 
* Set email attributes and write header of report ;
    put '!EM_NEWMSG!';                    
    put '!EM_TO!' email;
    put '!EM_SUBJECT! Report for ' email;  
    put 'Here is the latest report for ' email '.';
  end;
* send the data message ;
    put member= amount= ;

  if last.email then do;
* send the message ;
    put '!EM_SEND!';                      
  end;
run;

Re: Write fields of a table to the body of an Email

Rebecca_K — Fri, 18 Oct 2024 12:24:52 GMT

Thanks for the feedback Tom! The first example is what I'm going for, with all results in a single email. I'm trying your suggestion, but can't figure out how to write a line of text, then dump the table outputs. It wants to write the line of text X number of times, to go with the table results. thoughts? Here's my code, and below it is the result (with "Here are your results" repeated). Thanks again!!

%macro runemail;
	filename outmail email 
		to=&toEmail. 
		from=&fromEmail. ;

	data _null_;
	file outmail;
	put "Here are your results:";
	put;

     set want;
  	 put Member= Amount=;

	run;

%mend runemail;

Here are your results:

MEMBER=1234567891 AMOUNT=10
Here are your results:

MEMBER=1234567892 AMOUNT=6
Here are your results:

MEMBER=1234567893 AMOUNT=5
Here are your results:

MEMBER=1122334455 AMOUNT=4
Here are your results:

Re: Write fields of a table to the body of an Email

Tom — Fri, 18 Oct 2024 12:46:28 GMT

Only write the static text the FIRST time the data step executes.

if _n_=1 then put ....

Re: Write fields of a table to the body of an Email

Rebecca_K — Fri, 18 Oct 2024 12:51:45 GMT

Perfect! Thanks for your help!