Hi all,
I got a question regarding the reconstruction of my dataset using multiple if commands.I designed a fixed effects model and I would like to introduce auditor-firm fixed effects into the model to check the robustness of my results. I obtained my data from compustat and used the variable AU to identify the auditor for each observation. AU is a categorical variable that indicates 1 for Arthur Anderson, 2 for Arthur Young (prior to 1989) etc. My sample period range from 1980 until 2000 and therefore it includes several audit firm mergers. Some observations are for example audited by Arthur Young (au=2) before 1989, but are audited by Ernst & Young (au=4) after 1989. Therefore, they are still audited by the same auditor, but they would be considered as a different group since AU changed from 2 to 4.
If I would use command reghdfe ..... , a(au#gvkey), stata would identify the pre-merger and post-merger observations as different groups, which is incorrect because the firm is still audited by the same auditor. I would like to restructure the data in a way that stata could identify the pre- and post-merger observations as one group. This would mean that the observation should be identified as AU=2 after 1989, because stata would then recognize it as a single group (which is plausible because the firm is still audited by the same auditor).
I am not sure how I could implement this in stata. I think I should use the replace if command, but I don't know how to use multiple commands for different variables (au & year at once). Could somebody assist me on this? Thanks a lot!
Related Posts with Restructuring of variables using multiple if conditions
Using Restricted Maximum Likelihood in random-effects meta-analysis for binary outcomesI'm coming from R, so I'm hoping to find an easy way to get a similar output with Stata. I know that…
T-Test with foreach (for 4 Variables)Hey listers, I want to do a t-test for 4 variables (buy1,sell1, buy2, sell2) (they all match certain…
'codebook' throws error with complicated missings and large samplesI'm attempting to summarize and review a new dataset using 'codebook' and am encountering an error. …
Referencing first non-omitted level of factor variable?I'm trying to put a title over a factor variable by using the refcat command of esttab. However, the…
New version of cprdlinkutil on SSCThanks as always to Kit Baum, a new version of the cprdlinkutil package is now available for downloa…
Subscribe to:
Post Comments (Atom)
0 Response to Restructuring of variables using multiple if conditions
Post a Comment