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
...
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: