Date:         Tue, 8 Sep 2009 23:17:34 -0400
Reply-To:     Arthur Tabachneck <art297@NETSCAPE.NET>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Arthur Tabachneck <art297@NETSCAPE.NET>
Subject:      Re: ODS question
Comments: To: tggsun@YAHOO.COM
Content-Type: text/plain; charset=ISO-8859-1

It appears to be a bug, but you can get around it by specifying ods html3.
I.e.,

ods html3 file="c:\try.xls";
proc corr data=try;
var a b;
run;
ods html close;

HTH,
Art
--------
On Tue, 8 Sep 2009 10:08:35 -0700, df ss <tggsun@YAHOO.COM> wrote:

>Hello SASor,
I wrote the following code:
ods html file="c:\try.xls";
proc corr data=try;
var a b;
run;
ods html close;
And hope to get Simple Statistics and corrlation table in a excel file.
But I got Simple Statistics table only. There is first line only in
corrlation table.�I can get the�results form SAS output window very well.
Is there possible to get the ODS output into excel file?

This code was working at SAS 9.0 at Windows XP system. But doesn't work
correctly at SAS 9.13 SP4.

Thank you,

dd sf