The BY statement variable directives can be used in many places other than TITLE statement where they were first introduced.
I wrote some code (some sort of macro thing) where a variable can contain #byval(variable) and I replace that with the BY value using VVALUEX, and TRANSTRN etc. Of course I could have used another syntax but I don't like to invent my own, where there exists a perfectly good one.
Seems like there should be a way to use what has already been done by SAS to support this kind of replacement, I was thinking a function might exist but did not find one.
I'm not as familiar with this as I should be, but ...
I would imagine that ODS templates can take care of this.
Hi:
ODS DOCUMENT has some automatic variables and I know that TAGSETS.EXCELXP has implemented some BY group support for #BYVAL/#BYVAR/#BYLINE, but as far as I know, it is only documented here in the TITLE statement: SAS(R) 9.4 Statements: Reference, Second Edition -- so your approach of using VVALUEX, etc might be the most flexible.
cynthia
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.