RE: st: creating variable summarizing for each individual properties of other members of a group at t-1

[Erik Aadland <erikaadland@hotmail.com>]

My apologies for that misunderstanding, Nick. My programming abilities are still modest and I mistakenly believed the code applied to the first problem.
 
However, I am still struggling with both problems as my dataset is also unbalanced. I failed to inform you of this vital information. It did not occur to me that this information would impact the code. I am sorry.
 
So, Jorge's code for the first problem produces the correct variable as long as the data is balanced.  When unbalanced ind_ids occur with ind_entry = 1, they are not included in the sums/counts for/of the other ind_ids.
 
See the following example dataset for more precise structure representation.
 
year   month   yearmonth   ind_id   ind_entry
2003   11      11          2        0
2003   12      12          2        0
2004   10      22          2        1
2004   11      23          2        0
2004   12      24          2        1
2003   11      11          4        0
2003   12      12          4        1
2004   10      22          4        0
2004   11      23          4        0
2004   12      24          4        0
2003   11      11          56       0
2003   12      12          56       0
2004   1       13          56       1
2004   2       13          56       0
 
I greatly appreciate your help and input.
 
Kind regards.
 
Erik.


----------------------------------------
> From: n.j.cox@durham.ac.uk
> To: statalist@hsphsun2.harvard.edu
> Date: Wed, 18 May 2011 18:36:37 +0100
> Subject: RE: st: creating variable summarizing for each individual properties of other members of a group at t-1
>
> My code
>
> bysort ind_id (yearmonth) : gen ind_score = sum(ind_entry)
> by ind_id : replace ind_score = ind_score == 1 & ind_score[_n-1] != 1
> sort yearmonth
> gen all_score = sum(ind_score)
> by yearmonth : replace all_score = all_score[_N]
> replace all_score = all_score - ind_score
> bysort ind_id (yearmonth) : gen prevscore = allscore[_n-1]
>
> was certainly intended to solve your second problem. I've not tested it. Are you saying it doesn't? And if it doesn't what does it get wrong?
>
> Nick
> n.j.cox@durham.ac.uk
>
> Erik Aadland
>
> Thank you Nick and Jorge for your suggestions. They were very helpful, and I am very grateful.
>
> Jorge, your suggested code below worked perfectly for my "first" variable.
>
> I am still struggling with my "second" variable. In the "second" variable, I am trying to create a variable that for each ind_id counts the total number of other ind_ids, excluding the focal ind_id, in the dataset that have experienced ind_entry =1 at least once up until and including yearmonth -1. In other words, I am trying to create a variable that for each individual tracks the number of other entrants in the dataset up until and including yearmonth -1. I am trying to track ind_ids that have entered, not how many times they have entered.
>
> Any and all input on this problem would be very much appreciated.
>
>
> *
> * 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/