topic Re: Modifying a style for Excel in ODS and Base Reporting

Modifying a style for Excel

RichardAD — Fri, 04 Apr 2025 17:44:25 GMT

I am creating a custom style, so my Excel output uses the Aptos font.

I tried the following and get Courier instead of Aptos.

proc template ;
define style my_excel ;
  parent=styles.htmlblue ;
  class Table, Note, Header, Data, BodyText / fontfamily="Aptos" ;
end ;
run ;

ods excel
  style=my_excel
  file="&out_folder/class.xlsx" 
  options (sheet_name='Class' frozen_headers='on' autofilter='all')
;
proc print noobs data=sashelp.class ;
run ;
ods excel close ;

Where fore art thou Aptos?

Re: Modifying a style for Excel

Cynthia_sas — Fri, 04 Apr 2025 20:13:13 GMT

Hi:

Typically, if you don't get the font you've defined it is sometimes because you have to use PROC FONTREG to register the font with SAS. That means you point SAS to the Windows font library. Interestingly, when I looked in my Windows font library, I did not see the Aptos font files there.

Digging a bit more, it seems that Microsoft has defined Aptos as a "cloud font" which is only available to Microsoft 365 subscribers: https://support.microsoft.com/en-us/office/cloud-fonts-in-office-f7b009fe-037f-45ed-a556-b5fe6ede6adb

I am not sure what the cloud location path is for you to point to it with PROC FONTREG, however, you might want to work with Tech Support on this question. In the past, I have only used PROC FONTREG with fonts that were on my C: drive.

Cynthia

Re: Modifying a style for Excel

RichardAD — Sat, 05 Apr 2025 05:30:57 GMT

It worked thanks!

I downloaded Aptos from Microsoft and extracted the ttfs.

proc fontreg MSGLEVEL=VERBOSE mode=replace;
  fontpath "<Aptos extraction folder>" ;
run ;