topic Re: What font to choose - SAS Studio --> Word on PC in Graphics Programming

What font to choose - SAS Studio --> Word on PC

AndersS — Tue, 25 Jul 2023 20:09:10 GMT

Hi! I have used PROC SGPLOT to produce some nice graphs.

In the title statement I used "Albany AMT" - a tips from SAS written in the Log. Looks REALLY nice!

Then I download this as a flat file "mygraph.svg" and include it in standard MsWord (Office 365).

BUT now it does not look equally nice.

It turns out that Word does NOT support Albany AMT. Instead it uses Arial (Arial MSFontService).
The file mygraph.svg is a textfile, which can be viewed.

MY QUESTION: What Font shall I use in PROC SGPLOT in SAS Studio, so a file mygraph.svg is produced,

which then looks nice and good in MsWord on the PC?

The importance is the look in MsWord (not that it lokks nice in SAS Studio).

(A little like a problem of "merging two files with allowed fonts". Only those obs that are in both files are accepted.)

MANY THANKS in for any response!

/Br Anders

p.s. %SGANNO macros are great!

Re: What font to choose - SAS Studio --> Word on PC

JosvanderVelden — Wed, 26 Jul 2023 08:58:49 GMT

What happens if you use "options nofontembedding;" when creating the svg. Does that solve the font issue?

Re: What font to choose - SAS Studio --> Word on PC

Ksharp — Wed, 26 Jul 2023 11:56:33 GMT

Could you use PNG file ?
If you worried about display of picture, You could try dpi= and image_dpi= options:

ods listing gpath='c:\temp\' image_dpi=300;
ods graphics /imagename='want' outputfmt=png;
ods rtf file='c:\temp\want.rtf' dpi=300 ;
proc sgplot ;
...............
run;
ods rtf close;

Re: What font to choose - SAS Studio --> Word on PC

AndersS — Wed, 26 Jul 2023 15:05:32 GMT

Hi! I tested BOTH RTF and PNG. The code below produces both.
In Word I think that RTF is better.
data work.test;
xval=1; yval=2; output;
xval=3; yval=6; output;  run;

Title1 "RTF_PNG "  height=2 font="Albany AMT";
ods rtf file='/home/anders.skollermo/RTF_PNG.rtf' dpi=300 ;

ODS LISTING GPATH= "/home/anders.skollermo" image_dpi=300;

ODS GRAPHICS / ANTIALIASMAX= 20000 LINEPATTERNOBSMAX= 20000 height= 480px
width= 640px outputfmt= PNG imagename= "RTF_PNG";

proc sgplot data= work.test NOautolegend;
series x= Xval y= Yval;
run;

ODS RTF CLOSE;

Re: What font to choose - SAS Studio --> Word on PC

AndersS — Wed, 26 Jul 2023 15:06:17 GMT

MANY THANKS! Fast and VERY GOOD answer. /Br Anders

Re: What font to choose - SAS Studio --> Word on PC

DanH_sas — Wed, 26 Jul 2023 16:11:16 GMT

Just so you know, there is an ODS WORD destination as well. It might be worth a try as well.

Re: What font to choose - SAS Studio --> Word on PC

DanH_sas — Wed, 26 Jul 2023 16:14:06 GMT

ODS WORD supports both PNG and SVG output. The ODS style used also favors fonts typically used in Word.

Re: What font to choose - SAS Studio --> Word on PC

AndersS — Wed, 26 Jul 2023 16:52:56 GMT

Hi!
ODS WORD is preproduction now in SAS Studio. I just tested it.

But, I will remember this.

NO I did not know about ODS WORD. "Mea culpa".

/Br Anders

Re: What font to choose - SAS Studio --> Word on PC

DanH_sas — Wed, 26 Jul 2023 16:56:38 GMT

What version of SAS are you running?

Re: What font to choose - SAS Studio --> Word on PC

AndersS — Wed, 26 Jul 2023 16:59:48 GMT

Hi!

"options nofontembedding;" does NOT solve the problem with the font.

The svg-file comnatins the name of the font - and that font is not available on MsWord.

BUT - "Nice try" - a VERY GODD Idea. Many thanks. /Br Anders

Re: What font to choose - SAS Studio --> Word on PC

AndersS — Wed, 26 Jul 2023 17:01:11 GMT

SAS on demand for academics - I do not know.

Re: What font to choose - SAS Studio --> Word on PC

DanH_sas — Wed, 26 Jul 2023 18:02:22 GMT

Please run this command from the editor and post the value from the log:

%put &sysvlong;

Thanks!

Re: What font to choose - SAS Studio --> Word on PC

AndersS — Thu, 03 Aug 2023 13:13:03 GMT

Hi! The log in SAS Studio:

69 %put &sysvlong;

9.04.01M7P080620

Sorry for the late answer! I have been away for some days.

I have used ODS RTF; and outputfmt= PNG

I get a file named.rtf that I download to my PC. Opened i Word. Cut and paste into document.
Works fine.

If you have any idea about how to get nice graphics from SAS Studio into PC Word,

please tell me. I will try it and report here.

MANY THANKS! / Br Anders