Hello everyone,
I am working on a dataset containing a sample announcement dates (each standing for one acquisition made by one firm) and the firms that made the acquisition (identified by a unique identifier: scusip)
Now I need to assign all acquisitions to two subsamples. The subsamples are based on the number of other acquisitions made by the same firm that fall within any 5 year window around the announcement date of the focal acquisition.
What I am looking for is a way to find the maximum number of acquisitions that falls within any 5 year window of the focal acquisition. I do not need to know the exact window which yields the maximum number, only the number itself.
What I find difficult is that it can be any 5 year window.
I have not had any idea how to approach this so far, so all help is appreciated!
I attached an example of how my dataset looks like.
Thank you
Related Posts with Counting events falling in any 5 year window around the focal event
F statistic from logit model with survey dataHi, when performing logistic regression with survey data, is the reported F statistic actually resu…
Computing effect size after weighted multiple regressionHi all, I have another question about effect size after weighted multiple regression. the estat esi…
Which test? Values differ from zero significantly?Dear all, how I can check that the following values differ from zero significantly? 0 = expected v…
How to deal with December/January issues when using mkdir to create directories from system datesHello all, Using Stata 15.1/IC I've been using a do file for the past 8 months or so that automati…
ARIMA and SPSSWe are discontinuing use of SPSS (a product I have never used) in our office and one of my colleague…
Subscribe to:
Post Comments (Atom)
0 Response to Counting events falling in any 5 year window around the focal event
Post a Comment