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

[Sergiy Radyakin <serjradyakin@gmail.com>]

Elizabeth, see here:
http://www.radyakin.org/statalist/2013110802/copytable.htm
Best, Sergiy Radyakin





On Fri, Nov 8, 2013 at 3:52 PM, John Luke Gallup <jlgallup@pdx.edu> wrote:
> 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 <jcanner1@jhmi.edu> 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: owner-statalist@hsphsun2.harvard.edu [mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Fernando Rios Avila
>> Sent: Friday, November 08, 2013 1:57 PM
>> To: statalist@hsphsun2.harvard.edu
>> 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 <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/
>
>
> *
> *   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/