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]
st: RE: Transferring tables into excel when "Copy Table" option only half works
From
"Radwin, David" <[email protected]>
To
<[email protected]>
Subject
st: RE: Transferring tables into excel when "Copy Table" option only half works
Date
Fri, 8 Nov 2013 14:27:50 -0500
I agree with the others that a command to output your results directly to an Excel-friendly format (including tab-separated or comma-separated values) is generally the best solution.
However, if you need to copy tables anyway, you may be able to fix your problem by selecting the table in exactly the right spot in the results window. I don't know if I can describe a generic solution that applies to all types of tables. Start by positioning the cursor immediately to the left of the first character of the first column header, and experiment to see what works.
For an explanation, see:
http://www.stata.com/statalist/archive/2007-07/msg00238.html
David
--
David Radwin, Senior Research Associate
Education and Workforce Development
RTI International
2150 Shattuck Ave. Suite 800, Berkeley, CA 94704
Phone: 510-665-8274
www.rti.org/education
> -----Original Message-----
> From: [email protected] [mailto:owner-
> [email protected]] On Behalf Of Elizabeth Loughnan
> Sent: Friday, November 08, 2013 10:52 AM
> To: [email protected]
> Subject: st: Transferring tables into excel when "Copy Table" option only
> half works
>
> 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/