I'm using tagsets.excelxp to separate a large file into multiple files into an excel workbook.
The file is being separated according to two variables, one is Group and the second is Subgroup.
The groups form each worksheet and the subgroups form 5 different tables in each worksheet.
I'm printing a title for the page overall with the group name and then titles for the subgroups also using title statements.
However, sometimes a subgroup won't have any observations for group, so then the main title won't get printed to the spreadsheet. I've tried using ods text=
instead of title but it still doesn't show up.
Is there some other option I need to set?
My other solution is to create conditional statements on when to execute things but I was hoping to avoid that complexity because I don't want to be the one supporting the code.ee
Hi:
You might want to check with Tech Support, but I think this is standard behavior and there's no option to set.
cynthia
Thanks Cynthia, I'll give them a shout on Thursday then when I'm back in the office.
when there are no obs, you could create an "all-missing" obs
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 16. 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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: