BookmarkSubscribeRSS Feed
DavidBesaev
Fluorite | Level 6

Hello!

I trying to customize my table, but can change border in email. I just need some border like first screenshot.

options emailsys=smtp;
options emailport=25;
options emailauthprotocol=none;

filename temp email /*финальная*/
          to=(ASD@somemail.com)
        type='text/html'
        subject='Отчет Предпочтения новых игроков на сайте'
        ;

options orientation=landscape; 
ods html body=temp  style=noline;
ods html text = "Good Morning,";

ods html text = "";

proc print data=work.report_first_game_2 label noobs style(report)={posttext="Рассматриваются не уникальные игроки." };
 title1 'Предпочтения новых игроков сайта';
format date nldate20.
		game_rl
		game_6_45 nlnum10.;
	label date="Дата" 
		game_12_24="12/24" 
		game_4_20="4х20" 
		game_5_36="5x36" 
		game_6_36="6x36" 
		game_6_45="6x45" 
		game_matchbol="МатчБол" 
		game_7_49="7x49" 
		game_bonus="БИ" 
		game_duel="Дуэль" 
		game_keno="Кено" 
		game_prikup="Прикуп" 
		game_rapido="Рапидо" 
		game_rl="РЛ" 
		game_top_3="Топ-3" 
		game_zl="ЖЛ" 
		game_zp="ЗП" 
		total="Всего";
var		date / style(data)=[TEXTALIGN=CENTER VERTICALALIGN=center background=#dbdbdb borderwidth=2pt bordercolor=black] style(head)=[borderwidth=3pt bordercolor=black height=40pt width=60pt TEXTALIGN=CENTER background=#dbdbdb VERTICALALIGN=center ];
var  	game_4_20
		game_5_36 
		game_6_45 
		game_matchbol
		game_7_49 /style(data)=[TEXTALIGN=CENTER VERTICALALIGN=center  ] style(head)=[ TEXTALIGN=CENTER background=#ffe4c4 VERTICALALIGN=center width=40pt];
var 	game_rl
		game_zl
		game_6_36 
		game_zp / style(head)=[width=40pt TEXTALIGN=CENTER background=#98c793 VERTICALALIGN=center] style(data)=[TEXTALIGN=CENTER VERTICALALIGN=center ];
var		game_duel
		game_keno 
		game_prikup / style(data)=[TEXTALIGN=CENTER VERTICALALIGN=center  ] style(head)=[ width=42pt TEXTALIGN=CENTER background=#afdafc VERTICALALIGN=center];
var		game_rapido / style(data)=[TEXTALIGN=CENTER VERTICALALIGN=center  ] style(head)=[ width=44pt TEXTALIGN=CENTER background=#afdafc VERTICALALIGN=center];
var		game_top_3 
		game_12_24 /style(data)=[TEXTALIGN=CENTER VERTICALALIGN=center ] style(head)=[ width=42pt TEXTALIGN=CENTER background=#afdafc VERTICALALIGN=center];
var		game_bonus /style(data)=[TEXTALIGN=CENTER VERTICALALIGN=center ] style(head)=[ TEXTALIGN=CENTER width=40pt background=#cda4de VERTICALALIGN=center];
var		total / style(data)=[TEXTALIGN=CENTER background=#dbdbdb VERTICALALIGN=center ] style(head)=[TEXTALIGN=CENTER background=#dbdbdb VERTICALALIGN=center];
footnote;
run;

ods _all_ close;


In SAS EG it looks like 

image.png

but in email it doesn't change:

image.png

 

 

2 REPLIES 2
BrunoMueller
SAS Super FREQ

Which Email program do you use to look at the email?

 

If it is outlook, change your destination to HTML3 or TAGSETS.MSOFFICE2K and see if it displays any better.

 

they both generate HTML output, but in a way that Outlook will display better.

DavidBesaev
Fluorite | Level 6
Yeap, outlook.
I solved this problem by changing the style from noline to snow. It's looks like i can chage it by some parameter at style. But I didn't find. 😞

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

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
  • 2 replies
  • 2251 views
  • 1 like
  • 2 in conversation