st: Re: summary variables in table

["Li Chuntao" <chtl@econ.hku.hk>]

Dear Linda,

  You can use tabstat

  the syntax is as following:

  tabstat X, s(N mean sd median min max) by(year) c(s) long

   you can also use save, to get some matrixes

cheers

Chuntao


----- Original Message ----- 
From: "Linda, X Zhu" <lx_zhu@hotmail.com>
To: <statalist@hsphsun2.harvard.edu>
Sent: Friday, June 15, 2007 5:55 PM
Subject: st: summary variables in table



> Dear Stata users,
> I want to produce a table with detailed information (mean, sd, min and 
> max) over a period of 10 years (1995-2004) for variable X. I used the 
> following command:
> .tabulate year, sum(X)
>
> But it only gives the following table without min and max:
>
>            |           Summary of X
>       year |        Mean   Std. Dev.       Freq.
> ------------+------------------------------------
>       1995 |   .63269597   .14383535        1512
>       1996 |   .58289224   .15692677        1399
>       1997 |   .59353296   .15831222        1415
>       1998 |   .39928454   .15771493        1402
>       1999 |   .42101546   .16275227        1255
>       2000 |   .42147087   .15343508        1329
>       2001 |   .46865912   .18852401        1275
>       2002 |   .53090268   .19617975        1161
>       2003 |   .52617608   .18866527        1180
>       2004 |   .55353803   .19835808        1167
> ------------+------------------------------------
>      Total |    .5147799   .18758198       13095
>
> How can I have two more columns (with min and max values) in the table? 
> Thanks!
>
> Linda
>
> _________________________________________________________________
> Play online games with your friends with Messenger 
> http://www.join.msn.com/messenger/overview
>
> *
> *   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/