topic Re: Sending emails from SAS with embedded table from dataset in ODS and Base Reporting

Sending emails from SAS with embedded table from dataset

DanielDor — Mon, 19 Sep 2016 12:33:27 GMT

Greetings,

1. I would like to send email using SAS, and would like to include a table from SAS embedded inside the email itself (not with attached file).

2. What would be the best way to address this issue? Should I use ODS for this or some other process?

Thanks!

Re: Sending emails from SAS with embedded table from dataset

mstacey_foresters_com — Mon, 19 Sep 2016 15:20:23 GMT

This will Produce a table inside the email.

options emailsys=smtp;

options emailauthprotocol=none;

options emailhost="xx.xx.xx";

options emailport=25;

options emailpw = "xxxxxx";

filename temp email

to = ( "xxxxx@xxxx.com" )

cc = ("xxxxx@xxxx.com" )

subject="Email With Table"

type="text/html"

from = "xxxxx@xxxx.com"

reply = "xxxxx@xxxx.com" ;

ODS html body=temp style = noline;

ods html text = "Good Morning,";

ods html text = "";

PROC REPORT DATA=X nowd HEADLINE HEADSKIP

style (report) = {background = white

font_face = "Verdana" font_size = 7pt just=left }

style (column) = {background = white CELLHEIGHT = 2.5%

font_face = "Verdana" font_size = 7pt just=left}

style (header) = {foreground = cx5e2750 font_face="Verdana"

font_size = 8pt just=left

background = white} ;

columns

DATE

TIME

DEFINE DATE / 'Date';

define TIME / 'Time';

define FN / "File Name";

define C / "Run Number";

run;

ods html text = "Have a Great Day.";

ods _all_ close;

Cheers.

Re: Sending emails from SAS with embedded table from dataset

DanielDor — Sun, 25 Sep 2016 07:47:07 GMT

Thanks! Work like a charm 🙂

Re: Sending emails from SAS with embedded table from dataset

vikpik — Tue, 10 Apr 2018 12:50:32 GMT

i have a different issue related to this. It works fine as long as I'm running the code manually. However When I'm running this through cron job, it is not capturing the columns. Anyone has any idea to solve for this?

Re: Sending emails from SAS with embedded table from dataset

mstacey_foresters_com — Tue, 10 Apr 2018 13:01:26 GMT

Hello,

What do you mean by CRON job, is this a batch job?

Re: Sending emails from SAS with embedded table from dataset

vikpik — Tue, 10 Apr 2018 13:40:05 GMT

Yes, this is to schedule sas jobs.

Re: Sending emails from SAS with embedded table from dataset

mstacey_foresters_com — Tue, 10 Apr 2018 14:04:23 GMT

Can you send me an email of the output produced through the batch?

mstacey@foresters.com

Re: Sending emails from SAS with embedded table from dataset

PrimeDougR — Fri, 20 Apr 2018 15:51:30 GMT

I had the same problem. If you don't already have it, try adding:

Options validvarname='any';

This enabled my Cron jobs to run successfully.

Re: Sending emails from SAS with embedded table from dataset

sophie07 — Tue, 10 Jul 2018 10:03:37 GMT

Hi,

thank you for this i have found it extremely useful and works like a charm.

i would like to know how i add a border between the columns and rows?

if you have any useful links or reading material for me to find the different styles it would be appreciated.

Re: Sending emails from SAS with embedded table from dataset

Cynthia_sas — Wed, 11 Jul 2018 21:22:41 GMT

Hi:
The original poster was using style=noline -- which implies a custom style was in place. They also had HEADLINE and HEADSKIP, which are ignored by ODS HTML.

But, instead of style=noline, you could try one of the predefined styles, like:
style=journal
style=sasweb
style=default
style=htmlblue
style=watercolor
style=pearl

And see which one you like best.

cynthia

Re: Sending emails from SAS with embedded table from dataset

sophie07 — Thu, 19 Jul 2018 13:42:23 GMT

thank you so much!

i liked the style=journal 🙂

i have one more question..

in the table that im emailing out there is a field called 'RECORD_CHECK'

i would like 'RECORD_CHECK' to be highlighted a certain color when it contains the words "excessively low"

anyone know how this can be acchived

Re: Sending emails from SAS with embedded table from dataset

Cynthia_sas — Thu, 19 Jul 2018 20:06:50 GMT

Hi:
Typically with PROC REPORT, the simplest way is with a user-defined format. But it depends on whether the value is ALWAYS "excessively low" or could be a string that contained that phase, like "today the system response seemed excessively low". A user-defined format would work well for the first scenario, but you'd have to use a COMPUTE block for the second scenario. Either way, there are examples of a user-defined format and COMPUTE blocks for color coding in this paper: http://support.sas.com/resources/papers/proceedings13/366-2013.pdf pages 9-14 for examples. (The format is in the PROC PRINT code on page 9 -- PROC REPORT example starts around page 11.

cynthia

Re: Sending emails from SAS with embedded table from dataset

sophie07 — Mon, 30 Jul 2018 11:14:59 GMT

Hi Cynthia,

Apologies for the delay in my response.

Thank you so much for taking the time to assist me. i am working through the examples.

Re: Sending emails from SAS with embedded table from dataset

Lenvdb — Wed, 08 Aug 2018 12:21:55 GMT

Can this work if I want to embed 3 small datasets as reports in a single email as html? How would I do this? What would the structure be?

Re: Sending emails from SAS with embedded table from dataset

pratixitvajpai — Wed, 17 Apr 2019 11:24:32 GMT

I am using the same code but for, "options emailhost = "XX.XX.XX" ; ". I am getting error. I am using my company's host email yet it says, "Email host couldn't be found"

what could be wrong, someone please help me

Thanks

Re: Sending emails from SAS with embedded table from dataset

Cynthia_sas — Wed, 17 Apr 2019 14:26:38 GMT

Hi:
It would have been better for you to create a new posting and then refer to this older post. You added a new question to a 3 year old posting.
However, in order to use any email features of SAS, you MUST work with your SAS Administrator in order to make sure that the correct system options relating to email have been set. If the options are not set when SAS starts up, you will NOT be able to do any emailing from a program.
So the appropriate place to start is with your SAS Administrator to find out whether you're allowed to send email, and if so, the name of the host to use and then verify that the necessary system options have been set.
Cynthia

Re: Sending emails from SAS with embedded table from dataset

vikpik — Mon, 22 Apr 2019 19:54:28 GMT

Use following. Keep adding Proc Report for all additional dataset you want to send in email:-

filename temp email

TO=("email@domainname.com")

subject="POC starting Queue"

type="text/html"

from = "youremail@domainname.com";

ODS html body=temp style = analysis;

ods html text = "Hi All";

ods html text = " ";

ods html text = "Following Accounts are pending POC :-";

PROC Report data=RVPOCFINAL nowd HEADLINE HEADSKIP

style (report) = {background = white

font_face = "Verdana" font_size = 7pt just=left }

style (column) = {background = white CELLHEIGHT = 2.5%

font_face = "Verdana" font_size = 7pt just=left}

style (header) = {foreground = cx5e2750 font_face="Verdana"

font_size = 8pt just=left

background = white} ;

columns

column_name1

column_name2

column_namexx

;

run;

Re: Sending emails from SAS with embedded table from dataset

SASdevAnneMarie — Wed, 14 Jul 2021 10:25:56 GMT

Hello,
When I run this code I have an ERROR : ERROR: Email host xx.xx.xx not found.
Could you help me please with this option ?

Thank you !

Re: Sending emails from SAS with embedded table from dataset

Cynthia_sas — Wed, 14 Jul 2021 16:14:56 GMT

Hi:
If the email host cannot be found, then that means you need to find out from your mail administrator what the correct host name is. You'll also need to check with your SAS Administrator to make sure that the email-related system options refer to the correct settings. If you need more help, your best resource is SAS Tech Support.
Cynthia

Re: Sending emails from SAS with embedded table from dataset

SASdevAnneMarie — Wed, 14 Jul 2021 16:59:10 GMT

Than you, Cynthia !

Where can I found the email host? Is it in my log ?