Sending emails from SAS with embedded table from dataset

[mstacey_foresters_com]

Hello, 

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

[vikpik]

Yes, this is to schedule sas jobs. 

[mstacey_foresters_com]

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

mstacey@foresters.com

[PrimeDougR]

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.

[sophie07]

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.

[Cynthia_sas]

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

[sophie07]

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

[Cynthia_sas]

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

[sophie07]

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.