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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.