topic Re: ODS EXCEL in ODS and Base Reporting

ODS EXCEL

jins — Thu, 22 Mar 2018 20:50:26 GMT

When I move the run between windows and UNIX for ODS EXCEL OUPUT, the font changes. I am aware it is OS dependent but is there a style or so which can make it consistent? or any options?

Re: ODS EXCEL

ballardw — Thu, 22 Mar 2018 23:12:37 GMT

Are you specifying a STYLE on the ODS Excel statement? If not then two different installs may be using different styles as the default.

I would start by finding a style common to both installs and using that. Note that the installs may have different styles available.

proc template;

list/where=(lowcase(type)='style');

run;

will generate output with the available styles.

Re: ODS EXCEL

jins — Thu, 22 Mar 2018 23:51:12 GMT

So if we specifically list the style, it should be independent of the OS with regards to all the attributes like font size, font , etc.

Re: ODS EXCEL

Cynthia_sas — Fri, 23 Mar 2018 01:07:45 GMT

Hi:
Maybe. It depends on the style and the font settings in the style. The fonts in the style have to be available on the OS. Many of the newer SAS styles have a specification like this:
'TitleFont' = ("<MTsans-serif>, Albany AMT",11pt,bold)
where the font in the greater than and less than symbols is going to be defined in the SAS registry. You have to look under the ODS --> Fonts registry entry to see that (in my system, on Windows), the MTsans-serif font is defined as Albany AMT.

So, you might find that the MTsans-serif font on one operating system is different in the registry than the MTsans-serif font in the registry in another operating system.

This page lists the fonts http://go.documentation.sas.com/?docsetId=lrcon&docsetTarget=n04qo8tw2712qln1mzugjoorkj7j.htm&docsetVersion=9.4&locale=en#p0is74urmmze08n1ou7f0qof6xcf just scroll down to the table on the page that has the title: True Type fonts supplied by SAS.

Cynthia