BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
pfvk
Fluorite | Level 6

Hi,
I'm trying to use ODS EXCEL to output my dataset.
Below is an example of my code.

data test;
	input ID$ age;
	cards;
	A 23
	B 99
	C 87
	;
run;

ods excel file="age.xlsx"  options(sheet_name="test");
proc report data=test
	style(header)=[background=white font_face="Calibri" foreground=black]
	style(column)=[font_face="Calibri"]
nowd;
run;
ods excel close;

The result is like the below picture, the background borders are not displayed.

2023-02-04.png

 

 

 

 

 

 

I would like to keep all the borders like the one below, how can I modify my code?
Thanks in advance.

2023-02-04 (1).png

1 ACCEPTED SOLUTION

Accepted Solutions
Ksharp
Super User
If you want see what things in STYLE.MINIMAIL ,Try this :

proc template;
source styles.minimal;
run;

View solution in original post

3 REPLIES 3
Ksharp
Super User
ods excel file="c:\temp\age.xlsx"  options(sheet_name="test") style=minimal;
proc report data=test
	style(header)=[ font_face="Calibri"]
	style(column)=[font_face="Calibri"]
nowd;
run;
ods excel close;

Ksharp_0-1675502993057.png

 

pfvk
Fluorite | Level 6

Thanks for your help!
I have a small question. Is there any reference including all meanings of "style" in ODS EXCEL?

Ksharp
Super User
If you want see what things in STYLE.MINIMAIL ,Try this :

proc template;
source styles.minimal;
run;

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

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