BookmarkSubscribeRSS Feed
garretta
Calcite | Level 5
Within SAS EG, is there a way to send query results, reports, etc. in the body of an email as opposed to as an attachment?

I need to generate an automated daily email based on a predefined email body template with roughly 10 metrics. The value of these metrics will vary each day, and should appear in the email message itself rather than in an attached report.

Ex:
Report Date: MM/DD/YYYY
Metric Value
X 100
Y 90
etc.

Thanks
2 REPLIES 2
ChrisHemedinger
Community Manager
For this, you will have to use SAS statements to achieve what you want. You will need to use the FILENAME EMAIL method. You should be able to run such programs within SAS Enterprise Guide.

Here's a helpful conference paper from Chuck Hunley:

http://support.sas.com/resources/papers/proceedings10/060-2010.pdf

Chris
SAS For Dummies 3rd Edition! Check out the new edition, covering SAS 9.4, SAS Viya, and all of the modern ways to use SAS!
garretta
Calcite | Level 5
Thanks!

The paper was quite useful. However, I'm still having one issue.

I'd like to embed an image from my hard drive into the body of the email. I can attach the image as an attachment, but within the email body I'm only seeing the dreaded red x. Outlook settings are not the issue.

Thoughts?

put '';

Thanks

hackathon24-white-horiz.png

The 2025 SAS Hackathon Kicks Off on June 11!

Watch the live Hackathon Kickoff to get all the essential information about the SAS Hackathon—including how to join, how to participate, and expert tips for success.

YouTube LinkedIn

Creating Custom Steps in SAS Studio

Check out this tutorial series to learn how to build your own steps in SAS Studio.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 1506 views
  • 0 likes
  • 2 in conversation