Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down at the end of May, and its replacement, statalist.org is already up and running.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: st: Display special characters in estout


From   Dominik Becker <dominik.becker@wiso.uni-koeln.de>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: Display special characters in estout
Date   Wed, 31 Mar 2010 13:53:51 +0200

Dear Miranda, 

this is not really the answer to your question, but have you tried to
open the file with OpenOffice? As far as I know, you can choose the cell
separator before importing a file. You would have to make shure that
"comma" is deselected. Afterwards, you could save it as a conventional
xls-file that would be ready for excel.

Maybe this works.

Best,
Dominik





Am Montag, den 29.03.2010, 14:50 +0100 schrieb Miranda Kim:
> Dear Stata listers,
> I am creating a summary statistics table using estout in Stata 11, and 
> directly exporting this table into excel.
> I am encountering a problem when using the -posthead- option or the 
> -label- option when my string expression contains a comma. This comma is 
>   interpreted as moving to the next cell.
> For example adding the option posthead("Qualification level, percent 
> (no.)") in the esttab call, would put "Qualification level" in the first 
> cell and "percent (no.)" in the next cell, when exporting into excel. 
> Any suggestions would be greatly appreciated.
> Many thanks and best wishes,
> Miranda
> 
> *
> *   For searches and help try:
> *   http://www.stata.com/help.cgi?search
> *   http://www.stata.com/support/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/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/


© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   Site index