Hi,
I was hoping sas community will pitch in to help me solve this problem.
Aim: 1. insert a page break on reaching the max records allowed on 1 page
2. insert a page break on change of group number i.e every new group data appears on new page
sample data:
_N_ GroupNo PageNo(expectedResult)
1 1 1
2 1 1
3 1 1
4 1 1
--------------------------------------------------------(this line is NOT the part of data)
5 1 2
6 1 2
-------------------------------------------------------(this line is NOT the part of data)
7 2 3
8 2 3
9 2 3
10 2 3
-----------------------------------------------------(this line is NOT the part of data)
11 2 4
12 2 4
13 2 4
In the above example:
max records on 1 page = 4
Currently, this is the code I have written (that does not work as I want it to)
data paging;
retain recbrk_ 1;
retain maxRecords 4;
if(mod(_N_,maxRecords) eq 1 or first.groupno) then recbrk_ = recbrk_ + 1;
run;
proc report....
...
break after recbrk_/ page;
....
run;
output i get :
_N_ GroupNo recbrk_
1 1 1
2 1 1
3 1 1
4 1 1
--------------------------------------------------------(this line is NOT the part of data)
5 1 2
6 1 2
-------------------------------------------------------(this line is NOT the part of data)
7 2 3
-------------------------------------------------------(this line is NOT the part of data)
8 2 4
9 2 4
10 2 4
11 2 4
-----------------------------------------------------(this line is NOT the part of data)
12 2 5
13 2 5
Any suggestions / comments will be helpful.Thank you in advance !
Poonam
