[email protected]
>
> I run a do-file which calls and uses the ado file strel.
> This produces a
> table in the output window as follows:
>
> ************************************************************
> ****************
> *****************************
>
> Count of subjects 22826 Count of deaths 18415
> NO GROUPING REQUIRED
>
> Table of crude and relative survival probabilities
> (expressed as percentages with 95% confidence intervals)
>
> start end deaths alpha Crude Cr_lo Cr_up RelS Re_lo
> Re_up I
> 0.00 0.15 4364 1.3806 80.37 79.84 80.88 81.29 80.76
> 81.81 .
< snip >
> 9.00 10.00 313 0.0083 19.19 18.68 19.70 32.60 31.80
> 33.39 .
>
> ************************************************************
> ****************
> **********************************
>
> >From this table I only need to look at several rows of
> data, and it would be
> most useful to transfer these rows of data to excel.
>
> Thus would it be possible to clear what is in the current
> datasheet and then
> insert the table into the sheet so each table column
> becomes a variable in
> the datasheet.
>
This is very difficult to answer with any precision.
I can't comment on the do file, not given here, but the kind of
functionality you want might be made easier by converting
it to a program able to accept -if- and -in- restrictions.
Alternatively, write results to a file and use the
facilities of a good text editor or scripting language.
The last part I do not understand at all. What is a datasheet
in Stata terms? Do you want to manipulate data, or tables
of data, in Stata or in Excel?
Nick
[email protected]
*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/