Wide PROC REPORT and Page Numbering

craig159753 — Tue, 13 Sep 2022 07:48:25 GMT

Hi,

I have a trivial question, considering the following dataset (MY_DATASET):

/*
Variable1 | Variable2 | Variable3 | Variable4 | Variable5 | Page | PageNumbering |

----------------------------------------------------------------------------------

xxxx1     | AAAAA     | YY        | LLL       | W         | 1    | Page 1 of 8   |
xxxx2     | AA        | YYY       | LLLLLL    | WWWWWWWW  | 1    | Page 1 of 8   |
xxxx3     | AAA       |           | L         | WWW       | 1    | Page 1 of 8   |
xxxx4     | AAAAA     | YY        | LLL       | W         | 2    | Page 2 of 8   |
xxxx5     | AA        | YYY       | LLLLLL    | WWWWWWWW  | 2    | Page 2 of 8   |
xxxx6     | AAA       |           | L         | WWW       | 2    | Page 2 of 8   |
...
*/

Consider the following PROC REPORT code:

proc report data=my_dataset headline nowd split="@" missing spacing=1;
  column variable1 variable2 variable3 variable4 variable5;
  by page;

  %* ID Variable(s);
  define variable1 / order order=internal id;
  %* Page 1;
  define variable2 / display;
  define variable3 / display;
  %* Page 2;
  define variable4 / display;
  define variable5 / display;

  compute before _page_;
    line @1 pagenumbering $200.;
  encomp;
run;

Note: the code will produce an ODS RTF output. I have left this code off for simplicity.

As you can see, the code above will produce a "wide" PROC REPORT. What I mean by this, the output will produce two pages for every value of the PAGE variable:

Page 1 of x

Page=1

PageNumbering=Page 1 of 8

Variable1 Variable2 Variable3

Page 2 of x

Page=1

PageNumbering=Page 1 of 8

Variable1 Variable4 Variable5

Variable1 being the ID variable appearing on all pages.
Variable2 and Variable3 appearing on the first page.
Variable4 and Variable5 appearing on the second page.

The Issue:

The current code will print a line of text above the table on each page via the COMPUTE block. However, as the output is wide the page numbering is repeating, and I know why, but I was curious is there a nice solution, that I do not know about, which will give me the correct page numbering per page.

Page 1 of 16

Variable1 Variable2 Variable3

Page 2 of 16

Variable1 Variable4 Variable5

Notice the Pagenumbering variable has changed 8 to 16 (due to there are technically 2 pages per page as the output is wide) and that the page number is counting correctly. Note, I have created two new PageNumbering variables, so I have these at my disposal too:

/*
Variable1 | Variable2 | Variable3 | Variable4 | Variable5 | Page | PageNumbering | PageNumbering1 | PageNumbering2 |
-------------------------------------------------------------------------------------------------------------------------
xxxx1     | AAAAA     | YY        | LLL       | W         | 1    | Page 1 of 8   | Page 1 of 16   | Page 2 of 16   |
xxxx2     | AA        | YYY       | LLLLLL    | WWWWWWWW  | 1    | Page 1 of 8   | Page 1 of 16   | Page 2 of 16   |
xxxx3     | AAA       |           | L         | WWW       | 1    | Page 1 of 8   | Page 1 of 16   | Page 2 of 16   |
xxxx4     | AAAAA     | YY        | LLL       | W         | 2    | Page 2 of 8   | Page 3 of 16   | Page 4 of 16   |
xxxx5     | AA        | YYY       | LLLLLL    | WWWWWWWW  | 2    | Page 2 of 8   | Page 3 of 16   | Page 4 of 16   |
xxxx6     | AAA       |           | L         | WWW       | 2    | Page 2 of 8   | Page 3 of 16   | Page 4 of 16   |
... */

So Variable2 and Variable3 would use PageNumbering1 and Variable4 and Variable5 would use PageNumbering2.

Things I have already tried (some work):

Looping the PROC REPORT per page (works but very slow on large datasets)
Using the ODS RTF ^{this page} stuff (works but when I combine outputs the page numbering is linked to the entire document and not the output itself).

Any thoughts welcome.

topic Re: Wide PROC REPORT and Page Numbering in SAS Programming

Wide PROC REPORT and Page Numbering

Re: Wide PROC REPORT and Page Numbering