Maarten--
That would have been my first thought, too. But Raphael Fraser has
either mistyped his desired outcome, or has some hidden structure in
mind that matches d1 and d2 in the first obs in 82 and not the second:
82 1 1
82 . 1
If he meant
82 1 .
82 . 1
82 . 1
then he wants to -append- not -merge- I guess. If he did not mistype,
he still may want to -append- and then -replace- according to some
rule...
On 2/14/07, Maarten Buis <[email protected]> wrote:
> --- Raphael Fraser wrote:
> I would like to merge data1 and data2:
>
> data1,
> time d1
> 82 1
> 90 0
>
> data2,
> time d2
> 82 1
> 82 1
> 89 0
>
> The result should look like this
> time d1 d2
> 82 1 1
> 82 . 1
> 89 . 0
> 90 0 .
>
>
> You need to make sure that both data1 and data2 are sorted
> according to time. Then you can use -merge-, see:
> -help merge-. The do-file will look something like this:
>
> use data2, clear
> sort time
> save data2, replace
> use data1, clear
> sort time
> merge time using data2
> list time d1 d2 _merge in 1/20
> tab _merge
>
> Hope this helps,
> Maarten
>
> BTW you have reached the same answer if you searched in Stata
> on merge, by typing -findit merge-.
*
* 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/
