Re: st: -merge- which one would make sense?

[David Bell <dcbell@iupui.edu>]

Nirina-

You say you have 5000 individuals.  So does this mean you have 2500  
husbands and their 2500 wives(presumably one each).  It sounds like  
you are saying that household records, husband records and wife  
records have the same variables and the same variable names.  This  
seems bizarre, so I am probably misunderstanding you.

Dave Bell
====================================
David C. Bell
Professor of Sociology
Indiana University Purdue University Indianapolis (IUPUI)
(317) 278-1336
====================================




On May 21, 2008, at 10:56 AM, fstata@gmail.com wrote:


> Hello,
> I have a microdataset with 5000 individuals. In the data, I have
> household questionnaires and individual questionnaires together, pid,
> hhid.
>
> I did the following scenarios and now I'm lost:
>
> 1- I separated the household(hh) questionnaire from the individual(i)
> questionnaires.
> I split the remaining individual questionnaires into married female
> and  married male renamed all variables accordingly.
> Then I merged the male and female because they are husband and wife by
> their household id. I had 2000 households
> Afterward, I merged the hh questionnaire. I end up back to 5000  
> observations.
>
> 2- I kept the original dataset and just split into two datasets
> married female and  married male which I merged afterward to have
> husband and wives. I arrive at 2000 observations.
> When I assert if household information from husband and wife is the
> same, almost 90% of the observation is false.
>
> What do you think I should do? Which one of the two should make sense?
> Thank you very much from your help.
> Nirina
> *
> *   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/
>
> Privileged, confidential or patient identifiable information may be  
> contained in this message. This information is meant only for the  
> use of the intended recipients. If you are not the intended  
> recipient, or if the message has been addressed to you in error, do  
> not read, disclose, reproduce, distribute, disseminate or otherwise  
> use this transmission. Instead, please notify the sender by reply e- 
> mail, and then destroy all copies of the message and any attachments.
>
> *
> *   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/
*
*   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/