DATA Step, Macro, Functions and more

control data font size in excel exported output from ODS tagsets.ExcelXP

Reply
Frequent Contributor
Posts: 95

control data font size in excel exported output from ODS tagsets.ExcelXP

Hello

I want to control font size in all tables that are exported in  ODS tagsets.ExcelXP.

I want to have tables in excel with excel size 8.

What is the way to control data font size in excel exported output from  ODS tagsets.ExcelXP?

 

Thaks

 

SAS Super FREQ
Posts: 9,263

Re: control data font size in excel exported output from ODS tagsets.ExcelXP

[ Edited ]

Hi:
The method you use will depend on the procedure you have inside your ODS TAGSETS.EXCELXP "sandwich" -- for PRINT, REPORT or TABULATE -- you can change the font of the output with a simple style override.

Cynthia

 

Here's an example:

ods tagsets.excelxp file='c:\temp\change_font.xml' style=htmlblue
    options(sheet_name='Print');
  proc print data=sashelp.class (obs=3) noobs
       style(header)={font_face='Courier New' fontsize=8pt fontweight=bold}
	   style(data)={font_face='Courier New' fontsize=8pt};
  run;
  
  ods tagsets.excelxp options(sheet_name='Report');
  proc report data=sashelp.class (obs=3)
       style(header)={font_face='Albany AMT' fontsize=8pt fontweight=bold}
	   style(column)={font_face='Albany AMT' fontsize=8pt};
  run;
  
  ods tagsets.excelxp options(sheet_name='Tabulate');
  proc tabulate data=sashelp.class;
    class sex age / style={font_face='Times New Roman' fontsize=8pt fontweight=bold};
    var height / style={font_face='Times New Roman' fontsize=8pt};
    classlev sex age / style={font_face='Times New Roman' fontsize=8pt fontweight=bold};
    table sex all,
	      age*n*{style={font_face='Times New Roman' fontsize=8pt}};
    keylabel n=' ' 
             all='Total';
	keyword all / style={font_face='Albany AMT' fontsize=8pt fontweight=bold};
    keyword n /style={font_face='Albany AMT' fontsize=8pt fontweight=bold};
run;
ods tagsets.excelxp close;
Ask a Question
Discussion stats
  • 1 reply
  • 71 views
  • 0 likes
  • 2 in conversation