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

st: Output to Excel


From   <christopher@fergusson030481.freeserve.co.uk>
To   statalist@hsphsun2.harvard.edu
Subject   st: Output to Excel
Date   Tue, 13 Aug 2002 11:09:12 +0000

Hello statalisters,

I have a do file which produces a matrix that looks like the following:

. matrix list cruderates

cruderates[16,2]
          year  cruderate
 r1       1985   81.92156
 r2       1986  98.751156
 r3       1987  82.547712
 r4       1988  82.952468
 r5       1989  80.970742
 r6       1990  81.062824
 r7       1991  71.783296
 r8       1992  71.620412
 r9       1993  75.797872
r10       1994  71.224445
r11       1995  71.755725
r12       1996  68.763557
r13       1997  67.719602
r14       1998  68.801385
r15       1999   67.62559
r16       2000  64.357494

I need to send this matrix to excel and would like the do-file to do this automatically.  Would this be possible?  I have looked at the possibilities of using outfile and outsheet but am not sure if these will be of any use as they seem to read the dataset, not the matrix.  Any pointers to references would be most appreciated.
Thanks in advance for your time and help,

Christopher D Fergusson

_______________________________________________________________________
Freeserve AnyTime, only 13.99 per month with one month's FREE trial!
For more information visit http://www.freeserve.com/time/ or call free on 0800 970 8890


*
*   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