Hello!
My partner and I are currently working on our master thesis. We are investigating survival of CEOs in family firms in Norway. We are, at the moment, struggling to figure out how to perform a good survival analysis.
the data set looks something like this:
ID of company------------------ID of CEO------------------Year ------------------------- -------> several other independent covariates relevant to test
---------1--------------------------------1-------------------------2000
---------1--------------------------------1-------------------------2001
---------1--------------------------------2-------------------------2002
---------2--------------------------------3-------------------------2000
---------2--------------------------------3-------------------------2001
---------2--------------------------------3-------------------------2002
Other information:
1) We have constructed a instrumental variable for when a change of CEO occurs (which is the failure variable)
2) We have both left and right censoring (as we do not know the tenure of each CEO before nor after the specified time (2000-2015)
3) We set the data as panel data using "xtset"
4) We set the data ready for survival using "stset"
Example of how the do file could look like:
------------------------------------------------------------------------------------------------------------
xtset pcid yr
stset yr, id(pcid) failure(SuccessionD==1)
stcox LargestFamCEO_15304
stdescribe
sts graph, hazard
estat phtest, detail
-------------------------------------------------------------------------------------------------------------
We have tried Cox model, where our covariates are significant. But fail the Cox proportional assumption (we use "estat phtest, detail").
Long story short for the data: CEO is the patient, and being related to the family owning the company is the "medicine" we want to test.
We would be so thankful if anyone could point us in the right direction. We have looked through Chuck Huber's stata videos of the subject, and the survival manual in Stata. We are still, however, unsure of whether we do things correctly or not.
My partner and I are currently working on our master thesis. We are investigating survival of CEOs in family firms in Norway. We are, at the moment, struggling to figure out how to perform a good survival analysis.
the data set looks something like this:
ID of company------------------ID of CEO------------------Year ------------------------- -------> several other independent covariates relevant to test
---------1--------------------------------1-------------------------2000
---------1--------------------------------1-------------------------2001
---------1--------------------------------2-------------------------2002
---------2--------------------------------3-------------------------2000
---------2--------------------------------3-------------------------2001
---------2--------------------------------3-------------------------2002
Other information:
1) We have constructed a instrumental variable for when a change of CEO occurs (which is the failure variable)
2) We have both left and right censoring (as we do not know the tenure of each CEO before nor after the specified time (2000-2015)
3) We set the data as panel data using "xtset"
4) We set the data ready for survival using "stset"
Example of how the do file could look like:
------------------------------------------------------------------------------------------------------------
xtset pcid yr
stset yr, id(pcid) failure(SuccessionD==1)
stcox LargestFamCEO_15304
stdescribe
sts graph, hazard
estat phtest, detail
-------------------------------------------------------------------------------------------------------------
We have tried Cox model, where our covariates are significant. But fail the Cox proportional assumption (we use "estat phtest, detail").
Long story short for the data: CEO is the patient, and being related to the family owning the company is the "medicine" we want to test.
We would be so thankful if anyone could point us in the right direction. We have looked through Chuck Huber's stata videos of the subject, and the survival manual in Stata. We are still, however, unsure of whether we do things correctly or not.
Comment