topic Re: Formatting proc print tables in email body text to include lines in SAS Enterprise Guide

Formatting proc print tables in email body text to include lines

Mar1ene — Tue, 18 Sep 2018 15:39:00 GMT

Hello,

I use Enterprise 7.1 and coded the below to generate email output, however want to add column/row lines to the tables (output example at the bottom)

options emailsys=smtp emailhost= localhost emailport=25;

FILENAME OUTPUT EMAIL
SUBJECT = "EMAIL SUBJECT"
attach=("/Path/File_Name.xlsx" content_type="application/xlsx")
FROM = "Me@stuff.co.za"
TO=('Person1@stuff.co.za' 'Person2@stuff.co.za')
type='text/html'
CT ='text/html';

ods html3 body=OUTPUT

style=htmlblue;
ods escapechar='^';
ODS TEXT="^S={font_face='Calibri' font_size=3 fontweight=Medium foreground=black} ";
ODS TEXT="^S={font_face='Calibri' font_size=3 fontweight=Medium foreground=black}Good Day,";
ODS TEXT="^S={font_face='Calibri' font_size=3 fontweight=Medium foreground=black} ";
ODS TEXT="^S={font_face='Calibri' font_size=3 fontweight=Medium foreground=black}Summarised view below.";
ODS TEXT="^S={font_face='Calibri' font_size=3 fontweight=Medium foreground=black} ";
ODS TEXT="^S={font_face='Calibri' font_size=3 fontweight=Medium foreground=black}Kind Regards,";
ODS TEXT="^S={font_face='Calibri' font_size=3 fontweight=Medium foreground=black} ";

proc print data=Source_Table noobs;
VAR Loan_Purpose Pricing Loan_Amount n;
format loan_amount comma20.;
TITLE "TABLE TITLE";
Footnote1 "Lottery is based on Male population";
Footnote2 "Average shoe price just over R1k";
run;

ods html3 close;

BTW! I erased the Excel attached due to confidentiality 😄

Re: Formatting proc print tables in email body text to include lines

ballardw — Tue, 18 Sep 2018 16:04:27 GMT

Try removing the NOOBS option on the Proc Print statement. That option specifically excludes observation numbers.

Re: Formatting proc print tables in email body text to include lines

Mar1ene — Tue, 18 Sep 2018 18:27:16 GMT

Thank you Ballardw :D,

I understand that, however I want to add physical lines (like excel formatting) to the tables to read the data easier.

Re: Formatting proc print tables in email body text to include lines

Tom — Tue, 18 Sep 2018 19:16:48 GMT

Are you asking how to use the FOOTNOTE statement?

Re: Formatting proc print tables in email body text to include lines

ballardw — Tue, 18 Sep 2018 20:23:45 GMT

@Mar1ene wrote:

Thank you Ballardw :D,

I understand that, however I want to add physical lines (like excel formatting) to the tables to read the data easier.

M

????

Appearance in SAS is done with style elements. Each variable in proc print can have an specific style elements set, font size, weight color, back ground color as a start.

But I have no idea what you mean by "like excel formatting" when used with "add physical lines".

If you want additional text that does not appear from proc print then perhaps Proc ODSTEXT (not the same as the ODS text you show).

Re: Formatting proc print tables in email body text to include lines

FredrikE — Wed, 19 Sep 2018 07:34:56 GMT

Maybe you can use some of these 🙂

The perfect grid?!

http://www2.sas.com/proceedings/forum2008/258-2008.pdf

Seemes that mail clients might change the HTML...:

https://communities.sas.com/t5/ODS-and-Base-Reporting/Missing-gridlines/td-p/262943

//Fredrik

Re: Formatting proc print tables in email body text to include lines

Mar1ene — Wed, 19 Sep 2018 08:10:07 GMT

LOL Tom 😜

I want to add physical lines to my email tables. Like in excel, separating columns and rows to read the data easier.

Re: Formatting proc print tables in email body text to include lines

Mar1ene — Wed, 19 Sep 2018 08:30:38 GMT

This is what I want to do... add lines to the table in the email... ...:D just prettier... this is a paintbrush job...

Re: Formatting proc print tables in email body text to include lines

Mar1ene — Wed, 19 Sep 2018 08:39:45 GMT

thank you Fredrik!! very helpful... I saved this for future reference...

Re: Formatting proc print tables in email body text to include lines

FredrikE — Wed, 19 Sep 2018 14:49:22 GMT

Hi!

For me it worked by adding a style (table) with frame=box and width:

proc print data=sashelp.class noobs
 style (table) = [frame=box borderwidth=1 ];
;
VAR sex name age;
TITLE "TABLE TITLE";
Footnote1 "Lottery is based on Male population";
Footnote2 "Average shoe price just over R1k";
run;

More info in this:

http://support.sas.com/resources/papers/proceedings13/366-2013.pdf

//Fredrik

Re: Formatting proc print tables in email body text to include lines

Mar1ene — Wed, 19 Sep 2018 15:23:29 GMT

Fredrik, you are my fudging hero!! Thank you soooo much!! This is exactly what I wanted!!

Re: Formatting proc print tables in email body text to include lines

Tom — Wed, 19 Sep 2018 15:55:18 GMT

So you wanted to add borders around the cells in the table.

It sounded like you wanted to add lines of text.

Re: Formatting proc print tables in email body text to include lines

Mar1ene — Wed, 19 Sep 2018 16:18:25 GMT

Hi Tom,

I have to agree, I could have worded my question better... I guess it comes with not being English 😜 ... Thank you for wanting to assist anyway!!