Statalist


[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

Re: st: help needed with creating table


From   "Lili Yan" <lyan16@gmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: help needed with creating table
Date   Thu, 13 Mar 2008 17:00:33 -0500

Hi Tom,

Thank you very much!

Lili

On Wed, Mar 12, 2008 at 3:04 PM, Tom Trikalinos <ttrikalin@gmail.com> wrote:
> help _tabstat_ ?
>
>
>
>
> On Wed, Mar 12, 2008 at 3:35 PM, Lili Yan <lyan16@gmail.com> wrote:
> > Dear Statalist subscribers,
> >
> >  I need help to create a descriptive statistics table for a bunch of
> >  -summarize- commands. Eventually, I want the table looks like this:
> >
> >                  Native cars          Foreign cars
> >  var1             mean                       mean
> >                   (sd)                           (sd)
> >  var2             mean                       mean
> >                   (sd)                           (sd)
> >  No.of Obs.    xxx                           xxx
> >
> >  I tried some codes which I attached below. However, there are two
> >  difficulities that I cannot solve. First, I want the same number of
> >  observations for all variables. That is, only when an observation has
> >  no missing values for all variables in the varlist, that observation
> >  can be included in the sample. In my codes, each variable has its own
> >  no. of obs.; Second, I want the standard deviation to be put below the
> >  mean and in parentheses. Currently, it is beside the mean which is not
> >  desired.
> >
> >  ...............tentative codes start here........
> >  #delimit;
> >  sysuse auto, clear;
> >  global varlist mpg price weight length;
> >
> >  foreach var in $varlist { ;
> >  qui summ `var' if foreign==1;
> >  scalar drop _all;
> >
> >  mat drop _all;
> >  mat n=r(N);
> >  mat mean=r(mean);
> >  mat v=r(sd);
> >
> >  mat input try=(0 0 0);
> >  mat rownames try=`var';
> >  mat colnames try= nbobs nbmean nbsd;
> >  mat try[1,1]=n;
> >  mat try[1,2]=mean;
> >  mat try[1,3]=v;
> >
> >  mat list try;
> >  };
> >  ..................tentative codes end.................
> >
> >  Please kindly give some help! Thanks a lot!!
> >
> >  Best,
> >
> >  *
> >  *   For searches and help try:
> >  *   http://www.stata.com/support/faqs/res/findit.html
> >  *   http://www.stata.com/support/statalist/faq
> >  *   http://www.ats.ucla.edu/stat/stata/
> >
> *
> *   For searches and help try:
> *   http://www.stata.com/support/faqs/res/findit.html
> *   http://www.stata.com/support/statalist/faq
> *   http://www.ats.ucla.edu/stat/stata/
>
*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   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   |   What's new   |   Site index