topic Re: Removing the page breaks after each PROC in ODS WORD in SAS Programming

Removing the page breaks after each PROC in ODS WORD

Emma_at_SAS — Wed, 14 Apr 2021 15:08:44 GMT

How may I remove the page breaks after each PROC?

I found this for ODS RTF but did not find a similar resource for ODS WORD

https://www.lexjansen.com/wuss/2014/51_Final_Paper_PDF.pdf

Thanks

Re: Removing the page breaks after each PROC in ODS WORD

ballardw — Wed, 14 Apr 2021 15:20:26 GMT

The first place to start would likely be the STARTPAGE setting in your ODS Word.

https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.4/odsug/p10mxeb6wxqfjgn1p5u0w4t8qf20.htm#p1moj1npfwwihsn1rfpvpmefbpcn

Set STARTPAGE=NO and page breaks shouldn't be added.

Lots of caveats though as Word is still preproduction which means that features can be a tad unpredictable.

If you really want the control then use ods rtf and then convert the rtf document to Word.

Re: Removing the page breaks after each PROC in ODS WORD

Emma_at_SAS — Wed, 14 Apr 2021 15:28:30 GMT

Thank you, ballardw.

That is it then! When I add: options(STARTPAGE="NO"), SAS gives me this warning message:

WARNING: Option "startpage" not recognized. This option will be ignored.
WARNING: The ODS WORD destination is preproduction in this release.

I will create RTF and then convert it to WORD.

Re: Removing the page breaks after each PROC in ODS WORD

Reeza — Wed, 14 Apr 2021 16:00:04 GMT

You really need to post your code in the future, it'll help us answer your questions faster.

Startpage is not listed under the options in the ODS WORD documentation so it doesn't go in the options parenthesis, it stays outside. This generates my file with no page breaks and a single page docx file with both tables.

ods word file='/home/fkhurshed/Demo1/example.docx' startpage=no ;

proc print data=sashelp.class (obs=3);
run;

proc print data=sashelp.air(obs=5);
run;

ods word close;

Note separate entries;

OPTIONS (< suboptions>)
Specify destination-specific suboptions

SASDATE
Insert the standard SAS date in the document in place of the default Word date and time field

SELECT selection(s) | ALL | NONE
Select output objects for the destination.

SHOW
Write to the SAS Log the current selection or exclusion list for the destination

STARTPAGE= YES | NO | NOW | BYGROUP
Control the insertion of new pages

@Emma_at_SAS wrote:

Thank you, ballardw.

That is it then! When I add: options(STARTPAGE="NO"), SAS gives me this warning message:

WARNING: Option "startpage" not recognized. This option will be ignored.
WARNING: The ODS WORD destination is preproduction in this release.

I will create RTF and then convert it to WORD.

Re: Removing the page breaks after each PROC in ODS WORD

Emma_at_SAS — Wed, 14 Apr 2021 16:18:04 GMT

Thanks, Reeza! Yes, that works!

I do not have the option to change/edit the solution for this question. This would be misleading for future visitors! Any suggestions for that?

Thanks

Re: Removing the page breaks after each PROC in ODS WORD

FreelanceReinh — Wed, 14 Apr 2021 16:41:53 GMT

@Emma_at_SAS wrote:

I do not have the option to change/edit the solution for this question.

Hello @Emma_at_SAS,

You can select a different post as the solution after clicking "Not the Solution" in the option menu (see icon below) of the current solution.

Re: Removing the page breaks after each PROC in ODS WORD

Emma_at_SAS — Wed, 14 Apr 2021 19:38:22 GMT

Thank you, FreelanceReinhard!

Re: Removing the page breaks after each PROC in ODS WORD

ErikDilts — Wed, 25 Aug 2021 19:10:44 GMT

I doubt this changes the solution (which is an imperfect one for me, as I'm limited to DDE for automation and can only save RTF as DOC and I really want DOCX), but this method fails as soon as the second table crosses a page break:

ods word file='example.docx' startpage=no ;

proc print data=sashelp.class (obs=3);
run;

proc print data=sashelp.gcstate(obs=35);
run;

ods word close;

My output from this, running SAS v9.4M6, puts the first table on page 1, an empty page 2, and the second table on pages 3 and 4.

Re: Removing the page breaks after each PROC in ODS WORD

Reeza — Wed, 25 Aug 2021 19:19:09 GMT

You're aware that ODS WORD is still pre-production?