ODS and Base Reporting

Build reports by using ODS to create HTML, PDF, RTF, Excel, text reports and more!
BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
t_ar_taat
Quartz | Level 8

Hi!
When ods excel, default style is HTMLBlue.
like this.

HTMLBlue.jpg

For me, simple/naked/nostyle is better like this.

simple-style.jpg
Is there way to get it?
I asked google but failed.

google-search.jpg
also
https://www.pharmasug.org/proceedings/2018/BB/PharmaSUG-2018-BB03.pdf
This document say "no style" means HTMLBlue. But I want totally simple/no style one.
no-stye-htmlblue.jpg
Saying another way, I want make proc print / proc report with no style.

Thank you for your helping.

 

minimum ods excel code

ods excel file= "D:\test.xlsx" ;
proc odstext;
  p "A";
run;  

proc print data=sashelp.heart(obs=5);
 var Status;
run;
ods excel close;

 

1 ACCEPTED SOLUTION
4 REPLIES 4
t_ar_taat
Quartz | Level 8

Thank you, this is what I want.

ods excel file= "D:\test.xlsx" 
style=minimal
;

proc print data=sashelp.heart(obs=5);
 var Status;
run;
ods excel close;
ballardw
Super User

Clarification: if you do not specify a Style on an ODS destination statement then you get the default for the destination.

ODS Excel will default to the Style set as the default style for your SAS session which might be HTMLBlue.I know that it is not in my install because I set MEADOW as my default style.

Some destinations like ODS RTF will use their own preferred style RTF unless you specifically override it. ODS Powerpoint uses one of PowerPointLIght or PowerPointDark (or similar restricted styles as not all the PowerPoint features will work with just any style).

 

So you could set a style such as Minimal as your default or specify it as the style on the ODS destination statement.

t_ar_taat
Quartz | Level 8
ballardw,thank you for your help!

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
  • 4 replies
  • 2716 views
  • 1 like
  • 3 in conversation