Announcement

Collapse
No announcement yet.
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Tabstat for year range in dataset

    Dear all,

    This is the command that I use to report the mean and median: tabstat tier1_ratio, by(year) stat(mean median)

    The dataset contains from 1984 til 2013. If i use the command this will result in the following table:

    Summary for variables: tier1_ratio
    by categories of: year

    year | mean p50
    ---------+--------------------
    1984 | . .
    1985 | . .
    1986 | . .
    1987 | . .
    1988 | . .
    1989 | . .
    1990 | . .
    1991 | . .
    1992 | . .
    1993 | . .
    1994 | . .
    1995 | . .
    1996 | .1748147 .1447089
    1997 | .1780195 .1453163
    1998 | .1774421 .1431704
    1999 | .1766341 .1408921
    2000 | .1726026 .1364682
    2001 | .1664413 .1332539
    2002 | .1643547 .1330135
    2003 | .1655091 .1336967
    2004 | .1660098 .1339151
    2005 | .1674585 .1337724
    2006 | .1703732 .1330099
    2007 | .1704072 .1323075
    2008 | .1633681 .1282478
    2009 | .1568057 .1283957
    2010 | .1591293 .1349986
    2011 | .1663817 .1436491
    2012 | .1703651 .1491446
    2013 | .1719273 .1511574
    ---------+--------------------
    Total | .1692255 .1381775
    ------------------------------


    I only want to report the years ranging from 1996 to 2013, in the table with the mean and median. Could you help me with this?

    Thanks!

    Egbert

  • #2
    Code:
    tabstat tier1_ratio if year>1995, by(year) stat(mean median)

    Comment


    • #3
      Thank you!!

      Comment

      Working...
      X