Dear Stata Users
I have the following data set containing information on the level of
schooling (s) for every memeber (memid) of the household unit of reference
(hhid). In my case, I am looking at married couples. There are multiple
couples who reside in the same hhid. The variable "pairs" identifies how
many couples live within the same hhid. Please note that my "sex" and
"memid" variables are not sorted and they can't be sorted. This is an
inherent nature of the data.Head of the household can have any "memid" and
so can his/her spouse. Hence, my data is organised in the following
manner:
hhid memid sex s pairs smale sfemale
1 1 female 8 1 0 8
1 2 male 3 1 3 0
2 1 male 12 2 12 0
2 2 female 10 2 0 10
2 4 female 15 2 0 15
2 8 male 10 2 10 0
What I have to do seems easy to achieve. I have to replace schooling of
the male (smale) with the schooling of the female (sfemale) taking into
account the nature of the data set.
This is the expected format:
hhid memid sex s pairs smale* sfemale*
1 1 female 8 1 3 0
1 2 male 3 1 0 8
2 1 male 12 2 10 0
2 2 female 10 2 0 12
2 4 female 15 2 15 0
2 8 male 10 2 0 10
One can use an "egen" command if there was only one pair per houeshold
(sum the schooling level of the male and the female respondents and then
substract and subsitute). Multiple hhid's are problematic.I was unable to
account for them. I tried to reshape the data from "long" to "wide" to no
avail: the fact that "sex" and "memid" do not follow an appropriate order
creates problems.
I hope that you could possible suggest a way to solve this.
Thank you.
Altay Mussurov
PhD (c)
University of Wales Aberystwyth
*
* 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/
