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

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

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