send email via sas body email align texts to right

Ronein — Wed, 03 Jul 2024 08:11:51 GMT

Hello

I run a code that send an email via sas and send a table in body of email and also attach XLX file.

The code is working 100% but there are 2 issues I want to improve-

1- The sentences in body email are written in Hebrew so they should be in right align and not left align.

2- There are lines that are not nice between the sentences in body email.

What is the way to remove them that between the sentences there will not be lines.

title;
footnote;
filename temp email
from = "Dave.Choen@gmail.com"
TO=("Ben.Suart@gmail.com",
"Nataliya.Shetrit@gmail.com")
subject="Sales control"
type="text/html"
encoding='utf-8' 
attach=("/usr/local/SAS/SASUsers/LabRet/UserDir/udclk79/Haamadot_Daily_Bakara.xlsx"
content_type="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
ODS html body=temp ;
ods html text = "היי;
ods html text = "להלן בקרה יומית של העמדות";
ods html text = " ";
ods html text = "בברכה,דייויד";
title;
 
proc report data=Last_7Days_c  nowd;
compute STAT;
if substr(STAT,1,4)='AMNT' then call define(_row_, "style", "style=[backgroundcolor=lightyellow]");
else IF STAT='' then call define(_row_, "style", "style=[backgroundcolor=lightgrey]");
endcomp;
run;

Re: send email via sas body email align texts to right

sbxkoenk — Sun, 07 Jul 2024 16:11:42 GMT

Have a look at:

Proc REPORT Tutorial
Cynthia L. Zender, SAS Institute, Inc., Cary, NC
https://www.lexjansen.com/wuss/2010/TUT/3027_1_TUT-Zender.pdf

I think you need

just=r and
borderwidth=0

proc report data=sashelp.class nowd; 
run;

proc report data=sashelp.class nowd
/* PROC REPORT component COLUMN is for the data cells */
  style(column)={just=r background=white
                 cellspacing=4pt
                 bordercolor=black borderwidth=0
                 rules=rows frame=box};  
run;

Koen

topic Re: send email via sas body email align texts to right in SAS Programming

send email via sas body email align texts to right

Re: send email via sas body email align texts to right