topic ODS html output to excel is different in V9.2 in ODS and Base Reporting

ODS html output to excel is different in V9.2

damian_HMRC — Wed, 20 Jul 2011 09:43:40 GMT

Hi. We recently upgraded to SAS9 from SAS8 and some code I have is giving a different output, I am sure it is a simple thing to resolve but I cant find the answer anywhere and I was wondering if anybody could tell me what the solution is.

In SAS8 I use the following code

ods html path=' path ' (url=none)

body='test.xls'

style=minimal;

I then proc tabulate 20 tables

ods html close;

In SAS8 I get one excel spreadsheet called test.xls with 20 tables in a single sheet.

In SAS9 I get 20 excel spreadsheets called test1.xls test2.xls test3.xls etc, with a single table in each.

How do I get the output in SAS9 to be the same as I used to get in SAS8?

thanks in advance for any advice.

ODS html output to excel is different in V9.2

Andre — Wed, 20 Jul 2011 10:04:45 GMT

Damian i can't believe it as this code under 9.2.3 produce two results on one sheet in one spreadsheet! ods html path='d:\temp' (url=none) body='2ononesheet.xls' style=minimal; proc print data=sashelp.air;run; proc print data=sashelp.class;run; ods html close; Andre

ODS html output to excel is different in V9.2

damian_HMRC — Wed, 20 Jul 2011 10:30:58 GMT

Thanks. It must be something in the settings then.

ODS html output to excel is different in V9.2

damian_HMRC — Wed, 20 Jul 2011 14:28:01 GMT

I have just done a test: A colleague has run the same peice of code using the same SAS9 and gets a single spreadsheet output.

Proving that it must be something to do with my profile and not the sas code. Thanks for your help, it help me establish something.

Damian