Rodrigo Brice�o
>
> Hello Stata listers. I'm having a problem related with
> several databases and
> I wish to ask you for specific information required.
> I have four databases:
> ENIGH-RJB1.dta=19,470 obs.
> ENIGH-RJB2.dta=19,120 obs.
> ENIGH-RJB3.dta= 7,719 obs.
> ENIGH-RJB4.dta=23,715 obs.
> First of all, the bases have the same ID variables (in this
> case could be
> household number, member number, home number, primary unit
> of sample, etc.).
> My purpose is to build an unique database with the
> differents variables that
> have each database.
> I tried:
> use ENIGH-RJB4.dta
> joinby using ENIGH-RJB3.dta, but I got a new database with 72,077
> observations, that is totally wrong (I assume that the
> maximum would be
> 23,715).
> I tried too:
> use ENIGH-RJB4.dta
> merge ENIGH-RJB3.dta I got a large number of missings (from
> obs, 7720 up).
> I know that I 'm doing something wrong but I can't
> understand what? Can
> somebody please provide me some help?
[U]26 is a very clear introduction to combining data.
It should help you decide whether you need -merge-,
-joinby- or indeed -append-.
Nick
[email protected]
*
* 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/
