BookmarkSubscribeRSS Feed
dataMart87
Quartz | Level 8

In an email created by SAS (code below), is there an equivalent to the FLYOVER option?  Running on SAS 9.4M4.

 

filename outbox email 
	to=("jon.dow@domain.com")
	type='text/html'
	subject="this is a test";

ods html body=outbox rs=none style=statdoc;
proc report data=sashelp.class split=']' missing nowd
	style(column)=[just=l]
	style(header)=[fontweight=bold just=c cellwidth=1in]
	style(report)=[font_size=2];


	title;
	footnote;

	column 
		name sex age;

	define name / display "Name" style(header)=[cellwidth=1.6in];
	define sex / display 'Sex';
	define age / display 'Age' style(column)=[just=r];

	compute sex;
		if sex='M' then do;
			call define('name', "style", "style=[background=cyan flyover='male']");
		end;
	endcomp;
run;
ods html close;
4 REPLIES 4
Kurt_Bremser
Super User

I just ran your code here and sent the mail to my business account (within the same network/domain).

When opening the mail in Outlook Web Access, the flyover with "male" (and the colouring) worked.

 

Interesting side-notes:

Running your code to create a HTML file, and viewing that via web server and a browser, the title= tags were missing, so no flyover, and also no coloring.

In the "SAS Report" Tab within EG, the coloring worked, but the flyover not.

In the HTML tab in EG, both worked.

dataMart87
Quartz | Level 8

When I open the email in Outlook (thick client installed on my desktop), the color works but not the flyover.  The email in this Outlook client is also HTML.  So, I would think the flyover should work.

Kurt_Bremser
Super User

Displaying the flyover text is a matter of the user agent, in this case the fat Outlook client. You can only try to take a look at the raw HTML text of the mail. If the title= option is in there, then it's simply Outlook not doing what it should when resolving HTML tags.

dataMart87
Quartz | Level 8

Per SAS TS, the Outlook for desktop (thick client) uses the Microsoft Word HTML viewer, which does not recognize this attribute.  Currently, there is no workaround.

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

Mastering the WHERE Clause in PROC SQL

SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 4 replies
  • 1534 views
  • 0 likes
  • 2 in conversation