topic Re: Display SAS table in Outlook mail in SAS Programming

Display SAS table in Outlook mail

Aashi07 — Tue, 22 Apr 2025 05:50:08 GMT

i need to display a sas table in the body of a mail and send the mail using sas

Re: Display SAS table in Outlook mail

LinusH — Tue, 22 Apr 2025 06:01:22 GMT

https://communities.sas.com/t5/SAS-Communities-Library/How-to-send-email-using-SAS/ta-p/746523

Re: Display SAS table in Outlook mail

Aashi07 — Tue, 22 Apr 2025 07:25:54 GMT

i tried this but not working

Re: Display SAS table in Outlook mail

LinusH — Tue, 22 Apr 2025 10:48:33 GMT

What does not work?
Please attach full log.

Re: Display SAS table in Outlook mail

Kurt_Bremser — Tue, 22 Apr 2025 14:05:24 GMT

NEVER post pictures of code or other code-related text. Copy/paste the text into a window opened with the respective buttons. The button for logs and other non-proportional text is this:

The "little running man" to the right is for SAS code, and provides colorng similar to the SAS Enhanced Editor.

Whenever you have an issue with code, do ALWAYS post the whole (all code and messages) log of the failing step/macro/etc.

Re: Display SAS table in Outlook mail

ChrisHemedinger — Tue, 22 Apr 2025 14:43:15 GMT

It looks like you are referencing a number of macro routines that you have in your org, but I cannot tell what those do...

To embed tables in the body of the email, you use ODS to create a file with the table (and other content), then FILENAME EMAIL to send it with that ODS file as the body. This article has a simple example. My advice is to see if you can get that to work before bringing in the more complex macro constructs you have.