Re: SMTP building body of e-mail issue

G_I_Jeff · Posted 10-18-2018 09:24 AM

Trying to accomplish one e-mail but get either two separate e-mails or missing data, depending on ODS statement placement:

options emailsys=SMTP;
options emailhost='mail.from.me.host';
filename sendemail mail
 to=("recepient@mail.com")
 from=("sender@mail.com")
 subject="I suck at SAS"
 type="text/html"
 attach=("/required/email/signature/logo/logo.png" inlined='pic');

/* If ODS statement placed here; no data _null_ verbiage in body of email */
ods html3 body sendemail rs=none style=sasweb;

data _null_;
 put '<html><body>';
 put 'All,<br> Below are the requested metrics for'"&date"':'<br>;
 put 'Regards,<br>';
 put '<font size="18" face="mistral">GI Jeff<br>';
 put '<img src=cid:pic>';                     
 put '</body></html>';
run;

/* if ODS statement placed here; two separate e-mails containing data _null_ and proc print */
ods html3 body sendemail rs=none style=sasweb;

proc print data=test_data;
 where date=&date;
 title "Metrics for &date";
run;

ods html close;

Kurt_Bremser · Posted 10-18-2018 09:31 AM

Add a

file print;

in your data _null_ step, so that the put's end up in ods and not in the log.

Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
The macro for direct download as ZIP
How to post code
Please vote for Provide Sequential Search Capability for Hash Objects
How to deal with locked files on UNIX

G_I_Jeff · Posted 10-18-2018 09:38 AM

Kurt,

Thanks, that got me half way. Put by putting file print; in the data _null_ step, it does not render the html then. I see all the tags in the body of the e-mail. And thanks for the tip of the <html> & <body> tags. I assumed that but I'm just fooling around at this point and coded them in.

Jeff

Kurt_Bremser · Posted 10-18-2018 09:49 AM

Another method to put text into ODS output is the ods text statement. I've never fiddled around with manually writing tags to an email, though.

Such things I do when writing output to a file:

%let outfile=/path/destination.html;

ods html file="&outfile" (no_bottom_matter);
ods html close;

filename out "&outfile" mod;

data _null_;
file out;
/* put html tagged text here */
run;

ods html file=out (no_top_matter);

/* further ods output */

ods html close;

You could now write the resulting file to the email without using ods.

data _null_;
infile "&outfile";
file email;
input;
put _infile_;
run;

Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
The macro for direct download as ZIP
How to post code
Please vote for Provide Sequential Search Capability for Hash Objects
How to deal with locked files on UNIX

Kurt_Bremser · Posted 10-18-2018 09:33 AM

And remove the first and last put in the data _null_. That part is handled by ods html on its own.

Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
The macro for direct download as ZIP
How to post code
Please vote for Provide Sequential Search Capability for Hash Objects
How to deal with locked files on UNIX

SMTP building body of e-mail issue