Can I put the BY-group value into the ExcelXP sheet name?

[Cynthia_sas]

Here's what I'm wondering about -- related, but going further with the discussion. In the SAS title statement, you can use #byvar and #byval, etc with by group processing. ODS PROCLABEL does not currently support #byvar and #byval, but -if- it did, then you could kill 2 birds etc, etc, by allowing something like this:
[pre]
ods html ....;
ods tagsets.excelxp ...;
options nobyline;
ODS PROCLABEL "#byvar1 = #byval1";
proc whatever data=wombat;
by koala eucalyptus;
run;
ods _all_ close;
[/pre]
if ods html was using contents=, then every by group could use ODS PROCLABEL automatically without doing macro things to get the TOC label the way you wanted.

if excelxp was making multiple worksheets, then ODS PROCLABEL could indicate the string to be picked up by the tagset.

I know that Eric has done something similar in a tagset revision to answer a different question (for me, offline), but this possibility ODS PROCLABEL ...or a new ODS PROCBYLABEL might simplify things in making a one place to specify what you want using the #byval and #byvar that already exists and that folks know how to use.

Of course, changing a tagset is my favorite morning activity -- but it's not a solution for everybody -- and implementing the #byvar etc functionality via ODS PROCBYLABEL or ODS PROCLABEL -- would make it easier for folks new to SAS and ODS to do something slick with a much lower learning curve. If #byvar and #byval are put -someplace- so the title statement can get to them, why can't they be pumped into someplace in memory that persists beyond the life of the title statement???

just curious,
cynthia

[Eric_SAS]

I should mention that control templates allow for this sort of thing.
The set statement in control templates knows how to handle #byval and #byvar. I don't remember if I allow triggering tagset events from there... I probably should.

Connecting all the dots is probably the hard part.

It was so easy to do I added it to the set statement in tagsets as well. But not until 9.2.

[Cynthia_sas]

So what is a control template???? Something I'd have fun with???

[mrgibson]

Does the excelxp tagset 1.86 work correctly in SAS 9.2??

We have some code that was developed on SAS 9.13 using the tagset with sheet_interval set to by groups. Under 9.13 this created a new worksheet for each by group. But in 9.2 each by group are in the SAME worksheet listed below each other.

Has anyone experienced this? BTW the code is not mine so I am unable to give you specifics. If needed I can try and get a copy of the code, for now this is just a general query.

What other problems are you seeing with the tagset under 9.2?
Have you developed a newer version of the tagset for 9.2?