Getting a ods text= to work in tagsets.excelxp

[Reeza]

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

[Cynthia_sas]

Hi:

  You might want to check with Tech Support, but I think this is standard behavior and there's no option to set.

cynthia

[Reeza]

Thanks Cynthia, I'll give them a shout on Thursday then when I'm back in the office.

[Peter_C]

when there are no obs, you could create an "all-missing" obs