The SAS Output Delivery System and reporting techniques

Getting a ods text= to work in tagsets.excelxp

Reply
Super User
Posts: 18,997

Getting a ods text= to work in tagsets.excelxp

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

SAS Super FREQ
Posts: 8,814

Re: Getting a ods text= to work in tagsets.excelxp

Hi:

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

cynthia

Super User
Posts: 18,997

Re: Getting a ods text= to work in tagsets.excelxp

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

Valued Guide
Posts: 2,177

Re: Getting a ods text= to work in tagsets.excelxp

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

Ask a Question
Discussion stats
  • 3 replies
  • 188 views
  • 3 likes
  • 3 in conversation