topic Re: ODS EXCEL,no style (style=none or simple) for proc print/proc report in ODS and Base Reporting

ODS EXCEL,no style (style=none or simple) for proc print/proc report

t_ar_taat — Tue, 12 Apr 2022 09:33:30 GMT

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

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

Is there way to get it?
I asked google but failed.

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.

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;

Re: ODS EXCEL,no style (style=none or simple) for proc print/proc report

Ksharp — Tue, 12 Apr 2022 12:01:25 GMT

style=minimal

Re: ODS EXCEL,no style (style=none or simple) for proc print/proc report

ballardw — Tue, 12 Apr 2022 15:13:41 GMT

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.

Re: ODS EXCEL,no style (style=none or simple) for proc print/proc report

t_ar_taat — Wed, 13 Apr 2022 01:44:56 GMT

ballardw,thank you for your help!

Re: ODS EXCEL,no style (style=none or simple) for proc print/proc report

t_ar_taat — Wed, 13 Apr 2022 01:46:16 GMT

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;