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");
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.