Stata The Stata listserver
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

st: Merging problem


From   masanja@tehip.or.tz
To   statalist@hsphsun2.harvard.edu
Subject   st: Merging problem
Date   Tue, 23 Jul 2002 16:43:48 +0300

Dear statalister

I have 2 files one containing information at household level and another one at individual level. I would like to have each individual to in a household have a value of an index which is at household level. When merged two files on perm_id, here is what I get. Some individual are missing the value of the index. When I do it on family_id, it gives me un-anticipated results. What is the trick here?

family_id perm_id index
1. BUA000001 BUA000001002 .
2. BUA000001 BUA000001003 .
3. BUA000001 BUA000001004 .
4. BUA000001 BUA000001005 .
5. BUA000001 BUA000001006 .
6. BUA000001 BUA000001007 6.163015
10. BUA000004 BUA000004002 .
11. BUA000004 BUA000004003 .
12. BUA000004 BUA000004004 8.866956

Sincerely

Masanja

*
* 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