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!
Ke
Thanks!
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
...
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.