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
...
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.