Using the code below, the resulting font is Helvetica. To my eye the fonts are indistinguishable in Excel, however, it is important to have the font set to Arial.
proc template; define style mystyle; class header, footer, data/ fontfamily = "Arial" fontsize= 14pt bordercolor = black borderstyle = solid ; class systemtitle / fontfamily = "Arial" fontsize= 14pt textalign=left; end; ods excel file= "&excel_export_path." style=mystyle options(start_at="2,1" embedded_titles="yes" sheet_interval="none"); proc report data=sashelp.class SPLIT='|' spanrows ; column (Sex Name Weight); run; ods excel close;
Hi:
That's not what I observe when I do this:
Perhaps there is something wrong with your template. Since I can see that Arial works in a simple style override, there's a workaround for you and so, no need for a template. If you are wedded to the template idea, then you may have to work with Tech Support on why your template didn't work as you wanted.
Hope this helps,
Cynthia
Thank you.
The reason I have this as a template is because I want it to be a global setting for everything inside the ods excel, not just for a particular report/row/column. Is there a work-around for this?
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: