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
Conditional marginal effectDear members, I am trying to find marginal effects from a system of equations that I estimated usin…
Percentile variablehi everybody am working with stata and here below is a question that i need to answer. I do not get …
Regression resultsHi, I am new to regression and still reading books about it. I am regressing debt ratio against pro…
What could have I possibly done wrong?Hello, I just did a regression analysis and displayed a scatterplot and the points are I can't see n…
No observations in xtregHi statlist, I have a panel as follows: Code: * Example generated by -dataex-. To install: ssc i…
Subscribe to:
Post Comments (Atom)
0 Response to Counting events falling in any 5 year window around the focal event
Post a Comment