From: "Li Chuntao" <[email protected]>
Reply-To: [email protected]
To: <[email protected]>
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" <[email protected]>
To: <[email protected]>
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/
