Statalist The Stata Listserver


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

RE: st: Re: summary variables in table


From   "Linda, X Zhu" <lx_zhu@hotmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   RE: st: Re: summary variables in table
Date   Fri, 15 Jun 2007 15:26:05 +0200

Dear Chuntao and Marteen,

Thanks for your help!

Linda


From: "Li Chuntao" <chtl@econ.hku.hk>
Reply-To: statalist@hsphsun2.harvard.edu
To: <statalist@hsphsun2.harvard.edu>
Subject: st: Re: summary variables in table
Date: Fri, 15 Jun 2007 19:41:28 +0800

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/
_________________________________________________________________
Live Search, for accurate results! http://www.live.nl

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