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
Should I use Fixed Effect when using data of population?Good Afternoon, everyone. I would like to ask about choosing the right model when we use data of po…
missing valures imputationHi all, I am trying to impute my missing values but i i get an error message i can't figure out what…
Could I winsorise at 1% and 99% levels for a sample of 500 observations?Dear all, I have a sample of 500 observations. I detect some outliers of my dependent variable. …
Adaptive Gauss-Hermite QuadratureHi everyone, I am practising using the adaptive quadrature to programme the (log-) likelihood funct…
transforming then imputing or vice-versaHi all, I was wondering whether it is better to transform the data then impute the missing values or…
Subscribe to:
Post Comments (Atom)
0 Response to Counting events falling in any 5 year window around the focal event
Post a Comment