Statalist The Stata Listserver


[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

st: Stata/Excel Estout Question


From   Johannes Geyer <[email protected]>
To   [email protected]
Subject   st: Stata/Excel Estout Question
Date   Wed, 20 Jun 2007 16:22:15 +0200

Dear Statalist,

I have  a combined question concerning Stata and Excel:

I want to use the following code

estimates store ABC
estout ABC using ${ESTOUT}ABC.xls, replace

When I want to use the produced output in Excel for further calculations 
(pleaese, don't ask why I cannot use Stata to do further calculations 
which I would clearly prefer...) I am confronted with Excel saving my 
estimation results in some odd format - allthough the file has the ending 
.xls it does not seem to be a "real" Excel spreadsheet, e.g. the produced 
file ABC.xls has roughly 500KB whereas when I resave the file in Excel 
format it results in ABC.xls its size if 5MB. So, I think that the first 
format is some kind of text-file and the second is some Windows standard 
format for Excel. My question is: is there a direct way from estimation 
results in Stata to a "real" Excel-spreadsheet.

Any help would be appreciated,
best 

Johannes

_______________
Wichtiger Hinweis!
Das DIW Berlin zieht um. Ab 1. Juli 2007 erreichen Sie uns unter einer 
neuen Adresse:
DIW Berlin
Mohrenstra�e 58
10117 Berlin
----------------------
Johannes Geyer
Deutsches Institut f�r Wirtschaftsforschung (DIW Berlin)
German Institute for Economic Research 
Graduate Center
Koenigin-Luise-Stra�e 5
14195 Berlin, Germany 
Tel: +49-30-89789-258

*
*   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–2024 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index