topic Re: My plots want show in email in New SAS User

My plots want show in email

mmea — Sun, 24 Jan 2021 17:46:22 GMT

Hi I have this code for an email which includes two sgplots and a proc report table:

ods html close;
ods listing;  

filename sendmail email bcc=("test@ki")  FROM=("test@ki") 
	subject="test &todaysDate." 
	CT="text/html"
	attach=("\\test_&todaysDate..pdf" ct ='pdf')
	attach=("\\test_&todaysDate..pdf" ct ='pdf');

ods html body=sendmail rs=none style=deliveries;

ods noproctitle;
ods noptitle;
title; 


ods html text = '<img src="Figur1_&todaysDate..png""></img>';

proc report data=metode_count missing style(column)= [background = white fontsize=2 font_weight = bold] style(header) = {background = white frame=void} ;
	    columns new1 metode,COUNT  ;
	    define new1 /'' group  style(column)= [background = white fontsize=2 font_weight = bold] style(header) = {background = white frame=void};
        define metode/'' across style(column)= [background = white fontsize=2] style(header) = {background = white frame=void} ;
		define count/'' analysis sum style(column)= [background = white fontsize=2] style(header) = {background = white frame=void} ;;
	run;

ods html text = '<img src="Figur2_&todaysDate..png""></img>';

ods html close;
ods listing;

But the images wont appear in the email,what am i doing worong here

Re: My plots want show in email

Kurt_Bremser — Sun, 24 Jan 2021 18:19:55 GMT

You only have the image links in the mail body, but the images themselves are nowhere.

If you want the images to be visible in the mail, use the INLINED option within the ATTACH= option of the FILENAME EMAIL statement.

Re: My plots want show in email

mmea — Sun, 24 Jan 2021 18:41:52 GMT

ods html close;
ods listing;  

filename sendmail email bcc=("test@ki")  FROM=("test@ki") 
	subject="test &todaysDate." 
	CT="text/html"
	attach=("\\test_&todaysDate..pdf" ct ='pdf')
	attach=("\\test_&todaysDate..pdf" ct ='pdf');
attach=("\\Figure1_&todaysDate..png" ct ='png')
	attach=("\\Figure2_&todaysDate..png" ct ='png');

ods html body=sendmail rs=none style=deliveries;

ods noproctitle;
ods noptitle;
title; 


ods html text = '<img src="Figur1_&todaysDate..png""></img>';

proc report data=metode_count missing style(column)= [background = white fontsize=2 font_weight = bold] style(header) = {background = white frame=void} ;
	    columns new1 metode,COUNT  ;
	    define new1 /'' group  style(column)= [background = white fontsize=2 font_weight = bold] style(header) = {background = white frame=void};
        define metode/'' across style(column)= [background = white fontsize=2] style(header) = {background = white frame=void} ;
		define count/'' analysis sum style(column)= [background = white fontsize=2] style(header) = {background = white frame=void} ;;
	run;

ods html text = '<img src="Figur2_&todaysDate..png""></img>';

ods html close;
ods listing;

Re: My plots want show in email

Kurt_Bremser — Sun, 24 Jan 2021 18:30:51 GMT

A PDF file is NOT of type PNG.

And you did NOT use the INLINED option. Please read the documentation I linked to (see Example 6).

Re: My plots want show in email

mmea — Sun, 24 Jan 2021 18:42:57 GMT

My bad.. it was i typo, in my code.

Its still dosent work after I run the corrected code.

I will try with the inlined

Re: My plots want show in email

mmea — Mon, 25 Jan 2021 12:32:40 GMT

i tried this:

I worked for miy PNG but not he PDF - how can I show the PDF in the body of my email:


options emailsys=smtp;

filename myemail email 
to="test@sdfi.dk" 
from="dsf@df.dk" 
attach=("F:Figur2_&todaysDate..png" INLINED="logo1")
attach=("F:test.pdf" INLINED="logo2")


subject="D."
content_type="text/html";
 


data _null_;
file myemail;
   put '<IMG src="cid:logo1" >';

  put '<IMG src="cid:logo2">';
 
  
 run;

Re: My plots want show in email

Kurt_Bremser — Thu, 28 Jan 2021 09:51:55 GMT

AFAIK, you can't make PDFs visible like a picture. I suggest you use ODS HTML to write your report to the email file reference to make it show in the mail body.