Displaying SAS Output as a Table in the Email Body

[hasnasherin]

I know how to send emails using the FILENAME EMAIL statement in SAS. However, I'm looking for guidance on displaying a SAS dataset as a formatted table directly in the email body?

[ChrisHemedinger]

You can format your email using ODS and HTML. See the examples in How to send email using SAS.

Excerpt:

FILENAME OUTPUT EMAIL
	SUBJECT = "blogs.sas.com: &postCount posts, 
                  &commentCount comments"
	FROM = "Chris Hemedinger <[email protected]>"
	TO = (&toList)
	CT ='text/html';

ods tagsets.msoffice2k(id=email)
  file=OUTPUT(title="7-day blog report")
  style=myemail;

proc report nowd data=pastweek;
  title "&postCount blogs.sas.com posts";
  title2 color=red "NOTE: " color=blue "View counts are sourced from Google Analytics";
  columns post_date post_author blog_ID post_link ga_views comment_count ;
  define post_date / group order=data 'Date posted' style(column)=[just=l];
  define post_author / order 'Author' style(column)=[just=l];
...
run;
ods tagsets.msoffice2k(id=email) close;