Embed SGPLOT and Proc Report in Email

P5C768 — Mon, 02 Jul 2018 22:50:19 GMT

I am trying to embed a SGPLOT chart as a png a PROC REPORT table as HTMl in the body of the same email, I can get one or the other to work but not both together (code below sends as 2 emails). Any ideas to embed them both in the same email? Do I need to convert the PROC REPORT to a png as well?

%let workdir=%trim(%sysfunc(pathname(work)));
ods _ALL_ close; 
ods listing gpath="&workdir";
ods graphics / reset=index width=16in height=6in outputfmt=PNG imagename='Chart';  

proc sgplot data=Weekly;
	series x=week y=Metric;
run;

filename sendmail email 
	to=("") 
	from=("")
	attach=("&workdir./Chart.png" inlined='sgplot')
	type='text/html' subject="Weekly Summary";

data _null_;
	file sendmail;  
	put '<html>';
	put '<body>';
	put '<img src=cid:sgplot>';
	put '</body>';
	put '</html>';
run; 

ODS LISTING CLOSE;
ODS HTML BODY=sendmail;

proc report data = Weekly center style=seasideprinter;
	column ('Week Ending' week), Metric;
	define week / across ' ';
	define Metric / analysis sum f=comma6. ' ';
run;

ODS HTML CLOSE;
ODS LISTING;

filename sendmail clear;

Re: Embed SGPLOT and Proc Report in Email

Kurt_Bremser — Tue, 03 Jul 2018 06:52:43 GMT

Omit the data _null_ step, but use ods text:

ODS HTML BODY=sendmail;

ods text='<img src=cid:sgplot>';

proc report data = Weekly center style=seasideprinter;
	column ('Week Ending' week), Metric;
	define week / across ' ';
	define Metric / analysis sum f=comma6. ' ';
run;

ODS HTML CLOSE;

topic Re: Embed SGPLOT and Proc Report in Email in SAS Programming

Embed SGPLOT and Proc Report in Email

Re: Embed SGPLOT and Proc Report in Email