topic Re: Page X of Y in ODS and Base Reporting

Page X of Y

deleted_user — Fri, 08 Feb 2008 07:00:37 GMT

HI
can anyone tell me the best way to get page x of y while using Proc report with Pdf Output.
thanks

Re: Page X of Y

deleted_user — Fri, 08 Feb 2008 11:52:19 GMT

There are multiple SAS Conference papers on this that you'll find by looking on the SAS Support web site.

Re: Page X of Y

Lex_SAS — Fri, 08 Feb 2008 15:58:37 GMT

To be more specific:
go to www.lexjansen.com and search: "page x of y" pdf
This will give you a lot of SAS proceedings that answer your question.

Lex Jansen

Re: Page X of Y

BrunoSilva — Wed, 27 Feb 2008 21:26:38 GMT

I think is this that you want:

footnote1 j=right height=1 "Page ^{thispage} of ^{lastpage}";

Re: Page X of Y

Cynthia_sas — Thu, 28 Feb 2008 01:23:26 GMT

Hi:
In order for the footnote statement to work, you must declare what the ODS ESCAPECHAR value is. ODS ESCAPECHAR is the special character that lets ODS know that you want to do something special (like use the {thispage} and/or {lastpage} Escapechar functions. Something along the lines of:
[pre]
ods pdf file='wombat.pdf';
ods escapechar='^';

footnote1 j=right height=1 "Page ^{thispage} of ^{lastpage}";
.... more code ....
ods pdf close;
[/pre]

Generally, I recommend the use of ~ (tilde) or ^ (caret) or # (sharp/pound sign) for the Escape character, because you are unlikely to have them in a title or footnote text. Or conversely, avoid any punctuation that you might find in an operating system path or title text or urls or email addresses, such as : \ / ; ! @ $ % & * < > (not a comprehensive list of all punctuation that I avoid). Mostly I use ~ or ^ or #.

cynthia