BookmarkSubscribeRSS Feed
Ronein
Onyx | Level 15

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;

 

1 REPLY 1
sbxkoenk
SAS Super FREQ

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

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 892 views
  • 0 likes
  • 2 in conversation