topic how to page break in proc report in SAS Programming

how to page break in proc report

HitmonTran — Fri, 22 Jan 2021 03:54:30 GMT

Hi,

I need to do a page break for "Days/week at workplace".

current output:

data:

code:

  proc report data=final nowindows center headline headskip missing split='|';
    column   ord1 ord2    desc ;
    define ord1      / order order=internal noprint;
    define ord2      / order order=internal noprint;
    define desc     / display " " style(column)={asis=on just=left cellwidth=2 in} flow style(header)={just=left font_size=9pt};
   
    break after ord1 / skip;
    compute before ord1 / style(lines)={font_size = 3pt};
      line " "; 
    endcomp; 
  run;

Re: how to page break in proc report

Ksharp — Fri, 22 Jan 2021 11:48:48 GMT

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

Re: how to page break in proc report

Ksharp — Fri, 22 Jan 2021 12:01:08 GMT

data cars;
set sashelp.cars;
keep _character_;
run;
proc sql;
create table have as
select *,count(*) as n
 from cars
  group by make;
quit;
data have;
 set have;
 by make;
 if first.make then do;
   cum+n;
   if cum>30 then do;p+1;cum=n;end;    /*a page have 30 rows*/
 end;
 drop cum n;
run;

ods rtf file='c:\temp\x.rtf' style=journal;
proc report data=have nowd;
column _all_;
define p/group noprint;
break after p/page;
run;
ods rtf close;