Re: st: Transferring tables into excel when "Copy Table" option only half works

[Steve Nakoneshny <scnakone@ucalgary.ca>]

In Stata 10, -outsheet- is available. It can export your selected data to a tab-delimted txt file which can then be imported to Excel.

Steve

On Nov 8, 2013, at 11:57 AM, Fernando Rios Avila <f.rios.a@gmail.com> wrote:

> 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 <libbethp@gmail.com> 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/