How do I make xls Or Pdf generated from proc report, should appear in body of email?

[Banu]

I know how to attach PDF or XLS file to email as an attachment using UNIX commands in SAS.
I would like to know how to send these reports to email body, so that users can access quickly, instead of extra step to open.

[Cynthia_sas]

Hi:

  Many mail systems only let you send plain text or HTML in the email body. So for a file like PDF or XLS or XLSX, you do not have any choice other than to send the PDF, or Excel file, as an attachment. There have been many previous postings about how to do this. As a starter, look on page 7 of this paper: http://support.sas.com/resources/papers/proceedings11/300-2011.pdf -- the code snippet shows an RTF file being created with ODS prior to the email step, but you would just change the RTF step or either ODS PDF or ODS EXCEL.

Cynthia