Tagsets.excelxp Error (9.3)

[wcpatton]

Real data is a delinquency trend report by portfolio and monthend.

First row is 13 monthends, then 6 rows of delinquency bucket.  This is done for both balance and column percent of balance for a series of portfolios.

tables (portfolio='') *(balance = "balance" *sum='' balance = "rate" *colpctsum<total>='') , (delqbucket=''), (monthend = '')

something like that.

[wcpatton]

msoffice2k and xls got me the output I want, but the SASWEB style looks much different with this output.  Primarily, the title repeats every page break, which makes it look terrible.  I'm actually surprised that SASWEB style looks different just based on the output technique.  Also, with this setup, the options PAGES_FITWIDTH="1" FitToPages="YES" don't work anymore.

[Cynthia_sas]

Hi:

  If you notice, I didn't have a TITLE statement in my report for that reason, but did use PRINT_HEADER with TAGSETS.MSOFFICE2K_X and the suboption for "fit to page" is fittopage='yes'.

cynthia

[wcpatton]

Yeah, this gets me an output, but not the same one.  Given that these reports are standardized, I'm going to have to advise my office to not upgrade until SAS can actually fix this problem rather than just suggesting that the end user needs to fix it for themselves.

Lesson 1: Don't break what isn't broken.