Stata The Stata listserver
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

Re: st: Creating Yearly Totals from 12 Months


From   Rafal Raciborski <rafal.raciborski@emory.edu>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: Creating Yearly Totals from 12 Months
Date   Sun, 20 Mar 2005 20:13:58 -0500

Hi Thomas,

The trick is to generate a year indicator and then to collapse on it:

. gsort -month

. gen x=1 if mod(month,12)==0
(22 missing values generated)

. gen year=sum(x)

. list

     +-----------------------------+
     | month       var1   x   year |
     |-----------------------------|
  1. |    24   6.420962   1      1 |
  2. |    23   6.359303   .      1 |
  3. |    22   6.291237   .      1 |
  4. |    21   6.216306   .      1 |
  5. |    20    6.13373   .      1 |
     |-----------------------------|
  6. |    19   6.043005   .      1 |
  7. |    18   5.943435   .      1 |
  8. |    17   5.834095   .      1 |
  9. |    16   5.714371   .      1 |
 10. |    15   5.584059   .      1 |
     |-----------------------------|
 11. |    14   5.443335   .      1 |
 12. |    13   5.291652   .      1 |
 13. |    12   5.129404   1      2 |
 14. |    11   4.959064   .      2 |
 15. |    10   4.785601   .      2 |
     |-----------------------------|
 16. |     9   4.612175   .      2 |
 17. |     8   4.443652   .      2 |
 18. |     7   4.280849   .      2 |
 19. |     6   4.142096   .      2 |
 20. |     5   4.063006   .      2 |
     |-----------------------------|
 21. |     4   4.069176   .      2 |
 22. |     3   4.171527   .      2 |
 23. |     2    4.27602   .      2 |
 24. |     1   3.407265   .      2 |
     +-----------------------------+

. collapse (sum) var1, by(year)

. list

     +-----------------+
     | year       var1 |
     |-----------------|
  1. |    1   71.27549 |
  2. |    2   52.33984 |
     +-----------------+


rafal

================
Rafal Raciborski
Graduate student
Department of Political Science
Emory University
301 Tarbutton Hall
1555 Dickey Drive
Atlanta, GA 30322
404-378-9826 (home)
rafal.raciborski@emory.edu (e-mail)
www.roofoos.net

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