I am working on a hedge funds dataset. I wanted to create a regression tables. For creating regression tables I needed a dependent variable which is failure in my case.

I would like to know if I can create a variable where in following condition satisfies:
Date 10may2010 fund1 —0 10june2010 fund1 —-0 10july2010 fund1—1
By this I mean the fund was active for 2 months and failed in 3rd month:

Is there a possibility that I can create something like this?

Your help is really appreciated.

Thank you.