Hi: I rarely look in this forum, since I mainly teach the ODS and Base Reporting classes, along with the stored process classes. However, you posted a similar question in a different forum and I posted a response over there with some sample code. Please look at the use of SHEET_NAME='NONE' that I posted here: https://communities.sas.com/t5/ODS-and-Base-Reporting/Display-All-BY-groups-in-same-ODS-EXCEL/m-p/320112#U320112 which shows how to do what I think you want to do. The BY group is age based on SASHELP.CLASS. If you want the title to reflect the name of the BY group, you need to use #BYVAL in the TITLE statement. However, the titles will not show in the sheet unless you use the embedded_titles='yes' suboption. I am still not convinced you need a macro solution, since it is possible to do everything you seem to want with suboptions and BY group processing.
cynthia
... View more