column manager department sales;
define manager / order
order=formatted
format=$mgrfmt.
'Manager'style(header)=[foreground=cyan
background=black];
define department / order
order=internal
format=$deptfmt.
'Department'style(column)=[fontstyle=italic];
break after manager / summarize;
compute after manager
/ style=[fontstyle=roman fontsize=3 fontweight=bold
background=white foreground=black];
line 'Subtotal for ' manager $mgrfmt. 'is '
sales.sum dollar7.2 '.';
endcomp;
compute sales;
if sales.sum>100 and _break_=' ' then
call define(_col_, "style",
"style=[background=#CCFF00
fontface=helvetica
fontweight=bold]");
endcomp;
compute after;
line 'Total for all departments: '
sales.sum dollar7.2 '.';
endcomp;
where sector='se';
run;
ods ps close;
PowerPoint Output
ods html close;
title1 'PowerPoint - Various Layouts and Styles';
footnote 'The PowerPoint Destination';
proc template;
define style styles.test;
parent= styles.powerpointlight;
class body /
backgroundimage="radial-gradient(40%, lightblue 40%,
yellow 30%, blue)"; ;
style graphbackground / image='c:\Public\foldedblends.bmp';
end;
run;
ods escapechar = "^";
ods PowerPoint file="powerptOptions.ppt" layout=titleslide
style=styles.test nogtitle nogfootnote;
Examples from the Gallery of ODS Samples 1061
Get SAS 9.4 Output Delivery System, 3rd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.