topic Results as a part of Email body- Not as attachment in SAS Procedures

Results as a part of Email body- Not as attachment

sreeparna93 — Thu, 27 Apr 2017 14:21:01 GMT

I want to add a dataset in table format in the email body as well as add text to format the email.

right now I am only add the dataset and unable to add texts.

result.html has the dataset output in html format

The code is below:

FILENAME Mailbox EMAIL "&email"
Subject='Test Mail message'
content_type="text/html";

DATA _NULL_;

FILE Mailbox;
infile "/home/sm25967/DQ_2/QVCDE_QC_Report/result.html";
input;
RUN;
filename Mailbox clear;

Re: Results as a part of Email body- Not as attachment

RW9 — Thu, 27 Apr 2017 14:22:48 GMT

There was a similar question earlier today, my response was:

A good way to data into an email is to put it out from a dataset:

filename mailbox email 'someone@world.com'
  subject='Total Sales';
data _null_;
  file mailbox;
  set your_data;
  if _n_=1 then do;
    put "Hello";
    put "This is a the Total Sales";
  end;
  put _all_;
run;
filename mailbox clear;

You can find further examples, such as attaching reports, here:

http://www2.sas.com/proceedings/forum2008/038-2008.pdf

Re: Results as a part of Email body- Not as attachment

Kurt_Bremser — Thu, 27 Apr 2017 14:30:08 GMT

I'd use ODS HTML to create the complete body of the email (including tables and free text).

Then do

data _null_;
file Mailbox;
infile "/home/sm25967/DQ_2/QVCDE_QC_Report/result.html";
input;
put _infile_;
run;

That way your whole mail body is formatted as HTML, and the mail agents will understand that because the mail body starts with a <HTML> tag.