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
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;
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.