The SAS Output Delivery System and reporting techniques

Font properties in ODS Excel

Accepted Solution Solved
Reply
Occasional Contributor ADN
Occasional Contributor
Posts: 6
Accepted Solution

Font properties in ODS Excel

Hi,

 

I am using SAS ODS Excel to generate excel files with tables. My question is how do I set the font, font size, color and font weight. 

 

Previously I used something like this in SAS ods excelxp tagset. But that does not seem to be working anymore.

 

define tot_defects/ display style(header)={font_face="Calibri" font_size=12pt font_weight=bold background=CX2E8B57 foreground=CXFFFFFF just=c}
          style(column)={font_face="Calibri" font_size=10pt just=c};

 

 


Accepted Solutions
Solution
‎04-25-2017 08:02 AM
SAS Employee
Posts: 274

Re: Font properties in ODS Excel

I suggest that you open a track with our Technical Support Department:

 

http://support.sas.com/ctx/supportform/createForm

 

Be sure to include your code, sample data, and a copy of the SAS log from the code that fails.

 

Vince DelGobbo

SAS R&D

 

View solution in original post


All Replies
SAS Employee
Posts: 274

Re: Font properties in ODS Excel

[ Edited ]

What version of SAS are you using?  This worked for me using SAS 9.4 M3 on Windows:

 

ods _all_ close;
ods Excel file='C:\temp\temp.xlsx'; proc report data=sashelp.class nowd; column name age sex height weight; define name / display style(header)=[font_face='Calibri' font_size=12pt font_weight=bold background=CX2E8B57 foreground=CXFFFFFF just=c] style(column)=[font_face='Calibri' font_size=10pt just=c]; run; quit; ods Excel close;

Vince DelGobbo

SAS R&D

Occasional Contributor ADN
Occasional Contributor
Posts: 6

Re: Font properties in ODS Excel

I am using sas 9.04.01M3P062415

 

I think the Fonts are not coming as expected. Rest is still fine........

Solution
‎04-25-2017 08:02 AM
SAS Employee
Posts: 274

Re: Font properties in ODS Excel

I suggest that you open a track with our Technical Support Department:

 

http://support.sas.com/ctx/supportform/createForm

 

Be sure to include your code, sample data, and a copy of the SAS log from the code that fails.

 

Vince DelGobbo

SAS R&D

 

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 197 views
  • 1 like
  • 2 in conversation