Help using Base SAS procedures

Results as a part of Email body- Not as attachment

Reply
New Contributor
Posts: 3

Results as a part of Email body- Not as attachment

[ Edited ]

Hi 

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;
 
Super User
Super User
Posts: 7,942

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

Posted in reply to sreeparna93

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

Super User
Posts: 7,762

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

Posted in reply to sreeparna93

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.

 

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Ask a Question
Discussion stats
  • 2 replies
  • 112 views
  • 0 likes
  • 3 in conversation