Automating emails and insert data set as a part of my email body. Formatting the email content

pankse — Thu, 06 Nov 2025 05:08:23 GMT

Hi,

Below is the sample code I am using to send out an automated email with some text and one of my data set in the body of my email. However, when I receive the email the text show in a table form which I don't want. I just want the data set to appear in a table form.

I want the output / email to show as

Code:

/* 1. Define a more aggressive custom style */
PROC TEMPLATE;
DEFINE STYLE STYLES.NO_TABLE_TEXT;
PARENT=STYLES.JOURNAL;

/* Target the main body and page containers to strip borders and background */
CLASS BODY /
BACKGROUNDCOLOR=WHITE
HTMLSTYLE="border:none;";

CLASS PAGE /
HTMLSTYLE="border:none;";

CLASS SYSTITLEANDFOOTERCONTAINER /
HTMLSTYLE="border:none;";

/* *** CRITICAL ADDITION ***
The ODS TEXT output is often treated as a REPORT section.
Force it to have no rules/frame. */
CLASS REPORT /
RULES=NONE
FRAME=VOID
HTMLSTYLE="border:none; margin: 0; padding: 0;"; /* Ensure no space/border */

/* Another container element to strip */
CLASS TABLE /
RULES=NONE
FRAME=VOID
HTMLSTYLE="border:none; margin: 0; padding: 0;";

END;
RUN;

* 1. Set the email system options;

Options emailsys=smtp

emailid="sample@email.com"

EMAILHOST="mail.net"

EMAILPORT=25;

* 2. Define the email file reference;

FILENAME outbox EMAIL

TO=("sample@email.com")

SUBJECT="Report - &tday."

IMPORTANCE="HIGH"

SENSITIVITY="CONFIDENTIAL"

CONTENT_TYPE="text/html"

TYPE="text/html"

ATTACH=("&out.Report_&tday..xlsx");

ods tagsets.msoffice2k body=outbox STYLE=NO_TABLE_TEXT;

ods text = "Good morning,";

ods text = " ";

ods text = "Please see attached report for &tday.";

ods text = " ";

ods text = "Thanks";

ods text = " ";

ods text = "PS";

ods text = " ";

ods text = "&comparison_result";

ods text = " ";

proc print data=Change noobs;

VAR _ALL_ / STYLE(COLUMN)={CELLWIDTH=0.7in}

STYLE(HEADER) = {FONTWEIGHT=BOLD BACKGROUNDCOLOR=White FOREGROUND=Black }

STYLE(DATA) = {BORDERCOLOR=black BACKGROUNDCOLOR=WHITE FOREGROUND=BLACK}

;

run;

ods tagsets.msoffice2k close;

filename outbox clear;

Re: Automating emails and insert data set as a part of my email body. Formatting the email content

Kathryn_SAS — Thu, 06 Nov 2025 12:39:20 GMT

Try using PROC ODSTEXT rather than ODS TEXT as follows:

ods tagsets.msoffice2k body=outbox STYLE=NO_TABLE_TEXT;
proc odstext;
p "Good morning,";
p " ";
p "Please see attached report for &tday.";
p " ";
P "Thanks";
p " ";
p "PS";
p " ";
p "&comparison_result";
p " ";
run;

proc print data=sashelp.class(obs=3) noobs;
VAR _ALL_ / 
  STYLE(HEADER) = {FONTWEIGHT=BOLD BACKGROUNDCOLOR=White FOREGROUND=Black }
        STYLE(DATA) = {BORDERCOLOR=black BACKGROUNDCOLOR=WHITE FOREGROUND=BLACK CELLWIDTH=0.7in}
                    ;
run;
 
ods tagsets.msoffice2k close;

Re: Automating emails and insert data set as a part of my email body. Formatting the email content

pankse — Fri, 07 Nov 2025 00:36:45 GMT

Thank you Kathryn the solution worked.

topic Re: Automating emails and insert data set as a part of my email body. Formatting the email content in SAS Enterprise Guide

Automating emails and insert data set as a part of my email body. Formatting the email content

Re: Automating emails and insert data set as a part of my email body. Formatting the email content

Re: Automating emails and insert data set as a part of my email body. Formatting the email content