I'm not exactly sure what you mean. For example, if you are using ODS HTML, there are no page number tags defined in the HTML specification -- so there's no way to have page numbers in an ODS HTML document.
On the other hand, ODS RTF and ODS PDF are "paged" destinations -- so report output sent to those destinations would have the possibility of page numbers, however, the page number belongs to the "page" -- and as such, would not be appropriate to have a page number -inside- a graph image or a page number -inside- a report table.
However, there is a STARTPAGE=NOW option (for RTF and PDF) that allows you to instruct ODS to insert an explicit page break into report output. STARTPAGE=NOW could only be specified between procedure steps ---- it would not be appropriate to have the command anyplace but between procedures.
For me, the code below produces a 2 page document with a page break before the PROC MEANS output.
options nodate number pageno=1 center;
ods rtf file='c:\temp\use_sp.rtf' startpage=no;
ods pdf file='c:\temp\use_sp.pdf' startpage=no;
proc print data=sashelp.class(obs=3);
proc freq data=sashelp.class;
proc print data=sashelp.cars(obs=3);
var Make Model Type Origin DriveTrain MSRP Invoice;