Hello everyone, I am trying to construct an overconfidence measure, namely Holder 67. The director will be defined as an overconfident if her exercisable options in the moneyness are at least 67% in two successive years. I have constructed the variable moneyness. However, I need help for the construction of Holder 67, which needs to equal or exceeds 67% of moneyness for two consecutive years.
So far I have tried the following code, which does not generate the desired results. I would really appreciate some guidance. Thank you in advance.
install dataex
clear input byte Director int year float moneyness end sort Director year by ceo: generate Holder67 = sum(conf>=.67) by ceo: replace Holder67 = 0 if Holder67[_N]<2 by ceo: replace Holder67 = 1 if Holder67>1
Related Posts with Generating Dummy variable for two consecutive years with the condition that the dummy will be equal to a percentage of another variable
Right way to extract Confidence Intervals of coefficients of interaction term- hyperlink in Stata graph
- Trying to replace a variable with a new generated variable
- spline function in propensity score matching method is not getting installed in my stata.
- Receiver operating characteristic curve for binary predictor after melogit
Subscribe to:
Post Comments (Atom)
0 Response to Generating Dummy variable for two consecutive years with the condition that the dummy will be equal to a percentage of another variable
Post a Comment