Modifying a style for Excel

[RichardAD]

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?

[Cynthia_sas · Accepted solution]

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-b5fe6ede6ad...

  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

[RichardAD]

It worked thanks!

I downloaded Aptos from Microsoft and extracted the ttfs.

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