topic Re: proc report (break across pages) in SAS Programming

proc report (break across pages)

Konstantin123 — Tue, 05 Apr 2016 13:25:23 GMT

I have output (proc report):
1obs 1 First_row
2 Second_row
3 Third_row

2obs 1 First_row
2 Second_row
3 Third_row

.
.

nobs 1 First_row

2 Second_row
3 Third_row
It is necessary to take measures to three lines with the data of one observation does not break across pages.
(options linesize=90 pagesize=40)

Re: proc report (break across pages)

RW9 — Tue, 05 Apr 2016 14:40:50 GMT

If your question is how to put a page break in at a set point of your output, then the simple answer is this. Have a datastep before the report procedure, that processes your data and adds a page variable in. Then break on that page variable, e.g.:

data have;
  set have;
  if _n_ <= 9 then pge=1;  /* First 9 observations, based on 2 per section */
  else pge=2;  /* the other 9 */
run;

proc report data=have;
  columns _all_;
  define pge / noprint order;
  define...;
  
  break after pge / page;
run;

Re: proc report (break across pages)

Ksharp — Wed, 06 Apr 2016 01:58:04 GMT

http://support.sas.com/resources/papers/proceedings12/389-2012.pdf