topic Re: Font properties in ODS Excel in ODS and Base Reporting

Font properties in ODS Excel

ADN — Wed, 19 Apr 2017 13:10:17 GMT

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};

Re: Font properties in ODS Excel

Vince_SAS — Wed, 19 Apr 2017 18:33:07 GMT

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

Re: Font properties in ODS Excel

ADN — Thu, 20 Apr 2017 09:18:27 GMT

I am using sas 9.04.01M3P062415

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

Re: Font properties in ODS Excel

Vince_SAS — Thu, 20 Apr 2017 11:25:17 GMT

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