So far, my options have been to either output the date as a number for excel to read (you have to add something, like 21000 to it), or to use a picture format and output it as text and then excel won't recognize it as a date, but at least it will look like one. ... View more

This is still not answered and still happens too often.     ... View more

bump ... View more

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. ... View more

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. ... View more

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. ... View more

That already came up in this thread.  It "fixes" the error message in that it allows the output, but it causes other problems. ... View more

If anyone has an alternative to excelxp and xml, that maybe works? ... View more

Yeah, that is odd.  9.3 is the first time I've been disappointed like this by SAS. ... View more

Oh!  And my first row is hidden! ... View more

Thanks Cynthia.  That gets me in the right direction, but now my spreadsheet style is very broken.  No longer fits the pages and my column\row widths and lengths are all wrong. ... View more

Here's a sample code that works with my coworkers 9.2, but gives excel errors on 9.3 ods tagsets.excelxp  file="c:\junk.xml"     style=sasweb   options (SHEET_INTERVAL="NONE"   absolute_column_width = '14,6.5,6.5,6.5,6.5,6.5,6.5,6.5,6.5,6.5,6.5,6.5,6.5,6.5,6.5'   embedded_titles='no'   PAGES_FITWIDTH="1" FitToPages="YES"   orientation='Landscape'); ods tagsets.excelxp options (Sheet_Name = "Portfolio"); title'Delinquency Trends by Portfolio';*/; proc tabulate data=sashelp.class missing; class name sex age; var height weight;    tables  (name='')*(    height = "height" *mean='' *f=comma24.0    weight = "weight" *mean='' *f=comma24.0 ),(sex='') ,(age='') / box = '' row=float; run; ods _all_ close;title; ... View more