Statalist


[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

st: -merge- which one would make sense?


From   "fstata@gmail.com" <fstata@gmail.com>
To   "statalist@hsphsun2.harvard.edu" <statalist@hsphsun2.harvard.edu>
Subject   st: -merge- which one would make sense?
Date   Wed, 21 May 2008 07:56:53 -0700

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/



© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index