Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
RE: st: Transferring tables into excel when "Copy Table" option only half works
From
Joe Canner <[email protected]>
To
"[email protected]" <[email protected]>
Subject
RE: st: Transferring tables into excel when "Copy Table" option only half works
Date
Fri, 8 Nov 2013 19:12:28 +0000
Elizabeth,
You don't indicate what kinds of analyses you are doing so it is hard to give specific advice.
One possibility related to what Fernando suggested is to use -parmest- which outputs regression parameters to a data set. Then use -export excel- or -outsheet- to turn that into an Excel file.
Regards,
Joe
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Fernando Rios Avila
Sent: Friday, November 08, 2013 1:57 PM
To: [email protected]
Subject: Re: st: Transferring tables into excel when "Copy Table" option only half works
Hi Elizabeth,
Unless somebody else has a trick under their sleeve, there is no fix solution for your problem.
The two options available that i have used are:
1. Copy as text, and separate columns in Excel 2. If the tables correspond to regressions, use -outreg2- , -tabout-,
-estout- or similar commands.
Hope this helps.
On Fri, Nov 8, 2013 at 1:52 PM, Elizabeth Loughnan <[email protected]> wrote:
> Dear Stata users,
>
> I am trying to export a Stata results table into excel, using the Copy Table option. It is correctly copying some columns, but a few are folded into others - e.g. so my table has 3 columns instead of 5. The missing 2 are doubled up in the 3 successfully transferred columns, with a few spaces between what should be in one column and what should be in another.
>
> I am using STATA 10.
>
> I have checked searching on the Stata website, and UNC. UNC suggests copying the top and base of table separately. This helps but I still get some instances of 2 columns folding into 1.
>
> Thanks in advance for tips.
>
> Best,
>
> Elizabeth
>
>
> *
> * For searches and help try:
> * http://www.stata.com/help.cgi?search
> * http://www.stata.com/support/faqs/resources/statalist-faq/
> * http://www.ats.ucla.edu/stat/stata/
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/faqs/resources/statalist-faq/
* http://www.ats.ucla.edu/stat/stata/
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/faqs/resources/statalist-faq/
* http://www.ats.ucla.edu/stat/stata/