q1C Wednesday January 10 14:17:40 2024 Page 1

___ ____ ____ ____ ____(R)

/__ / ____/ / ____/
___/ / /___/ / /___/
Statistics/Data analysis

User: 3 Assigment

1 . csdid Y treatment, ivar(i) time(t) gvar(g) notyet

.........................
Difference-in-difference with Multiple Time Periods

Number of obs = 3,000

Outcome model : least squares
Treatment model: inverse probability

Coefficient Std. err. z P>|z| [95% conf. interval]

g1
t_0_1 -1.827279 .1654663 -11.04 0.000 -2.151586 -1.502971
t_0_2 -2.935005 .2776038 -10.57 0.000 -3.479098 -2.390911
t_0_3 -.4186299 .3861914 -1.08 0.278 -1.175551 .3382913
t_0_4 -1.823494 .5647558 -3.23 0.001 -2.930395 -.716593
t_0_5 1.881485 .8296868 2.27 0.023 .255329 3.507641

g2
t_0_1 -1.10849 .2115427 -5.24 0.000 -1.523106 -.6938739
t_1_2 -2.584394 .2063761 -12.52 0.000 -2.988884 -2.179904
t_1_3 -2.173936 .315373 -6.89 0.000 -2.792056 -1.555817
t_1_4 5.712084 .5199219 10.99 0.000 4.693056 6.731112
t_1_5 10.36026 .7628725 13.58 0.000 8.865059 11.85546

g3
t_0_1 -.8938545 .2808889 -3.18 0.001 -1.444387 -.3433224
t_1_2 -.8748905 .2736832 -3.20 0.001 -1.4113 -.3384813
t_2_3 -2.550707 .2584927 -9.87 0.000 -3.057343 -2.044071
t_2_4 -.0040222 .4246983 -0.01 0.992 -.8364156 .8283712
t_2_5 17.53443 .6812142 25.74 0.000 16.19927 18.86958

g4
t_0_1 .5809841 .295966 1.96 0.050 .0009013 1.161067
t_1_2 .4749133 .2946012 1.61 0.107 -.1024943 1.052321
t_2_3 .3399883 .2973609 1.14 0.253 -.2428283 .9228049
t_3_4 -1.859461 .2489799 -7.47 0.000 -2.347453 -1.37147
t_3_5 5.513419 .494517 11.15 0.000 4.544184 6.482655

g5
t_0_1 2.156886 .2926193 7.37 0.000 1.583363 2.730409
t_1_2 2.089681 .2810353 7.44 0.000 1.538862 2.6405
t_2_3 2.451769 .2471498 9.92 0.000 1.967364 2.936173
t_3_4 2.407912 .2997998 8.03 0.000 1.820315 2.995509
t_4_5 -.7661217 .2585148 -2.96 0.003 -1.272801 -.259442

Control: Not yet Treated

See Callaway and Sant'Anna (2021) for details

2 . estat event
ATT by Periods Before and After treatment
Event Study:Dynamic effects

Coefficient Std. err. z P>|z| [95% conf. interval]

Pre_avg 1.223934 .1338836 9.14 0.000 .9615272 1.486341

Post_avg 1.824841 .3914532 4.66 0.000 1.057607 2.592075
Tm4 2.156886 .2926193 7.37 0.000 1.583363 2.730409
Tm3 1.567061 .2176261 7.20 0.000 1.140521 1.9936
Tm2 .9235875 .1813647 5.09 0.000 .5681193 1.279056
Tm1 .2482025 .1533792 1.62 0.106 -.0524152 .5488202
Tp0 -1.884758 .106256 -17.74 0.000 -2.093016 -1.6765
Tp1 -.8167991 .2531997 -3.23 0.001 -1.313061 -.3205368
Tp2 6.08566 .544638 11.17 0.000 5.018189 7.15313
Tp3 3.858616 .6640268 5.81 0.000 2.557148 5.160085
Tp4 1.881485 .8296868 2.27 0.023 .255329 3.507641
 q1C Wednesday January 10 14:17:41 2024 Page 2

3 . gen e=t-g+1

4 .
5 . replace e=0 if treatment==0
(1,123 real changes made)

6 . reg Y i.g i.t i.g i.e if t==0

note: 0.t omitted because of collinearity.
note: 0.e omitted because of collinearity.

Source SS df MS Number of obs = 500

F(5, 494) = 123.34
Model 1288.25157 5 257.650314 Prob > F = 0.0000
Residual 1031.95 494 2.08896762 R-squared = 0.5552
Adj R-squared = 0.5507
Total 2320.20157 499 4.64970255 Root MSE = 1.4453

Y Coefficient Std. err. t P>|t| [95% conf. interval]

g
1 .0667807 .2386814 0.28 0.780 -.4021753 .5357366
2 1.060907 .2439277 4.35 0.000 .5816429 1.54017
3 2.041189 .2623672 7.78 0.000 1.525696 2.556683
4 3.254013 .280765 11.59 0.000 2.702372 3.805654
5 4.227979 .2455691 17.22 0.000 3.745491 4.710468

0.t 0 (omitted)
0.e 0 (omitted)
_cons .9173852 .1985308 4.62 0.000 .5273163 1.307454

7 . reg Y i.g i.t i.g i.e

Source SS df MS Number of obs = 3,000

F(15, 2984) = 667.43
Model 168643.959 15 11242.9306 Prob > F = 0.0000
Residual 50265.8273 2,984 16.8451164 R-squared = 0.7704
Adj R-squared = 0.7692
Total 218909.786 2,999 72.9942601 Root MSE = 4.1043

Y Coefficient Std. err. t P>|t| [95% conf. interval]

g
1 1.748854 .4180776 4.18 0.000 .9291047 2.568604
2 3.861073 .3597702 10.73 0.000 3.155651 4.566496
3 5.759653 .3398627 16.95 0.000 5.093264 6.426042
4 8.385547 .3389977 24.74 0.000 7.720854 9.05024
5 9.627819 .2887528 33.34 0.000 9.061644 10.19399

t
1 1.941583 .268577 7.23 0.000 1.414968 2.468197
2 -.2529906 .2893949 -0.87 0.382 -.8204243 .3144432
3 5.282179 .3192933 16.54 0.000 4.656121 5.908236
4 6.777936 .3610618 18.77 0.000 6.06998 7.485891
5 18.67876 .4414272 42.31 0.000 17.81323 19.54429

e
1 -1.850875 .2896768 -6.39 0.000 -2.418861 -1.282888
2 -.5667784 .3545064 -1.60 0.110 -1.26188 .1283233
3 5.731924 .4236338 13.53 0.000 4.90128 6.562568
4 1.290505 .5168008 2.50 0.013 .2771826 2.303827
5 -5.509859 .6784356 -8.12 0.000 -6.840108 -4.17961

_cons -2.217315 .3252063 -6.82 0.000 -2.854966 -1.579664

 q1C Wednesday January 10 14:17:41 2024 Page 3

8 . reg Y i.g i.t i.e if t==0

note: 0.t omitted because of collinearity.
note: 0.e omitted because of collinearity.

Source SS df MS Number of obs = 500

F(5, 494) = 123.34
Model 1288.25157 5 257.650314 Prob > F = 0.0000
Residual 1031.95 494 2.08896762 R-squared = 0.5552
Adj R-squared = 0.5507
Total 2320.20157 499 4.64970255 Root MSE = 1.4453

Y Coefficient Std. err. t P>|t| [95% conf. interval]

g
1 .0667807 .2386814 0.28 0.780 -.4021753 .5357366
2 1.060907 .2439277 4.35 0.000 .5816429 1.54017
3 2.041189 .2623672 7.78 0.000 1.525696 2.556683
4 3.254013 .280765 11.59 0.000 2.702372 3.805654
5 4.227979 .2455691 17.22 0.000 3.745491 4.710468

0.t 0 (omitted)
0.e 0 (omitted)
_cons .9173852 .1985308 4.62 0.000 .5273163 1.307454

9 . reg Y i.g i.t i.e c.placebo_dg

variable placebo_dg not found
r(111);

10 . reg Y i.g i.t i.e if e>0

note: 5.e omitted because of collinearity.

Source SS df MS Number of obs = 1,430

F(11, 1418) = 514.12
Model 122138.727 11 11103.5207 Prob > F = 0.0000
Residual 30624.7492 1,418 21.5971433 R-squared = 0.7995
Adj R-squared = 0.7980
Total 152763.477 1,429 106.902363 Root MSE = 4.6473

Y Coefficient Std. err. t P>|t| [95% conf. interval]

g
2 3.793388 .3119108 12.16 0.000 3.181532 4.405245
3 7.491313 .4240835 17.66 0.000 6.659415 8.323212
4 10.54206 .5927378 17.79 0.000 9.37932 11.70479
5 10.61984 .6304443 16.85 0.000 9.383136 11.85654

t
2 -5.492079 .5797335 -9.47 0.000 -6.629307 -4.354852
3 -2.300008 .5919895 -3.89 0.000 -3.461277 -1.138739
4 -.899659 .6330402 -1.42 0.155 -2.141455 .3421369
5 11.60758 .6024759 19.27 0.000 10.42574 12.78942

e
2 2.779509 .3584787 7.75 0.000 2.076303 3.482714
3 10.22791 .4110511 24.88 0.000 9.421572 11.03424
4 6.339926 .4953248 12.80 0.000 5.368278 7.311575
5 0 (omitted)

_cons 1.092854 .4260148 2.57 0.010 .2571671 1.928541

 q1C Wednesday January 10 14:17:42 2024 Page 4

11 . reg Y i.g i.t i.e if t==3

note: 3.t omitted because of collinearity.
note: 1.e omitted because of collinearity.
note: 2.e omitted because of collinearity.
note: 3.e omitted because of collinearity.

Source SS df MS Number of obs = 500

F(5, 494) = 98.52
Model 6966.13095 5 1393.22619 Prob > F = 0.0000
Residual 6985.9831 494 14.1416662 R-squared = 0.4993
Adj R-squared = 0.4942
Total 13952.1141 499 27.9601484 Root MSE = 3.7605

Y Coefficient Std. err. t P>|t| [95% conf. interval]

g
1 4.385284 .6210164 7.06 0.000 3.165124 5.605443
2 2.286502 .6346664 3.60 0.000 1.039524 3.533481
3 2.45887 .6826436 3.60 0.000 1.117627 3.800113
4 9.027896 .730512 12.36 0.000 7.592602 10.46319
5 10.92632 .638937 17.10 0.000 9.670946 12.18168

3.t 0 (omitted)

e
1 0 (omitted)
2 0 (omitted)
3 0 (omitted)

_cons 3.889311 .51655 7.53 0.000 2.874405 4.904217

12 . reg Y i.g i.t i.e if treatment==1

note: 5.e omitted because of collinearity.

Source SS df MS Number of obs = 1,430

F(11, 1418) = 514.12
Model 122138.727 11 11103.5207 Prob > F = 0.0000
Residual 30624.7492 1,418 21.5971433 R-squared = 0.7995
Adj R-squared = 0.7980
Total 152763.477 1,429 106.902363 Root MSE = 4.6473

Y Coefficient Std. err. t P>|t| [95% conf. interval]

g
2 3.793388 .3119108 12.16 0.000 3.181532 4.405245
3 7.491313 .4240835 17.66 0.000 6.659415 8.323212
4 10.54206 .5927378 17.79 0.000 9.37932 11.70479
5 10.61984 .6304443 16.85 0.000 9.383136 11.85654

t
2 -5.492079 .5797335 -9.47 0.000 -6.629307 -4.354852
3 -2.300008 .5919895 -3.89 0.000 -3.461277 -1.138739
4 -.899659 .6330402 -1.42 0.155 -2.141455 .3421369
5 11.60758 .6024759 19.27 0.000 10.42574 12.78942

e
2 2.779509 .3584787 7.75 0.000 2.076303 3.482714
3 10.22791 .4110511 24.88 0.000 9.421572 11.03424
4 6.339926 .4953248 12.80 0.000 5.368278 7.311575
5 0 (omitted)

_cons 1.092854 .4260148 2.57 0.010 .2571671 1.928541

 q1C Wednesday January 10 14:17:42 2024 Page 5

13 . reg Y i.g i.t i.e if treatment==0

note: 0.e omitted because of collinearity.

Source SS df MS Number of obs = 1,570

F(10, 1559) = 353.55
Model 33609.0794 10 3360.90794 Prob > F = 0.0000
Residual 14820.1379 1,559 9.5061821 R-squared = 0.6940
Adj R-squared = 0.6920
Total 48429.2173 1,569 30.8662953 Root MSE = 3.0832

Y Coefficient Std. err. t P>|t| [95% conf. interval]

g
1 2.78608 .3753711 7.42 0.000 2.049795 3.522366
2 3.377251 .3069968 11.00 0.000 2.775081 3.979421
3 4.251736 .295727 14.38 0.000 3.671671 4.831801
4 6.915216 .2895159 23.89 0.000 6.347335 7.483098
5 8.669587 .2342749 37.01 0.000 8.210059 9.129114

t
1 1.935967 .2233858 8.67 0.000 1.497798 2.374135
2 .5424952 .252889 2.15 0.032 .0464569 1.038534
3 7.330278 .2823539 25.96 0.000 6.776444 7.884111
4 7.572233 .3157617 23.98 0.000 6.95287 8.191595
5 12.55409 .4902871 25.61 0.000 11.5924 13.51578

0.e 0 (omitted)
_cons -1.801914 .2470214 -7.29 0.000 -2.286444 -1.317385

14 .