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