I want to output the by goups in the following to the same sheet (in EXCEL) using the EXCELXP tagset. I want to display the byline on the row about each new by group (like Year = 2006 Procedure_sort = A).
The following code works if I use the suppress_bylines = "yes" and in that case the byline is blank.
There are some other ODS destinations that you can use in stored processes, but they are mostly HTML based, such as PHTML, CHTML or MSOFFICE2K.
Normally, you cannot use TAGSETS.EXCELXP as an override to _ODSDEST -- excpet in the Information Deliver Portal. The type of XML created by TAGSETS.EXCELXP is not compatible with the Enterprise Intelligence Platform. In SAS 9.1.3, I did test TAGSETS.EXCELXP with the SAS Enterprise Intelligence Platform and the only client applications where you can use TAGSETS.EXCELXP are the Information Delivery Portal and/or SAS Enterprise Guide. (And, if you use TAGSETS.EXCELXP with SAS Enterprise Guide, you cannot open the Spreadsheet Markup Language XML file inside of EG in EG 4.1.)
I suggest you either search previous forum postings for more information about how to make this work in the Information Deliver Portal or work with Tech Support on this issue.