topic How to prevent SAS report row to break across pages? in SAS Programming

How to prevent SAS report row to break across pages?

whymath — Tue, 20 Feb 2024 01:56:11 GMT

I am trying to report a variable with very long content:

data test;
  length text $32767.;
  text=repeat('This is a piece of very looooong text',200);
run;

option nodate nonumber;
title;
ods rtf file='test.rtf' style=minimal;
proc report data=test;
run;
ods rtf close;

The report just look like this:

...

The content is too long to be showed in one page, so it takes break across pages.

When I open this RTF file in WORD software, I choose "Layout" → "Properties" → "Row", then check "Allow row to break across pages", the break just be removed:

...

How do you think about this? Can "Allow row to break across pages" be done with SAS?

Re: How to prevent SAS report row to break across pages?

SASJedi — Tue, 20 Feb 2024 12:49:18 GMT

If you are producing a Word document, consider using ODS WORD instead of RTF. The ODS WORD suboption CANT_SPLIT controls the "Allow row to break across pages" behavior:

data test;
  length text $32767.;
  text=repeat('This is a piece of very looooong text',200);
run;

option nodate nonumber;
title;
ods word file='test.docx' style=minimal options (CANT_SPLIT='OFF');
proc report data=test;
run;
ods word close;

Re: How to prevent SAS report row to break across pages?

whymath — Wed, 21 Feb 2024 06:29:48 GMT

Thank you very much Jedi, ODS WORD works but perhaps I cann't use it in dev enviroment, beacause log window report "WARNING: The ODS WORD destination is preproduction in this release." and we don't allow warning messages in log.

Re: How to prevent SAS report row to break across pages?

andreas_lds — Wed, 21 Feb 2024 06:47:26 GMT

Even in 9.4m8 ods word is pre-production, does anyone know when it will become fully usable?

Re: How to prevent SAS report row to break across pages?

ballardw — Wed, 21 Feb 2024 10:26:40 GMT

One might ask just why you have so much text in Proc Report.

The procedure is designed to create grouped summary reports. That much text seems more appropriate for Proc Print, maybe.

Note that pagination is not a trivial topic when trying to dump large amounts of text into a table. The report table width, page size definition, ODS destination options, margins, font size as a minimum interact in determining where a "column" of a table would attempt to break.

Perhaps more a real use instead of one made up value would give us some clues for alternate approaches.

Re: How to prevent SAS report row to break across pages?

SASJedi — Thu, 22 Feb 2024 12:43:05 GMT

ODS WORD is no longer pre-production in Viya LTS 2022.09.