07-20-2011 05:43 AM
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)
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.
07-20-2011 06:04 AM
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
07-20-2011 10:28 AM
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.