Statalist


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

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


From   David Bell <[email protected]>
To   "[email protected]" <[email protected]>
Subject   Re: st: -merge- which one would make sense?
Date   Wed, 21 May 2008 14:02:57 -0400

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, [email protected] 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/



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