BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
twildone
Pyrite | Level 9

Hi.....I am using ods pdf to create a report and trying to insert a Page X of Y in the footnote. The output isn't correct. Any suggestions to correct this? Thanks.

 

Code:

 

ods pdf file="%sysfunc(pathname(project))\&filename Report (&rundate).pdf" style=journal notoc bookmarkgen=no bookmarklist=none;

footnote height=7pt font="Arial" justify=center "Report Generated On: &rundate" justify=right 'Page ^{thispage} of ^{lastpage}';

 

Output:

<R Page 1 of 􀀀@ 􀀀>

1 ACCEPTED SOLUTION

Accepted Solutions
Cynthia_sas
SAS Super FREQ
Hi:
If this is something you can reliably duplicate using EG, then you should open a track with Tech Support. If there's an existing defect, they will let you know and if there is a defect, there might be workaround. Sending them a sample program will help. So you can point them to this track for an example of code that works in SAS 9.4 and then send them an example of the same code that does not work in EG.

cynthia

View solution in original post

4 REPLIES 4
Cynthia_sas
SAS Super FREQ

Hi:

  I do not observe that behavior. I am running SAS 9.4 M3. When I use a slightly modified version of your code, I get the expected results. BTW, I never just use the font Arial with ODS PDF -- one of the developers explained that the only "Arial" font that Adobe "likes" is Arial Unicode MS and so, that is the one I always use.

 

cynthia

 

x_of_y_test.png

twildone
Pyrite | Level 9
Hi Cynthia....I have been working on this to try an narrow down or identify why this is occurring. I was able to determine that it has to do with when the code is run using Enterprise Guide. It works when I use SAS 9.4 BUT doesn't work when the code is run using SAS Enterprise Guide 7.1
Cynthia_sas
SAS Super FREQ
Hi:
If this is something you can reliably duplicate using EG, then you should open a track with Tech Support. If there's an existing defect, they will let you know and if there is a defect, there might be workaround. Sending them a sample program will help. So you can point them to this track for an example of code that works in SAS 9.4 and then send them an example of the same code that does not work in EG.

cynthia
twildone
Pyrite | Level 9

Hi Cynthia....I did contact Tech Support and the work around is to include the following statement:

 

options printerpath=pdf;

 

before the ODS pdf file=

 

TYhanks for your help.

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 4 replies
  • 1371 views
  • 3 likes
  • 2 in conversation