Stata The Stata listserver
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

st: RE: Saving tables


From   "Nick Cox" <n.j.cox@durham.ac.uk>
To   <statalist@hsphsun2.harvard.edu>
Subject   st: RE: Saving tables
Date   Fri, 8 Nov 2002 13:20:50 -0000

Chris.Fergusson@sth.nhs.uk
> 
> 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 
n.j.cox@durham.ac.uk 
*
*   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/



© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index