Re: st: Exporting tables to Excel

[Eric Booth <ebooth@ppri.tamu.edu>]

<>
> Also, keep in mind that the 'n' stat you specified should be 'N'.

This probably introduced some confusion.  'n' is the correct way to write it in the -table- command you described (e.g., table for rep78, c(mean price n price) ), but 
I wanted to make sure that you change this to 'N' in -tabout- .


- Eric
__
Eric A. Booth
Public Policy Research Institute
Texas A&M University
ebooth@ppri.tamu.edu
Office: +979.845.6754

On Mar 4, 2011, at 8:28 AM, Eric Booth wrote:

> <>
> 
> -tabout- (from SSC) will allow you to put many variables in the c() option and varlist.  
> Did you specify the 'sum' option as well? Also, keep in mind that the 'n' stat you specified should be 'N'.
> Let us know the -tabout- code you tried that isn't working.
> 
> This example exports an excel table (really just a text file that excel will open since I gave it a xls extension) with some summary stats (N, mean, median) for 3 variables by 5 other variables.
> ***************!
> sysuse auto, clear
> tabout for rep78 trunk  using "myexcelfile.xls", sum replace   ///
> c(mean mpg N mpg mean price N price median turn median headr N weight) ///
> f(1c) ptotal(both)  
> ***************!
> Take a look at this for some help with -tabout-:  http://fmwww.bc.edu/repec/bocode/t/tabout_tutorial.pdf
> 
> There are lots of other options out there besides -tabout- (though it's the one I most commonly use).   Try typing -findit export table-  into the command line to see some other user packages that have similar functionality.
> 
> - Eric
> __
> Eric A. Booth
> Public Policy Research Institute
> Texas A&M University
> ebooth@ppri.tamu.edu
> Office: +979.845.6754
> 
> On Mar 4, 2011, at 7:58 AM, Diana Iancu wrote:
> 
>> Dear all,
>> 
>> Is it possible to export complicated tables from Stata to Excel, for instance:
>> table var1 var2, c(n var3 mean var3) ?
>> I have tried tabout, but as far as I can see, it doesn't allow me to include more than one variable in c( ) or to table 3 variables.
>> Your assistance will be highly appreciated.
>> 
>> Best regards,
>> Diana Iancu
>> 
>> 


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