Date:         Fri, 24 Aug 2007 20:25:47 -0000
Reply-To:     sanrou <jindan@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         sanrou <jindan@GMAIL.COM>
Organization: http://groups.google.com
Subject:      Question on running simulation study with SAS (Using ODS)
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset="iso-8859-1"

I am running a simulation type study with SAS. PHREG procedure is
performed on some hundreds of dataset. I managed to use SAS ODS to
produce an Excel file that contains the only table I need for follow
up computations, an sample output would look like:

                             PWP-GAP TIME
SUMMARY                            1
                                               23:14 Thursday, August
23, 2007

                             The PHREG Procedure

                   Analysis of Maximum Likelihood Estimates

                  Parameter     Standard
Hazard
 Variable   DF     Estimate        Error   Chi-Square   Pr >
ChiSq      Ratio

 CLASS1      1      2.29375      0.40505      32.0685       <.
0001      9.912
 CLASS2      1      2.22387      0.42252      27.7035       <.
0001      9.243
 CLASS3      1      1.95692      0.43109      20.6070       <.
0001      7.078
 CLASS4      1      3.20469      0.65672      23.8125       <.0001
24.648
 CLASS5      1      2.23503      0.50084      19.9146       <.
0001      9.347
 CLASS6      1      2.80052      0.79680      12.3531       0.0004
16.453
 CLASS7      1      2.47812      0.79632       9.6844       0.0019
11.919
 CLASS8      1      1.88125      0.70294       7.1624
0.0074      6.562
 CLASS9      1      1.74099      0.82379       4.4664
0.0346      5.703
 CLASS10     1      0.84553      1.16342       0.5282
0.4674      2.329

Is it possible to let ODS strip off everything but only store the
column name "Parameter Estimate" in the Excel file? That would
simplify my follow up computations works in Excel.

Thanks,

Jindan