Re: st: RE: How to easily insert all tab statistics into matrix for export

[William Buchanan <william@williambuchanan.net>]

Hi Stephen,

Another option is Ben Jann's -estout- suite of packages.  You can use a loop to pass variables to the -estpost- command and then either combine matrices manually, or use the append option in -esttab- or -estout- to add those tables to the output file.  Both -tabout- and -estout- will get you the result that you are looking for, it's just a matter of preference of command(s).

HTH,
Billy



On Apr 17, 2013, at 11:35 AM, "David Radwin" <dradwin@mprinc.com> wrote:

> Stephen,
> 
> Another nice program for automatically generating tables in CSV and other
> formats is Ian Watson's -tabout-, available from SSC. Be sure to download
> the PDF help file.
> 
> David
> --
> David Radwin
> Senior Research Associate
> MPR Associates, Inc.
> 2150 Shattuck Ave., Suite 800
> Berkeley, CA 94704
> Phone: 510-849-4942
> Fax: 510-849-0794
> 
> www.mprinc.com
> 
> 
>> -----Original Message-----
>> From: owner-statalist@hsphsun2.harvard.edu [mailto:owner-
>> statalist@hsphsun2.harvard.edu] On Behalf Of Stephen Cranney
>> Sent: Wednesday, April 17, 2013 11:27 AM
>> To: statalist@hsphsun2.harvard.edu
>> Subject: st: How to easily insert all tab statistics into matrix for
>> export
>> 
>> Hi all,
>> 
>> I'm trying to insert all of the statistics I derive from the tab
>> command into a matrix so that I can use the frmttable command to
>> automate the frequency table generation. Specifically, I'm using the
>> row percentage command, but the row statistics are not collected in
>> the  matrix. So I'm wondering if there's a way to automatically place
>> the row statistics in the matrix or, if that's not an option, if
>> there's an efficient way to calculate a percentage row beneath each
>> row in the matrix that doesn't require customizing the dimensions for
>> each respective frequency table. I've done way too many of these
>> tables by hand in excel. Surely there has to be a way to automate
>> this.
>> 
>> Thanks in advance,
>> 
>> Stephen
>> 
>> 
>> --
>> Stephen Cranney
>> 
>> PhD Student
>> Graduate Group in Demography
>> University of Pennsylvania
>> *
>> *   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/