BookmarkSubscribeRSS Feed
Ronein
Meteorite | Level 14

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.

 

Ronein_0-1719988551544.png

 

 

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;

 

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 0 replies
  • 72 views
  • 0 likes
  • 1 in conversation