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: esttab into Excel tables that are directly readable?


From   "Radwin, David" <[email protected]>
To   <[email protected]>
Subject   RE: st: esttab into Excel tables that are directly readable?
Date   Tue, 8 Oct 2013 19:02:50 -0400

You may also be able to skip the "Text to Columns" step if you open the
CSV file by clicking on its icon in an operating system window instead
of opening the CSV file from within the Excel program. At least that's
what I do.

David
--
David Radwin
Senior Research Associate
Education and Workforce Development Division
RTI International
2150 Shattuck Ave., Suite 800
Berkeley, CA 94704
Phone: 510-665-8274

www.rti.org

> -----Original Message-----
> From: [email protected] [mailto:owner-
> [email protected]] On Behalf Of Sergiy Radyakin
> Sent: Tuesday, October 08, 2013 2:36 PM
> To: [email protected]
> Subject: Re: st: esttab into Excel tables that are directly readable?
> 
> Jen,
> 
> CSV stands for "comma separated values". not "formats". any formatting
> you wish to apply that is not applied by Excel automatically - you
> will have to add it manually. The full list of automatic formatting is
> unknown [to me], but Excel usually trucates numbers that are longer
> than 15 digits, and may convert values with dashes or slashes to
> date/time formatted values.
> 
> For me as a non-native speaker what does "..need some extra clicks to
> put Text into Columns." mean? Do you need to put particular titles
> into the column headers? Or do you need to format columns as "text"
> not "numeric"? Or do you mean to adjust alignment of the columns? Or
> something else? Just in case, for importing files into Excel in CSV
> format, the following page is very interesting:
> http://superuser.com/questions/307496/how-can-i-set-excel-to-always-
> import-all-columns-of-csv-files-as-text
> 
> StataCorp has added the classes for handling tables still in version
> 12, which support column titles, widths, formats, coloring,
> separators, etc. And they are used for many "standard" outputs we see
> on the screen - regression output, matrix output, summarize output,
> etc.
> Given the recently added export to Excel, and a plethora of the output
> commands estout, tabout, esttab, latab, outtex, outreg2, outtable,
> texdoc I would be surprised if there is no output to _formatted_ Excel
> tables in Stata 14 (if it is not in Stata 13 already).
> 
> Best, Sergiy Radyakin.
> 
> 
> On Tue, Oct 8, 2013 at 4:18 PM, Jen Zhen <[email protected]> wrote:
> > Dear listers,
> >
> > I've forever been using Ben Jann's -esttab- command to get my
> > regression tables into Stata. I quite like that I can do all
> > regressions as I like, just needing to put an "eststo:" in front,
and
> > then just need the one line to get the table.
> >
> > The one thing I find annoying is that when I tell Stata to -esttab
> > using table.csv- and then open that table in Excel, I always need
some
> > extra clicks in Stata to put the Text into Columns. So I'm wondering
> > whether there is any way to esttab tables that I can open and
directly
> > read in Excel?
> >
> > Thank you so much and kind regards,
> > JZ


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