I am not really sure about what exactly you mean "But unfortunately when we have several tables pagination retains consecutive." I have produced enough reports with the same code and had never been problem with several hundred pages. May be you can elaborate more I am sure there is solution to your case. ... View more

Please try below code after your PROC TEMPLATE . I edited your code by commenting and replacing with few changes.     ods rtf file = "Actual_result.rtf" style = MyStyleRTF; options orientation = landscape; /*ods startpage = yes; */ /*title1 j = r '{Page \field{\*\fldinst { PAGE \\* MERGEFORMAT }}} of {\field{\*\fldinst SECTIONPAGES \* MERGEFORMAT }}';*/ title1 j = r '{Page \field {\*\fldinst PAGE \\*MERGEFORMAT}} {of \field {\*\fldinst NUMPAGES \\*MERGEFORMAT}}'; /*ods rtf sectiondata="\pgnrestart\pgnstarts1";*/ proc report data = sashelp.class; define sex / order; break after sex / page; run; ods rtf close;   ... View more

Try changing dbms statement as :    dbms= xlsx REPLACE ;  ... View more