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;
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:
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.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: