st: AW: AW: Counting months over several years in a variable

["Martin Weiss" <martin.weiss1@gmx.de>]

<> 


BTW, George, "Year" has no bearing on the solution whatsoever, neither does "month". If you want the result to depend on them, you may want to take a look at Nick`s http://www.stata-journal.com/sjpdf.html?articlenum=pr0004




HTH
Martin


-----Ursprüngliche Nachricht-----
Von: owner-statalist@hsphsun2.harvard.edu [mailto:owner-statalist@hsphsun2.harvard.edu] Im Auftrag von Martin Weiss
Gesendet: Samstag, 29. Mai 2010 15:52
An: statalist@hsphsun2.harvard.edu
Betreff: st: AW: Counting months over several years in a variable


<> 

So this code -generate-s "myvar" across the entire dataset. Make sure it does what you want:

*************
clear*

inp int Year byte month 
2008       8     
2008       9     
2008       10    
2008       11    
2008       12    
2009       1     
2009       2     
2009       3 
end

gen myvar=_n
list, noo

*************



HTH
Martin

-----Ursprüngliche Nachricht-----
Von: owner-statalist@hsphsun2.harvard.edu [mailto:owner-statalist@hsphsun2.harvard.edu] Im Auftrag von George Chioran
Gesendet: Samstag, 29. Mai 2010 15:07
An: statalist@hsphsun2.harvard.edu
Betreff: st: Counting months over several years in a variable

Dear statalisters, 
 
I want to count the
months in several years. I have variables year and month, and want to obtain
variable mvar. My database looks like this. 

Year       month  mvar
2008       8             1
2008       9             2
2008       10     3
2008       11           4
2008       12           5
2009       1             6
2009       2             7
2009       3             8
…             …             …
 
Thank you in advance
for your help, 
George


      

*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/


*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/


*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/