Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
From | "Tanu Kohli" <tkohli@andromeda.rutgers.edu> |
To | statalist@hsphsun2.harvard.edu |
Subject | Re: st: Creating new variables for parent groups in a joint family |
Date | Tue, 28 Aug 2012 13:20:24 -0400 |
Yes, but relation code repeats itself. there can be two values coded 3. So if i create a nuclear hhid saying that nfam=hhid+ relation==3, i will get same value for both married sons in the joint family. Is there some way to create an identifier say, first set of relations coded 3,4 and 6 for household 1 should be coded nfam1 second set of relations coded 3,4 and 6 for household 1 should be coded nfam2 May be then i can create education indicators for each parent in each nuclear family. Sincerely, Tanu Kohli Division of Global Affairs/ Dept of Economics Rutgers University Newark According to your example, there is a variable "Relation to the head" which includes the information you need. Nick On Tue, Aug 28, 2012 at 6:03 PM, Tanu Kohli <tkohli@andromeda.rutgers.edu> wrote: > I tried that as well but am unable to do it as the codes are the same. > > Sincerely, > Tanu Kohli > Division of Global Affairs/ Dept of Economics > Rutgers University > Newark > > Indeed. You need to extend the identifier to include a couples > identifier and use that as well in the -by()- argument. > > Nick > > On Tue, Aug 28, 2012 at 5:42 PM, Tanu Kohli > <tkohli@andromeda.rutgers.edu> wrote: >> Thank you Nick. However, one household can have more than one set of parents in >> the >> second generation. These are also coded as 3 and 4. i have education for 1st set >> of >> parents coded as 3 and 4, but cannot get it for families which have more than >> one >> couple in the second generation. >> >> Any suggestions? >> >> >> Sincerely, >> Tanu Kohli >> Division of Global Affairs/ Dept of Economics >> Rutgers University >> Newark >> >> You can calculate new variables such as >> >> egen edu3 = total((relationcode == 3) * education) , by(HHID) >> >> egem edu4 = total((relationcode == 4) * education), by(HHID) >> >> and then >> >> collapse edu3 edu4 , by(HHID) >> >> For "STATA" read "Stata". >> >> Nick >> >> On Tue, Aug 28, 2012 at 4:42 PM, Tanu Kohli >> <tkohli@andromeda.rutgers.edu> wrote: >> >>> I have a dataset that contains information on joint families and is coded and >>> arranged in the following way- >>> >>> HHID Relation to the Head Relation code Education >>> 1 Self 1 3 >>> 1 Spouse of head 2 1 >>> 1 Married Child 1 3 10 >>> 1 Spouse of married child 1 4 7 >>> 1 Grandchild 1 6 3 >>> 1 Grandchild 2 6 2 >>> 1 Married child 2 3 12 >>> 1 Spouse of married child 2 4 13 >>> 1 Grandchild 3 6 1 >>> >>> I want to seperate education of married child 1 and spouse of married child 1 >>> as >>> new variables corresponding with their children's education (grandchild 1 and >>> grandchild 2). Similarly, I want new variables for education of married child 2 >>> and >>> his spouse corresponding with their child (grandchild 3). >>> >>> How can I do this STATA so that I have only 1 observation for household 1 and >>> rest >>> information as new variables? >>> >> * >> * 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/ >> >> >> >> * >> * 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/ > * > * 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/ > > > > * > * 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/ * * 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/ * * 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/