The SAS Output Delivery System and reporting techniques

ODS html output to excel is different in V9.2

Reply
New Contributor
Posts: 4

ODS html output to excel is different in V9.2

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.

Super Contributor
Posts: 273

ODS html output to excel is different in V9.2

Posted in reply to damian_HMRC

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

New Contributor
Posts: 4

ODS html output to excel is different in V9.2

Thanks. It must be something in the settings then.

New Contributor
Posts: 4

ODS html output to excel is different in V9.2

Posted in reply to damian_HMRC

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

Ask a Question
Discussion stats
  • 3 replies
  • 191 views
  • 3 likes
  • 2 in conversation