What defines a partner? Someone within the same two-person family?
Perhaps something like this:
clear
input site family person personal_labor_income
1 1 1 2000
1 1 2 2300
1 2 1 200
1 2 3 3000
2 10 4 3400
2 10 5 3500
end
bysort site family : gen partner_income = cond(_n ==1,
personal[_n+1],personal[_n-1])
Scott
On Wed, May 14, 2008 at 12:55 PM, Ekaterina Selezneva
<[email protected]> wrote:
> I have a dataset with some information on a sample of married
> couples. For identifying a single person, one needs to know a
> "site"-number, "family"-number withing the site, and then the
> "person"-number within the family. As this is a subsample of some
> bigger dataset, so not all sites/families/persons are presented in
> it. Let's say, something like:
>
> site family person personal_labor_income
> 1 1 1 2000
> 1 1 2 2300
> 1 2 1 200
> 1 2 3 3000
> 2 10 4 3400
> 2 10 5 3500
>
> THE PROBLEM: I need to create a variable containing the "personal
> labor income" of partner.
>
> Unfortunately, I've spent a day, and havn't
> succeded to solve this seemingly simple problem. I will be grateful for
> any hints.
>
> Thanks a lot in advance,
> Ekaterina
>
*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
