topic ODS EXCEL using Calibri on Unix/Linux Server in ODS and Base Reporting

ODS EXCEL using Calibri on Unix/Linux Server

xueke47 — Tue, 26 Jan 2021 14:26:01 GMT

Hi all,

My company needs to generate some Excel files in the Calibri font. I wrote the code using ODS EXCEL and PROC REPORT that produces the desired output in both SAS Base (9.4 TS1M5) and SAS EG (7.15 HF3) on my company's computers, which are on Windows Server 2012R2. However, when my colleague takes the same code to run in SAS EBI on the CMS server (which is Unix/Linux), the font never comes in Calibri, but other formats of the Excel files are as coded. I did some research and have a clue about the reason. Could someone confirm/disconfirm? Thanks!

My guess is that Calibri is not installed/registered on the CMS server, so the SAS EBI there cannot recognize the "font_face=Calibri" option. I get this idea from the post here, but one difference is that our log doesn't have "WARNING: Font specification 'Calibri' failed. Using default font family instead." in it. In addition, if I run the following code in SAS EBI on the CMS server, and don't see Calibri in the log, does this confirm my guess?

proc registry startat="\CORE\PRINTING\FREETYPE\FONTS" list levels=1;

run;

Thanks!

Re: ODS EXCEL using Calibri on Unix/Linux Server

Cynthia_sas — Tue, 26 Jan 2021 21:00:00 GMT

Hi:
This is really a question for Tech Support. Note that you typically ONLY get that font warning in Graphics programs, not in regular programs that use procedures like REPORT or TABULATE.

Cynthia

Re: ODS EXCEL using Calibri on Unix/Linux Server

xueke47 — Tue, 26 Jan 2021 22:10:51 GMT

Thanks!

Re: ODS EXCEL using Calibri on Unix/Linux Server

RichardDeVen — Wed, 15 Feb 2023 23:23:33 GMT

Proc QDEVICE REPORT=FONT;

will list all the fonts (Stroke of TrueType) supported by the installation, look for the section such as

...
Supported TrueType Typefaces: Albany AMT (alias: Albany)
                              Arial Symbol
                              Arial Unicode MS (alias: Monotype Sans WT J)
                              AvenirNextforSAS
                              AvenirNextforSAS Light
                              Batang
                              ...