Bookmark and Share

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   John Luke Gallup <[email protected]>
To   [email protected]
Subject   Re: st: Transferring tables into excel when "Copy Table" option only half works
Date   Fri, 8 Nov 2013 12:52:12 -0800

Elizabeth,

Another option is to use -frmttable- from SSC (-ssc install outreg-), which allows you to take any Stata matrix of statistics and create a Word or TeX table, with pretty complete control over formatting including titles and fonts.  However, to get this into Excel, you would need to copy the table from Word to Excel.

John Gallup

On Nov 8, 2013, at 11:12 AM, Joe Canner <[email protected]> wrote:

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


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


© Copyright 1996–2018 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   Site index