I try to forget some of it between working on it. It is a monster of a tagset. ... View more

Thanks. I'll take a look. I just used this the other day so I'm surprised it's not working. ... View more

Currently a macro variable is going to give you the best results. It's the only thing dynamic enough to change at any point in time. I guess we could do a tagattr value on the table style. That might be better. The style over-ride could change for each by value. I'm not sure you can do that though. Can we do a compute before a table or after a by? ... View more

I don't see a way to do an attachment. I can send you the tagset if you email me. Here's the piece of code I changed in the worksheet_label event. I think it will give you just what you want. else /if cmp($sheet_interval, 'bygroup'); do /if ^$byval_name; do /if $sheet_label; set $worksheetName $label ' ' $byGroupLabel; else; set $worksheetName 'By ' ; set $worksheetName $worksheetName $numberOfWorksheets ' ' $byGroupLabel; done; else; do /if $sheet_label; set $sheet_label $last_byval; else; set $worksheetName $worksheetName $byval_name '=' $last_byval; done; done; ... View more

Yes. If you are targeting any version of Excel previous to 2002 you are stuck with DDE, HTML, CSV, or some combination. Maybe even external data. Excel creates so much work for us. I guess that's a good thing. ... View more

The tagset inherits from the htmlcss tagset. The clue is the parent = tagsets.htmlcss; This tagset gets most of it's abilities there. It only adds the bit of XML in the header. HTMLcss is one of the core html tagsets used by all the higher level html tagsets. ... View more

Here's what the doc says. Sheet_Label: Default Value 'None' Values: Any String"; This option is used in combination with the various worksheet naming. heuristics which are based on the sheet interval. This string will be used as the first part of the name instead of the predefined string it would normally use. These are the defaults: 'Proc ' total_Proc_count - label 'Page ' total_page_count - label 'By ' numberOfWorksheets byGroupLabel - label 'Table ' numberOfWorksheets - label If sheet interval is bygroup, the worksheet name will be Just the byvar = byval If I understand you correctly what you would really like is this label byval Correct? I can get a tagset to you today if you like. ... View more

I should also mention that over riding that worksheet_label event would also allow you to change the way the sheet_label option works. Let me know if you have any idea's about how to make it better. ... View more

That tagset does not generate XML. It is HTML. You are importing HTML files into Excel when you use the output created by that tagset. The quality of what you get in your worksheet is entirely dependendent upon Excel's ability to import HTML. That tagset does add some microsoft specific xml to the head section of the HTML. That is the extent of the XML that is in use. It is really HTML not XML. It does not come close to resembling the Excelxp tagset we use to create SpreadsheetML XML for Excel. ... View more

You need an up to date tagset. That will give you what you want. I know you know the url... http://support.sas.com/rnd/base/topics/odsmarkup/ If you still are not happy you can create your own way of auto naming by over riding the worksheet_label event. That event's only purpose is to create the sheet name. define tagset tagsets.excel; parent = tagsets.excelxp; define event worksheet_label; ..... end; end; But the current tagset and probably any tagset created in the last few months will name the worksheet Sex=F and Sex=M. But it only does that if the sheet_interval is bygroup. Maybe that naming scheme is wrong. I'm not sure. I just tried to guess at what made sense. ... View more

Sure. Just tell it that is the sheet_interval you want. ods tagsets.exelxp options(sheet_interval='bygroup') That will give you one worksheet per bygroup. The sheet name in this case will be something like Sex=M If you had by sex age It would still have the same sheet name but there would be two tables per sheet. ... View more

He did say he wanted to use his templates. Of course if you don't want to use the templates then using the Excelxp tagset to recreate the workbooks is a perfectly good solution. It's a better solution than DDE. Far less klunky. If you truly want DDE there is a DDE tagset that can also be used. It's better than having a custom data step for every piece of data. ... View more

How about using the ODS tagsets.Excelxp destination? It's been around since SAS 9.0. It works best with SAS 9.1.3. You can get the latest version here. http://support.sas.com/rnd/base/topics/odsmarkup/ Not a stretch at all... ... View more

The easiest way would be to use ODS CSV. Then link the template to the external CSV file with the external data menu option on the worksheet. From then on, if the CSV updates anyone reading the template will be notified and the worksheet will update if they want it to. ... View more

It would be fairly easy to adapt that macro code to work within a tagset. An event with the same functionality of the macro could recursively trigger itself when a directory is found. I seem to recall that the maximum recursion depth is 200. That should be plenty deep enough. There are various examples of using data step functions in tagsets at http://support.sas.com/rnd/base/topics/odsmarkup/tagsets.html Here's an example of recursion in a tagset. /*---------------------------------------------------------------eric-*/ /*-- Recursion limit is 200. If the limit is hit it will unwind --*/ /*-- automatically. --*/ /*------------------------------------------------------------12Feb03-*/ proc template; define tagset tagsets.test; define event doc; set $count 1; trigger loop; put "Count: " $count nl; end; define event loop; put "Count: " $count nl; putlog "Count: " $count; eval $count $count+1; trigger loop /if $count<100; eval $count $count-1; put "Unwind:" $count nl; putlog "Unwind:" $count; end; end; run; ods tagsets.test file="recurse.txt"; ods _all_ close; ... View more