How to insert table in Mail?

arunrami — Thu, 01 Nov 2018 10:47:34 GMT

Hello , I want to insert a table in mail which is automated by SAS, I created a table by using proc report but when output goes to mail table lines has been vanished? I dont know what am missing. could any one help?

Code:

data Temp1;
	set Temp;
	start_time=substr(start_time,1,8);
	start_time=input(start_time,ddmmyy8.);
	call symput('Newdate',start_time);
run;

Data Mail;
set Temp1;
/*if &Newdate>&prevtime;Compare with the previous job start time, comment it while running for very first time*/
run;
%put &Newdate &prevtime;


%let send_email = 0;

* WHEN 0 EMAIL WILL NOT BE SENT. WHEN 1 EMAIL WILL BE SENT;
data New;
	set Mail nobs=No_of_mail;
	count=No_of_mail;

	if count > 0 then
		do;
			call symput('send_email',1);
			stop;

			* LEAVE THE DATASTEP AS SOON AS WE DECIDE AN EMAIL SHOULD BE SENT;
		end;
run;

%macro send_email;
	%if &send_email eq 1 %then
		%do;
			FILENAME MailBox EMAIL

				TO=(
				'Myself <zzz.com>'
				) 
				CC=(
				'Myself <zzz.com>'
				)
				/*BCC=
				'info@synchrona.nl'*/
			FROM='Arun <zzz.com>'
			type='text/html'
			SUBJECT='DAILY_STATUS';

			/*REPLYTO=
				'Anonymous
				<villavinkeveen@hotmail.com>'*/

			/*ATTACH=
				'E:\My Documents\My Pictures\Picture WILLSU.jpg'*/
			ODS html body=Mailbox style = noline;
			ods html text = "DAILY STATUS";
			ods html text = "";

			PROC REPORT DATA=work.MAIL nowd HEADLINE HEADSKIP out=X.Existing
				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 text = "Have a Great Day.";
			ods _all_ close;
			run;

		%end;
%mend;

%send_email;

/**/
ods listing ;
/**/
	%global prevtime;
/**/

data X.Final1;
set X.existing;
call symput('prevtime',start_time);
run;
	t:

Result:

Re: How to insert table in Mail?

ChrisNZ — Fri, 02 Nov 2018 02:29:15 GMT

Searching the communities threads unearths this.

Use TAGSETS.MSOFFICE2K. Outlook is not HTML-friendly. Is not friendly period actually. 🙂

topic Re: How to insert table in Mail? in SAS Programming

How to insert table in Mail?

Re: How to insert table in Mail?