topic Re: Combine html reports into one email in SAS Programming

Combine html reports into one email

Citrine10 — Thu, 31 Mar 2022 10:16:24 GMT

I am trying to combine various HTML reports into one email with different headings, one saying 'update 1' then the table, then 'update 2' then the table however they currently arriving in my inbox as seperate emails. See code below

FILENAME MailBox EMAIL
TO=(jackie@gmail.com)
FROM='horat@gmail.com'
type='text/html'
SUBJECT='Update to tables';

ODS html body=Mailbox style = noline;
ods html text = "Update1";
ods html text = "";
ods listing close;
PROC REPORT DATA=WORK.updates nowd HEADLINE HEADSKIP
style (report) = {background = white
font_face = "Verdana" font_size = 7pt just=left bordercolor=grey rules=All frame=box}
style (column) = {background = white CELLHEIGHT = 2.5%
font_face = "Verdana" font_size = 7pt just=left }
style (header) = {foreground = cx5e2750 font_face="Verdana"
font_size = 8pt just=left
};
columns _All_;
run;
ods html close;

PROC REPORT DATA=WORK.updates2 nowd HEADLINE HEADSKIP
style (report) = {background = white
font_face = "Verdana" font_size = 7pt just=left bordercolor=grey rules=All frame=box}
style (column) = {background = white CELLHEIGHT = 2.5%
font_face = "Verdana" font_size = 7pt just=left }
style (header) = {foreground = cx5e2750 font_face="Verdana"
font_size = 8pt just=left
};
columns _All_;
run;

Re: Combine html reports into one email

Kurt_Bremser — Thu, 31 Mar 2022 10:31:57 GMT

Move the

ods html close;

statement after the final report. Closing the destination causes the mail to be sent.

Re: Combine html reports into one email

Citrine10 — Thu, 31 Mar 2022 11:45:28 GMT

thank you however still only getting the one table and not the second table

Re: Combine html reports into one email

Cynthia_sas — Thu, 31 Mar 2022 12:09:26 GMT

Hi:
Since many mail systems prohibit sending or receiving HTML formatted email, I would recommend making a PDF file for your two reports -- a single PDF can contain multiple PROC REPORT output and you can insert explanatory text into the PDF file between the reports. Then you can send the PDF file as an attachment. This may be a better approach in the long run because it will simplify the text in the body of the email and push the report formatting into the PDF file.
That's my .02 on your email approach,
Cynthia

Re: Combine html reports into one email

Citrine10 — Thu, 31 Mar 2022 12:17:55 GMT

hi, thank you however we want the table to be to the eye when opening the mail and not have it in a PDF doc

Re: Combine html reports into one email

Kurt_Bremser — Thu, 31 Mar 2022 14:26:10 GMT

Post your complete log, from the ODS HTML statement to the ODS HTML CLOSE statement, including all messages coming after the ODS HTML CLOSE.

Re: Combine html reports into one email

Kurt_Bremser — Thu, 31 Mar 2022 14:29:44 GMT

This simple example code results in a single mail with two reports:

filename mm
  email
  to="redacted@domain.com"
  subject="SAS mail"
  type="text/html"
;

ods html file=mm;

proc report data=sashelp.class;
column sex name age;
define sex / group;
define name / display;
define age / mean;
rbreak after / summarize;
run;

proc report data=sashelp.class;
column sex weight;
define sex / group;
define weight / mean;
run;

ods html close;