My BY variable is PAGE and I want to display Page 1, Page 2 etc. using and ENTRYFOOTNOTE.
I tried this which compiles
entryfootnote halign=right textattrs=(style=normal size=_footnotefontsize) eval(put("Page "||put(page,1.)||" of 2",$12.));
but generates the following NOTE and no output.
An expression used in a text statement resolves to a column. It must resolve to a constant. The expression will be ignored.
Hi,
Simplifying it, you can you _byval_ to output the page number, you also need to add _byval_ to the dynamic statement too.
Of the top of my head, this may work:
entryfootnote halign=right textattrs=(style=normal size=_footnotefontsize) "Page " _byval_ " of 2";
This bit:
eval(put("Page "||put(page,1.)||" of 2",$12.));
Does not look right to me, the put() function takes characters and makes numbers, but in the above it is putting text to text? Have you tried:
eval(cat("Page ",put(page,1.)," of 2");
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
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.
Ready to level-up your skills? Choose your own adventure.