ODS and Base Reporting

Build reports by using ODS to create HTML, PDF, RTF, Excel, text reports and more!
BookmarkSubscribeRSS Feed
anil2
Fluorite | Level 6
FILENAME mail EMAIL 
TO=("anil.patil@edelweissfin.com" )

 SUBJECT="Retail Finance - Credit TAT Dashboard - 01-Aug-2018 to 31-Aug-2018" CONTENT_TYPE="text/html";



ODS LISTING CLOSE;

ODS HTML BODY=mail;
ODS STARTPAGE = NO;
ods escapechar='^';
proc odstext ;ODS STARTPAGE = NO;
   p "Dear Team, ^{style[font_size=12pt font=('Calibri') fontweight=bold]}^{newline 2}" ;
   p "Please find below the link for TAT Dashboard Report for the period 01-Aug-2018 to 31-Aug-2018.";
   p "";
   p "http://sasreports.edelweissfin.com:7980/SASVisualAnalytics/report?location=%2FShared%20Data%2FVA_Reports%2FRF_Main%2FCredit%20Dashboard%20report&type=Report.BI&section=vi114845";
    p "";
   p "PFB Zone wise quick snapshot for your reference.";
run;

PROC REPORT DATA=sashelp.class nocenter out=Tat_volume_overall LIST 
/*style=[cellwidth=.1 in rules=group frame=void] */
style(header)=[background= #BBDEFB foreground=black]
style(summary)=[background=white   foreground=black font_weight=bold]
style={font_size=10pt font=('Calibri') width=600 cellpadding=2 borderwidth=0 bordercolor=white}
 ;

COLUMN  Name age sex ;
define Name / center  ;
define age / center analysis mean  format=Number20.0;
define sex / center ;

RBREAK AFTER /summarize ;

 RUN;

   proc odstext;
   		p " ";
		p " ";
   		p "Thanks & Regards,";
		p "Business Excellence - RF.";
	run;

ODS HTML CLOSE;
ODS LISTING;

Capture1.PNG

1 REPLY 1
ChrisNZ
Tourmaline | Level 20

Not a direct reply, but maybe you could write these lines as titles?

 

Or maybe a data step using object dsout would leave less space?

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