Date:         Tue, 8 Sep 2009 18:07:29 -0600
Reply-To:     Ken Barz <zrab123@COMCAST.NET>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Ken Barz <zrab123@COMCAST.NET>
Subject:      Re: ODS question
Comments: To: df ss <tggsun@YAHOO.COM>
In-Reply-To:  <364293.26864.qm@web50301.mail.re2.yahoo.com>
Content-Type: text/plain; format=flowed; charset="iso-8859-1";
              reply-type=original

You can let ods do some of the work to get the output into datasets, then go
to Excel using Proc Export or an Access engine or...

ods trace on;
proc corr data=sashelp.class;
  var height weight;
run;
ods trace off;
*** Shows three possible tables in the log:  varinformation, simplestats and
pearsoncorr using this configuration of proc corr ***;

ods listing close;
ods select all;
ods output simplestats(persist=proc)=simpout;
ods output pearsoncorr(persist=proc)=corrout;
proc corr data=sashelp.class;
  var height weight;
run;
ods _all_ close;
ods listing;



----- Original Message -----
From: "df ss" <tggsun@YAHOO.COM>
To: <SAS-L@LISTSERV.UGA.EDU>
Sent: Tuesday, September 08, 2009 11:08 AM
Subject: ODS question


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