Hi All, I'm infinitely grateful to folks who responded to an earlier query regarding creation of turnover variables (entries, exits, and total turnover [entries + exits]). A terrific solution was provided for a balanced dataset, or at least one in which the number of years was known and could be specified. Alas, a second dataset contains unbalanced data. Start and end years differ; also, duration varies across teams. So, for example, four years of data might be available for one team; only three years for another. What's more, teams exhibit different start and end years. A sample of the data are provided below. To the right of the three variable columns (Team, Year, Member) are some notes reflecting the events that need capturing (again, exits, entries, and their total). Sample data: Team Year Member A 2000 Charlene A 2000 David A 2000 Jane A 2000 Paul A 2001 Charlene A 2001 David A 2001 Jane A 2001 Paul A 2002 Ann Charlene exited; Ann entered A 2002 David A 2002 Jane A 2002 Paul A 2003 Ann A 2003 David A 2003 Jane A 2003 Jim Jim entered A 2003 Paul B 2000 Betty B 2000 Joe B 2000 Suresh B 2000 Tom B 2001 Brandy Betty exited; Brandy entered B 2001 Joe B 2001 Suresh Tom exited C 2002 Gwen C 2002 Jamal C 2002 Peter C 2002 Susan C 2003 Edward Edward entered C 2003 Gwen C 2003 Jamal C 2003 Peter C 2003 Susan C 2004 Edward C 2004 Gwen C 2004 Jamal C 2004 Peter Susan exited Whereas the input data are observations at the individual level of analysis, the output is aggregated at the team level and should have a Team x Year structure including three variables: Entry (# additions to the team in the most recent time period), Exit (# exits from the team in the most recent timer period), and Turnover (= Entry + Exit in the most recent time period). In other words ... Team Year Entry Exit Turnover A 2000 . . . A 2001 0 0 0 A 2002 1 1 2 A 2003 1 0 1 B 2000 . . . B 2001 1 2 3 C 2002 . . . C 2003 1 0 1 C 2004 0 1 1 The first year (time period) for each team scores missing values since it cannot have incurred turnover. Please know any thoughts or suggestions are immensely appreciated! Thanks!
... View more