topic Re: papersize=A4 did not work in ODS WORD in 9.4 M7 for linux 64 in SAS Programming

papersize=A4 did not work in ODS WORD in 9.4 M7 for linux 64

Jinlf — Mon, 28 Jun 2021 10:15:41 GMT

I was tring to output my result to word using ODS WORD, The following is test code, the option "papersize=A4" did not work and the papersize was "letter" in the output file. When i changed the destination to ODS RTF, it works. My SAS version is 9.4 M7 fo linux 64. I dont know why.

%let path = ......;

title;
options nodate nonumber papersize=A4;
ods escapechar="^";
ods graphics on;
ods word file="&path.toc2.docx";

proc freq data=sashelp.class;
tables sex*age/plots=freq;
run;
ods word close;

proc setinit;run;

Re: papersize=A4 did not work in ODS WORD in 9.4 M7 for linux 64

Ksharp — Mon, 28 Jun 2021 12:05:57 GMT

Check your papersize option after running your code by :

proc options option=papersize value;run;

Re: papersize=A4 did not work in ODS WORD in 9.4 M7 for linux 64

andreas_lds — Mon, 28 Jun 2021 13:25:44 GMT

Same problem using win64 and 9.4m7.

Re: papersize=A4 did not work in ODS WORD in 9.4 M7 for linux 64

ballardw — Mon, 28 Jun 2021 14:31:35 GMT

ODS Word I believe is still "pre-production". In effect that means not everything is going to work as expected and shouldn't be expected to be stable.

My limited use with ODS Word is table output is problematic depending on procedure and options active though I've okay luck with graphic output from Sgplot.

Re: papersize=A4 did not work in ODS WORD in 9.4 M7 for linux 64

Jinlf — Mon, 28 Jun 2021 16:30:06 GMT

I ran the code you supplied after my codes, the result of papersize was A4, not Letter.

Re: papersize=A4 did not work in ODS WORD in 9.4 M7 for linux 64

Cynthia_sas — Mon, 28 Jun 2021 19:05:11 GMT

Hi:
And another consideration is that according to the doc, PAPERSIZE is impacted by LOCALE. So maybe there's something in ODS WORD that is using the default instead of what you want. The default papersize, in fact, is set according to Locale. But I ran this test using ODS WORD and when I opened the .DOCX file with Word, the papersize showed as A4 inside WORD.

Here's my log and you can see the specific value I used for the PAPERSIZE option:

And here's the value for size in the Word drop down menu after the results are opened.

Running 9.4 M7 but on a Windows box. Also, check your printer drivers. The doc specifically says that "If you specify a predefined paper size or a custom size that is not supported by your printer, the printer default paper size is used." So that might be causing issues too.

Cynthia

Re: papersize=A4 did not work in ODS WORD in 9.4 M7 for linux 64

Jinlf — Tue, 29 Jun 2021 07:37:59 GMT

Thanks ! Your method is good, the papersize change to A4 using this codes:

options papersize= (21.0cm 29.7cm);

Re: papersize=A4 did not work in ODS WORD in 9.4 M7 for linux 64

lopohobby — Wed, 17 Aug 2022 03:22:46 GMT

options papersize='A4';