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;