Hi all,
I want to create a variable, SHORT_TEN, which means 'indicator variable equal to 1 if the auditor's tenure with the firm is less than three years, 0 otherwise'.
I want to do this by using the variable CURR_AUDSNC_DATE, meaning 'current auditor since event date' (year-month-day).
I want to calculate the tenure of the auditor since they work for the firm, until now (2022-01-15).
So, I want Stata to create a variable that calculates the amount of days between CURR_AUDSNC_DATE and the date of today. Does someone know how to do that?
Or if someone knows a better solution to calculate the tenure with this data, I would like to hear it.
I want to create a variable, SHORT_TEN, which means 'indicator variable equal to 1 if the auditor's tenure with the firm is less than three years, 0 otherwise'.
I want to do this by using the variable CURR_AUDSNC_DATE, meaning 'current auditor since event date' (year-month-day).
I want to calculate the tenure of the auditor since they work for the firm, until now (2022-01-15).
So, I want Stata to create a variable that calculates the amount of days between CURR_AUDSNC_DATE and the date of today. Does someone know how to do that?
Or if someone knows a better solution to calculate the tenure with this data, I would like to hear it.
Comment