ODS and Base Reporting

Build reports by using ODS to create HTML, PDF, RTF, Excel, text reports and more!
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-white.png

Our biggest data and AI event of the year.

Don’t miss the livestream kicking off May 7. It’s free. It’s easy. And it’s the best seat in the house.

Join us virtually with our complimentary SAS Innovate Digital Pass. Watch live or on-demand in multiple languages, with translations available to help you get the most out of every session.

 

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