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
Explaining frailty modelsHi all, I am currently researching on waiting time of passengers (the time passengers stay at the st…
Dataset FormatHey everyone! I was wondering if anyone could shed light on the the ".data" file format? I'm trying…
Initial condition y_i,0 in a dynamic model with individual specific effects (following Chamberlain's approach)Dear all, I was wondering how the initial observation y_i,0 should look like in the following AR(1)…
Generate Event WindowHello, I would like to perform an event study in Stata. Unfortunately, I cannot apply this https://…
confused about restructuring data: reshaping? stacking? something else?Hi, I am using Stata 16.1 on Windows 10. I have attached two datasets: (1) a simple example of the s…
Subscribe to:
Post Comments (Atom)
0 Response to Restructuring of variables using multiple if conditions
Post a Comment