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

st: AW: output format


From   "Christian Holz" <statalist@krueschan.de>
To   <statalist@hsphsun2.harvard.edu>
Subject   st: AW: output format
Date   Thu, 4 Aug 2005 17:39:57 +0100

Hi,

many suggestions have been made to format the table more nicely. The part of
Ying's question, however, how to output the results directly to Excel has
not been answered yet.

You could consider to -collapse- your file (eg. collapse (mean)
m_expov2=expov2 (count) n_expov2=expov2 , by (calmon) ) and then -outsheet-
it in an tab- or commaseparated textfile, which can easily be opened with
Excel (eg. outsheet using export.csv).
This kinda solves the formatting problem as well as the actual unformatted
numbers will be written to the .csv file.

Best regards,

Christian Holz
Department of Sociology
University of Glasgow
Scotland, U.K.


-----Ursprüngliche Nachricht-----
Von: owner-statalist@hsphsun2.harvard.edu
[mailto:owner-statalist@hsphsun2.harvard.edu] Im Auftrag von wying1@umbc.edu
Gesendet: 02 August 2005 17:15
An: statalist@hsphsun2.harvard.edu
Betreff: st: output format

Dear listusers,

I use Stata 8. Here is the output I generated.  For the N(expov2), the
number is sth. like 1.80e+07, but I actually want the real number.  How do
I specify it?

   calmon | mean(expov2)     N(expov2)
----------+---------------------------
 2000 Oct |     .0634935      1.80e+07
 2000 Nov |     .0559704      3.61e+07
 2000 Dec |     .0599429      5.41e+07
 2001 Jan |     .0613797      7.23e+07
 2001 Feb |     .0608688      7.24e+07
 2001 Mar |     .0570004      7.24e+07
 2001 Apr |     .0577895      7.24e+07
 2001 May |     .0586258      7.25e+07
 2001 Jun |     .0602535      7.24e+07
 2001 Jul |     .0632536      7.25e+07
 2001 Aug |     .0616009      7.25e+07

Besdies, other than the tedious copy and paste, is there any way I can
output these results to the Excel directly?

Thanks a lot,
Ying

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


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