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};
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
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
I am using sas 9.04.01M3P062415
I think the Fonts are not coming as expected. Rest is still fine........
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
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.