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

[Nick Cox <n.j.cox@durham.ac.uk>]

I don't see how lack of balance affects the calculation. If something is not in the data, in effect something didn't exist then. The numbers will be wrong if that is wrong, but the Stata code is the same. 

On a different note, it is not a good idea to keep asking for help when (a) you haven't yet understood or tried out solutions given or (b) you don't explain what is wrong with solutions offered. 

Nick 
n.j.cox@durham.ac.uk 

Erik Aadland

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/