Hi , I have been trying to output a data with several groups into a single PDF which has several group IDs. I need to print the data by group ID and also everytime group ID changes , page should start at page 1. I need a foot note as page 1 of 10 where 10 is the last page of that group in group ID and not the total number of pages in PDF. I used page ~{startpage} of ~{lastpage} in the footnte where ~ is escapechar and options pageno=1 before proc report. this gives me page numebr 1 at the start of each group but last page gives me the total number of pages in PDF instead of last page of that particular group. for example: group1 - I need footnote page 1 of 10, 2 of 10 etc.. if there are 10 pages in that group. group2 - foot note must be 1 of 5, 2of 5 etc.. if there are 5 pages in group2. But what I am getting right now is page 1 of 15, 2of 15 etc.. for group1 and when group2 starts it is page 1 of 15, 2of 15 etc... I have attached my sample output in PDF and sas code in txt file. Appreciate your inputs.
... View more