RE: st: different result each time

 From "Rajesh Tharyan" To Subject RE: st: different result each time Date Thu, 25 Sep 2008 14:07:31 +0100

```Hi all,

Thanks for the pointers.  The merge is a nightmare

I have one dataset like this

Co1 anndate1
Co1 anndate2
Co2 anndate1
Co3 anndate1

In this dataset each co anndate combination is unique

And the other as

Co1 dealdate1
Co1 dealdate2
Co1 dealdate3
Co1 dealdate4
Co1 dealdate5
Co1 dealdate6
Co2 dealdate2
Co2 dealdate3
Co2 dealdate4

In this dataset each co dealdate combination is unique i.e. I don't have for
example two co1 dealdate1 etc.

The idea of the merge is that for each co anndate combination I need to get
all the dealdates with x days before and after the anndate. So I do a many
to many merge and drop all deal dates that fall outside this range. I am not
sure how to do this apart from a many to many merge. Is there another way?

Rajesh Tharyan
Tel: +44 (0)1392 262544
Fax: +44 (0)1392 262475
E-mail: r.tharyan@exeter.ac.uk

Times Higher Education University of the Year 2007/08

-----Original Message-----
From: owner-statalist@hsphsun2.harvard.edu
[mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Eva Poen
Sent: 25 September 2008 12:42
To: statalist@hsphsun2.harvard.edu
Subject: Re: st: different result each time

Wouldn't you need the latter of the cases you mentioned (merge
variables don't uniquely identify observations in both datasets) for
this to happen? I think you'd get the same result if you have
uniqueness in one dataset. I made up a little example. The second
merge produces different results in both runs, while the first merge
produces identical results.

```