Create pair-year dataset

[wibeasley]

Create a dataset with one row per relationship/pair per year.

See Y0003300 and the rest of the 'Q2' 79Gen2 variables.

Variables

1. year
2. S1 Tag
3. S2 Tag
4. S1 Age (at interview)
5. S2 Age (at interview)
6. Proportion of Year S1 & S2 lived together
7. Cumulative Years Together count
8. S1 Q (= S1 Age / Cumulative Years Together count)
9. S2 Q (= S2 Age / Cumulative Years Together count)

Other plumbing variables

1. RelationshipPath
2. S1 Generation
3. S2 Generation
4. Is survey year (b/c we have a row for every year, not every survey year)

Real-world

1. the participants aren't surveyed on the same day necessarily, to the proportion & cumulative versions conceivably need two versions (one for each subject's interview date)

Example Scenario

• Subjects 101 & 102 are half sibs, both born to Gen 1 mom (id: 1) and lived w/ mom all their lives
• In 2000
  • 101 is 7 y.o.
  • 102 is 2 y.o.

Discussed at the Nov meeting