Hello,
I am trying to understand the impact of a health care solution on per member per month cost of healthcare from Claims data. The program implementation month varies for each member as it depends on when they activate the program. I have about 9 months of pre-program data and then one year where the program was available to all Members and they all activated at different times.
My xtdidregress results look like this:
. xtdidregress (total_allowed) (post), group(membernum) time(monthcont)
Number of groups and treatment time
Time variable: monthcont
Control: post = 0
Treatment: post = 1
-----------------------------------
| Control Treatment
-------------+---------------------
Group |
membernum | 498 496
-------------+---------------------
Time |
Minimum | 1 8
Maximum | 1 16
-----------------------------------
Difference-in-differences regression Number of obs = 18,886
Data type: Longitudinal
(Std. err. adjusted for 994 clusters in membernum)
------------------------------------------------------------------------------
| Robust
total_allo~d | Coefficient std. err. t P>|t| [95% conf. interval]
-------------+----------------------------------------------------------------
ATET |
post |
(1 vs 0) | -681.8773 876.5132 -0.78 0.437 -2401.908 1038.154
------------------------------------------------------------------------------
Note: ATET estimate adjusted for panel effects and time effects.
Whereas my csdid results look like this
. csdid total_allowed, i(membernum) time(monthcont) gvar(activation_month_monthcont)
No never treated observations found. Using Not yet treated data
..................................................
..................................................
..................................................
..................................................
................xxxxxxxxxxxxxxxxxx
Difference-in-difference with Multiple Time Periods
Number of obs = 9,804
Outcome model : regression adjustment
Treatment model: none
------------------------------------------------------------------------------
| Coefficient Std. err. z P>|z| [95% conf. interval]
-------------+----------------------------------------------------------------
g8 |
t_1_2 | 2413.011 1557.6 1.55 0.121 -639.8299 5465.852
t_2_3 | 738.025 978.62 0.75 0.451 -1180.035 2656.085
t_3_4 | -1742.566 2322.006 -0.75 0.453 -6293.615 2808.482
t_4_5 | 3439.818 4120.801 0.83 0.404 -4636.803 11516.44
t_5_6 | -3737.644 4047.542 -0.92 0.356 -11670.68 4195.393
t_6_7 | 2109.66 1492.769 1.41 0.158 -816.1128 5035.433
t_7_8 | -1831.654 1451.193 -1.26 0.207 -4675.939 1012.631
t_7_9 | -978.8183 1619.831 -0.60 0.546 -4153.629 2195.992
t_7_10 | -3107.383 1984.5 -1.57 0.117 -6996.931 782.1653
t_7_11 | -13812.28 7847.867 -1.76 0.078 -29193.82 1569.254
t_7_12 | -4866.734 5686.729 -0.86 0.392 -16012.52 6279.05
t_7_13 | -8216.169 9123.062 -0.90 0.368 -26097.04 9664.705
t_7_14 | -7644.596 7347.719 -1.04 0.298 -22045.86 6756.669
t_7_15 | 3141.352 5334.031 0.59 0.556 -7313.157 13595.86
t_7_16 | -1386.692 1496.887 -0.93 0.354 -4320.536 1547.153
t_7_17 | -393.5946 1568.474 -0.25 0.802 -3467.747 2680.558
t_7_18 | -161.3823 1671.064 -0.10 0.923 -3436.608 3113.844
t_7_19 | -1983.064 1693.167 -1.17 0.242 -5301.611 1335.483
-------------+----------------------------------------------------------------
g9 |
t_1_2 | -5947.685 5738.571 -1.04 0.300 -17195.08 5299.706
t_2_3 | 1310.243 1163.599 1.13 0.260 -970.3691 3590.855
t_3_4 | -3222.966 3210.678 -1.00 0.315 -9515.78 3069.847
t_4_5 | -2310.87 1734.721 -1.33 0.183 -5710.86 1089.121
t_5_6 | 4199.424 2764.922 1.52 0.129 -1219.723 9618.572
t_6_7 | -2314.037 2213.014 -1.05 0.296 -6651.466 2023.392
t_7_8 | 600.1207 377.8416 1.59 0.112 -140.4351 1340.677
t_8_9 | -527.6483 346.7358 -1.52 0.128 -1207.238 151.9413
t_8_10 | -1627.864 1393.088 -1.17 0.243 -4358.266 1102.538
t_8_11 | -13817.06 7480.405 -1.85 0.065 -28478.38 844.2658
t_8_12 | -5426.549 5315.599 -1.02 0.307 -15844.93 4991.833
t_8_13 | -5964.215 9071.575 -0.66 0.511 -23744.18 11815.75
t_8_14 | -4301.294 7571.526 -0.57 0.570 -19141.21 10538.62
t_8_15 | 3186.897 3152.748 1.01 0.312 -2992.375 9366.169
t_8_16 | 10541.09 9162.531 1.15 0.250 -7417.141 28499.32
t_8_17 | 512.4385 566.0181 0.91 0.365 -596.9366 1621.814
t_8_18 | 291.7162 864.9723 0.34 0.736 -1403.598 1987.031
t_8_19 | 487.5433 1444.668 0.34 0.736 -2343.954 3319.041
-------------+----------------------------------------------------------------
g10 |
t_1_2 | -14.4397 138.5633 -0.10 0.917 -286.0189 257.1394
t_2_3 | 593.5153 553.7621 1.07 0.284 -491.8384 1678.869
t_3_4 | -493.2139 546.1885 -0.90 0.367 -1563.724 577.296
t_4_5 | 8415.441 8716.804 0.97 0.334 -8669.181 25500.06
t_5_6 | -7263.901 8514.142 -0.85 0.394 -23951.31 9423.51
t_6_7 | -197.2962 1415.894 -0.14 0.889 -2972.397 2577.805
t_7_8 | -907.4951 1037.896 -0.87 0.382 -2941.734 1126.743
t_8_9 | -3.788006 358.6174 -0.01 0.992 -706.6652 699.0891
t_9_10 | 38971.07 23927.72 1.63 0.103 -7926.397 85868.53
t_9_11 | -14457.49 7451.092 -1.94 0.052 -29061.36 146.3865
t_9_12 | -4827.638 5453.202 -0.89 0.376 -15515.72 5860.441
t_9_13 | -9187.64 8807.594 -1.04 0.297 -26450.21 8074.927
t_9_14 | -7324.702 7160.173 -1.02 0.306 -21358.38 6708.98
t_9_15 | -996.4504 577.6921 -1.72 0.085 -2128.706 135.8053
t_9_16 | 195.9426 777.5793 0.25 0.801 -1328.085 1719.97
t_9_17 | 120.1163 463.4531 0.26 0.795 -788.235 1028.468
t_9_18 | -432.3896 435.3778 -0.99 0.321 -1285.714 420.9353
t_9_19 | 227.2957 1422.497 0.16 0.873 -2560.746 3015.338
-------------+----------------------------------------------------------------
g11 |
t_1_2 | 575.6311 367.5341 1.57 0.117 -144.7225 1295.985
t_2_3 | -568.6662 362.7375 -1.57 0.117 -1279.619 142.2862
t_3_4 | 49.61945 65.72968 0.75 0.450 -79.20835 178.4472
t_4_5 | -641.3846 591.7948 -1.08 0.278 -1801.281 518.5119
t_5_6 | 540.7838 599.2793 0.90 0.367 -633.7821 1715.35
t_6_7 | 87.16287 124.2176 0.70 0.483 -156.2992 330.6249
t_7_8 | -337.4202 244.3019 -1.38 0.167 -816.2432 141.4027
t_8_9 | 476.1524 396.5439 1.20 0.230 -301.0593 1253.364
t_9_10 | -622.0626 2171.35 -0.29 0.775 -4877.83 3633.705
t_10_11 | -12663.33 7836.434 -1.62 0.106 -28022.45 2695.803
t_10_12 | 1291.459 6886.467 0.19 0.851 -12205.77 14788.69
t_10_13 | -5962.488 9512.492 -0.63 0.531 -24606.63 12681.65
t_10_14 | 2775.73 11003.12 0.25 0.801 -18789.99 24341.45
t_10_15 | -2063.279 1354.5 -1.52 0.128 -4718.051 591.4925
t_10_16 | -1129.78 1320.829 -0.86 0.392 -3718.558 1458.998
t_10_17 | 711.879 1624.985 0.44 0.661 -2473.033 3896.791
t_10_18 | -1318.808 1249.634 -1.06 0.291 -3768.045 1130.43
t_10_19 | -1864.876 1540.959 -1.21 0.226 -4885.101 1155.349
-------------+----------------------------------------------------------------
g12 |
t_1_2 | -28.5208 69.20077 -0.41 0.680 -164.1518 107.1102
t_2_3 | 20.25091 87.2009 0.23 0.816 -150.6597 191.1615
t_3_4 | -2.600366 68.65269 -0.04 0.970 -137.1572 131.9564
t_4_5 | -345.9046 977.6137 -0.35 0.723 -2261.992 1570.183
t_5_6 | 419.0391 991.8096 0.42 0.673 -1524.872 2362.95
t_6_7 | -175.976 118.8622 -1.48 0.139 -408.9416 56.98971
t_7_8 | 610.6593 511.621 1.19 0.233 -392.0994 1613.418
t_8_9 | 21.27032 804.6844 0.03 0.979 -1555.882 1598.423
t_9_10 | -3187.432 2693.31 -1.18 0.237 -8466.222 2091.358
t_10_11 | 701.6676 15058.65 0.05 0.963 -28812.75 30216.09
t_11_12 | -3683.585 15604.97 -0.24 0.813 -34268.76 26901.6
t_11_13 | -4036.239 18351.43 -0.22 0.826 -40004.39 31931.91
t_11_14 | 1046.542 20507.44 0.05 0.959 -39147.31 41240.39
t_11_15 | 25077.25 26238.71 0.96 0.339 -26349.68 76504.18
t_11_16 | -13096.59 11306.34 -1.16 0.247 -35256.61 9063.431
t_11_17 | -12294.26 11321.76 -1.09 0.278 -34484.51 9895.98
t_11_18 | -11760.31 11420.56 -1.03 0.303 -34144.19 10623.57
t_11_19 | -13401.71 11363.85 -1.18 0.238 -35674.44 8871.025
-------------+----------------------------------------------------------------
g13 |
t_1_2 | 87.22608 120.246 0.73 0.468 -148.4517 322.9038
t_2_3 | 15.79733 64.88187 0.24 0.808 -111.3688 142.9635
t_3_4 | 39.14399 193.2518 0.20 0.839 -339.6226 417.9106
t_4_5 | 4941.776 4887.111 1.01 0.312 -4636.786 14520.34
t_5_6 | -5066.34 4966.664 -1.02 0.308 -14800.82 4668.143
t_6_7 | 395.9956 434.5907 0.91 0.362 -455.7866 1247.778
t_7_8 | 321.8059 786.2214 0.41 0.682 -1219.16 1862.772
t_8_9 | -470.8186 538.4378 -0.87 0.382 -1526.137 584.5
t_9_10 | -3083.443 3125.834 -0.99 0.324 -9209.965 3043.08
t_10_11 | -15193.24 11857.28 -1.28 0.200 -38433.08 8046.597
t_11_12 | 16304.92 13790.79 1.18 0.237 -10724.53 43334.36
t_12_13 | -5411.161 11284.64 -0.48 0.632 -27528.65 16706.33
t_12_14 | -1543.09 12319.87 -0.13 0.900 -25689.59 22603.41
t_12_15 | 7791.391 13462.14 0.58 0.563 -18593.91 34176.7
t_12_16 | -3977.202 4631.667 -0.86 0.391 -13055.1 5100.699
t_12_17 | -4499.681 4500.721 -1.00 0.317 -13320.93 4321.57
t_12_18 | -3672.203 3923.661 -0.94 0.349 -11362.44 4018.032
t_12_19 | 39937.14 38520.43 1.04 0.300 -35561.52 115435.8
-------------+----------------------------------------------------------------
g14 |
t_1_2 | 11.01271 93.41436 0.12 0.906 -172.0761 194.1015
t_2_3 | 21.80897 80.43034 0.27 0.786 -135.8316 179.4495
t_3_4 | -3.950014 46.59644 -0.08 0.932 -95.27736 87.37733
t_4_5 | 188.5827 155.597 1.21 0.226 -116.3818 493.5471
t_5_6 | -4.134538 165.7075 -0.02 0.980 -328.9154 320.6463
t_6_7 | -106.4165 131.5952 -0.81 0.419 -364.3383 151.5053
t_7_8 | -289.063 234.1032 -1.23 0.217 -747.8969 169.7709
t_8_9 | 590.7348 293.8086 2.01 0.044 14.88054 1166.589
t_9_10 | -4459.183 4343.541 -1.03 0.305 -12972.37 4054.001
t_10_11 | -7867.677 18508.2 -0.43 0.671 -44143.07 28407.72
t_11_12 | 3715.006 20030.14 0.19 0.853 -35543.34 42973.36
t_12_13 | 39693.32 31909.96 1.24 0.214 -22849.06 102235.7
t_13_14 | -37652.96 31563.96 -1.19 0.233 -99517.18 24211.26
t_13_15 | -31852.73 30697.96 -1.04 0.299 -92019.63 28314.16
t_13_16 | -22826.53 32244.4 -0.71 0.479 -86024.39 40371.32
t_13_17 | -31391.53 30708.66 -1.02 0.307 -91579.4 28796.34
t_13_18 | -31549.32 30674.04 -1.03 0.304 -91669.33 28570.69
t_13_19 | -32343.61 30694.59 -1.05 0.292 -92503.9 27816.67
-------------+----------------------------------------------------------------
g15 |
t_1_2 | 31.76576 137.2799 0.23 0.817 -237.2979 300.8294
t_2_3 | 17.25459 117.0905 0.15 0.883 -212.2386 246.7477
t_3_4 | 44.06365 79.28775 0.56 0.578 -111.3375 199.4648
t_4_5 | -74.08912 54.19563 -1.37 0.172 -180.3106 32.13237
t_5_6 | 120.4344 69.44929 1.73 0.083 -15.68371 256.5525
t_6_7 | 5.684705 143.5776 0.04 0.968 -275.7223 287.0917
t_7_8 | -47.11638 363.0076 -0.13 0.897 -758.5983 664.3655
t_8_9 | 158.1434 316.7181 0.50 0.618 -462.6127 778.8995
t_9_10 | 13552.65 13215.94 1.03 0.305 -12350.12 39455.42
t_10_11 | -45357.18 26093.93 -1.74 0.082 -96500.35 5785.995
t_11_12 | 18556.8 26202.93 0.71 0.479 -32799.99 69913.59
t_12_13 | 12655.35 12713.87 1.00 0.320 -12263.39 37574.08
t_13_14 | -10085.96 10486.13 -0.96 0.336 -30638.4 10466.47
t_14_15 | 10415.54 10419.03 1.00 0.317 -10005.39 30836.46
t_14_16 | 20682.96 19405.24 1.07 0.286 -17350.62 58716.53
t_14_17 | 395.0887 449.283 0.88 0.379 -485.4898 1275.667
t_14_18 | -308.1028 287.7749 -1.07 0.284 -872.1312 255.9256
t_14_19 | -380.8722 887.2825 -0.43 0.668 -2119.914 1358.169
-------------+----------------------------------------------------------------
g16 |
t_1_2 | -365.3907 274.454 -1.33 0.183 -903.3106 172.5292
t_2_3 | 253.1077 222.2578 1.14 0.255 -182.5095 688.725
t_3_4 | -50.04962 127.5593 -0.39 0.695 -300.0613 199.9621
t_4_5 | -75.12328 85.0183 -0.88 0.377 -241.7561 91.50952
t_5_6 | -32.59038 112.0859 -0.29 0.771 -252.2748 187.094
t_6_7 | 260.7692 249.8886 1.04 0.297 -229.0034 750.5418
t_7_8 | -667.9001 518.3165 -1.29 0.198 -1683.782 347.9816
t_8_9 | 355.7108 415.1914 0.86 0.392 -458.0494 1169.471
t_9_10 | 132.1937 107.558 1.23 0.219 -78.61611 343.0036
t_10_11 | 67012.21 46129.92 1.45 0.146 -23400.78 157425.2
t_11_12 | -39690.7 54899.15 -0.72 0.470 -147291.1 67909.65
t_12_13 | -26278.57 26461.32 -0.99 0.321 -78141.79 25584.66
t_13_14 | -21090.57 19657.51 -1.07 0.283 -59618.58 17437.45
t_14_15 | 19611.27 19528.92 1.00 0.315 -18664.7 57887.24
t_15_16 | 24973.96 22485.6 1.11 0.267 -19097 69044.93
t_15_17 | 2468.15 2186.999 1.13 0.259 -1818.29 6754.589
t_15_18 | 836.8999 914.7263 0.91 0.360 -955.9307 2629.73
t_15_19 | 484.4572 1511.984 0.32 0.749 -2478.977 3447.892
-------------+----------------------------------------------------------------
g17 |
t_1_2 | 227.6724 317.4141 0.72 0.473 -394.4479 849.7927
t_2_3 | -425.2896 398.7306 -1.07 0.286 -1206.787 356.208
t_3_4 | -5.66883 24.13568 -0.23 0.814 -52.97389 41.63623
t_4_5 | -66.4653 88.05049 -0.75 0.450 -239.0411 106.1105
t_5_6 | 86.53354 90.33501 0.96 0.338 -90.51982 263.5869
t_6_7 | 23.99706 37.148 0.65 0.518 -48.81169 96.8058
t_7_8 | -40.24587 601.1852 -0.07 0.947 -1218.547 1138.055
t_8_9 | 38.99763 596.6739 0.07 0.948 -1130.462 1208.457
t_9_10 | 167.8253 134.3069 1.25 0.211 -95.41139 431.062
t_10_11 | 268.9353 97.82905 2.75 0.006 77.19387 460.6767
t_11_12 | -232.9221 221.8151 -1.05 0.294 -667.6718 201.8275
t_12_13 | 52.33254 183.4857 0.29 0.775 -307.2929 411.958
t_13_14 | 134415.7 109768 1.22 0.221 -80725.64 349557.1
t_14_15 | -134163.8 108704.6 -1.23 0.217 -347221 78893.29
t_15_16 | 1524.28 1014.441 1.50 0.133 -463.987 3512.547
t_16_17 | -1135.244 882.6206 -1.29 0.198 -2865.148 594.6609
t_16_18 | -2101.454 1529.578 -1.37 0.169 -5099.372 896.4649
t_16_19 | -2910.872 1801.758 -1.62 0.106 -6442.253 620.5088
-------------+----------------------------------------------------------------
g18 |
t_1_2 | 226.9079 232.8 0.97 0.330 -229.3718 683.1875
t_2_3 | -293.7504 227.9276 -1.29 0.197 -740.4802 152.9794
t_3_4 | -79.27144 46.45663 -1.71 0.088 -170.3248 11.78188
t_4_5 | -211.7149 148.44 -1.43 0.154 -502.6519 79.22219
t_5_6 | 155.2379 150.3373 1.03 0.302 -139.4177 449.8935
t_6_7 | 89.21585 63.36422 1.41 0.159 -34.97573 213.4074
t_7_8 | -619.3127 780.456 -0.79 0.427 -2148.978 910.3529
t_8_9 | 972.9084 792.9242 1.23 0.220 -581.1945 2527.011
t_9_10 | -308.0966 214.6789 -1.44 0.151 -728.8595 112.6663
t_10_11 | 79.84828 31.77692 2.51 0.012 17.56666 142.1299
t_11_12 | -184.2416 205.6794 -0.90 0.370 -587.3658 218.8827
t_12_13 | 37.68445 231.8408 0.16 0.871 -416.7152 492.0841
t_13_14 | 101.5707 105.2853 0.96 0.335 -104.7848 307.9262
t_14_15 | 2598.038 2139.084 1.21 0.225 -1594.49 6790.566
t_15_16 | -2597.289 2164.641 -1.20 0.230 -6839.907 1645.329
t_16_17 | 100.4896 73.42879 1.37 0.171 -43.42822 244.4074
t_17_18 | -56.248 245.7812 -0.23 0.819 -537.9703 425.4743
t_17_19 | 79.92223 1196.879 0.07 0.947 -2265.918 2425.762
-------------+----------------------------------------------------------------
g19 |
t_1_2 | 472.85 . . . . .
t_2_3 | 749.89 1.08e-13 7.0e+15 0.000 749.89 749.89
t_3_4 | 260.8779 11.52322 22.64 0.000 238.2928 283.463
t_4_5 | -91.00224 153.4348 -0.59 0.553 -391.729 209.7245
t_5_6 | 245.0943 164.9581 1.49 0.137 -78.21753 568.4062
t_6_7 | -607.33 . . . . .
t_7_8 | -2404.297 805.1396 -2.99 0.003 -3982.341 -826.2519
t_8_9 | 1000.308 806.0238 1.24 0.215 -579.4699 2580.085
t_9_10 | -80.42 45.6268 -1.76 0.078 -169.8469 9.006895
t_10_11 | 80.60444 33.6353 2.40 0.017 14.68047 146.5284
t_11_12 | -355.77 194.1435 -1.83 0.067 -736.2844 24.74433
t_12_13 | 225.2589 231.6882 0.97 0.331 -228.8416 679.3594
t_13_14 | 47.72777 103.7811 0.46 0.646 -155.6794 251.135
t_14_15 | 40.49333 75.3182 0.54 0.591 -107.1276 188.1143
t_15_16 | -.5244437 48.18157 -0.01 0.991 -94.95859 93.9097
t_16_17 | -15.22111 29.05663 -0.52 0.600 -72.17105 41.72884
t_17_18 | -266.6756 252.8688 -1.05 0.292 -762.2893 228.9382
t_18_19 | -655.4622 528.6882 -1.24 0.215 -1691.672 380.7476
-------------+----------------------------------------------------------------
g20 |
t_1_2 | 0 (omitted)
t_2_3 | 0 (omitted)
t_3_4 | 0 (omitted)
t_4_5 | 0 (omitted)
t_5_6 | 0 (omitted)
t_6_7 | 0 (omitted)
t_7_8 | 0 (omitted)
t_8_9 | 0 (omitted)
t_9_10 | 0 (omitted)
t_10_11 | 0 (omitted)
t_11_12 | 0 (omitted)
t_12_13 | 0 (omitted)
t_13_14 | 0 (omitted)
t_14_15 | 0 (omitted)
t_15_16 | 0 (omitted)
t_16_17 | 0 (omitted)
t_17_18 | 0 (omitted)
t_18_19 | 0 (omitted)
------------------------------------------------------------------------------
Control: Not yet Treated
See Callaway and Sant'Anna (2021) for details
. estat event
ATT by Periods Before and After treatment
Event Study:Dynamic effects
------------------------------------------------------------------------------
| Coefficient Std. err. z P>|z| [95% conf. interval]
-------------+----------------------------------------------------------------
Pre_avg | 86.63651 126.4505 0.69 0.493 -161.202 334.475
Post_avg | -2776.03 2018.926 -1.38 0.169 -6733.052 1180.993
Tm17 | 472.85 . . . . .
Tm16 | 292.2806 202.4182 1.44 0.149 -104.4517 689.0129
Tm15 | -101.1235 196.7657 -0.51 0.607 -486.7772 284.5303
Tm14 | -293.0622 181.8659 -1.61 0.107 -649.5129 63.38848
Tm13 | 82.42142 97.35175 0.85 0.397 -108.3845 273.2274
Tm12 | -.9868379 69.17678 -0.01 0.989 -136.5708 134.5972
Tm11 | -3.465116 46.17736 -0.08 0.940 -93.97109 87.04085
Tm10 | -49.12482 51.01227 -0.96 0.336 -149.107 50.85739
Tm9 | 270.6987 116.4527 2.32 0.020 42.45568 498.9417
Tm8 | 135.6721 355.1604 0.38 0.702 -560.4295 831.7736
Tm7 | -1330.926 1171.007 -1.14 0.256 -3626.058 964.2057
Tm6 | 1170.847 802.3136 1.46 0.144 -401.6584 2743.353
Tm5 | 3686.439 2046.452 1.80 0.072 -324.5323 7697.411
Tm4 | -4839.008 3133.68 -1.54 0.123 -10980.91 1302.892
Tm3 | 2072.816 2518.44 0.82 0.410 -2863.235 7008.868
Tm2 | -3667.093 2475.017 -1.48 0.138 -8518.037 1183.85
Tm1 | 3573.584 1946.767 1.84 0.066 -242.0097 7389.178
Tp0 | 430.5019 3244.946 0.13 0.894 -5929.476 6790.48
Tp1 | -2739.139 2739.627 -1.00 0.317 -8108.709 2630.43
Tp2 | -4576.042 2958.847 -1.55 0.122 -10375.28 1223.193
Tp3 | -6831.446 4151.487 -1.65 0.100 -14968.21 1305.318
Tp4 | -6723.597 3860.199 -1.74 0.082 -14289.45 842.2533
Tp5 | -7677.503 6193.234 -1.24 0.215 -19816.02 4461.012
Tp6 | -3364.055 4329.386 -0.78 0.437 -11849.5 5121.384
Tp7 | 1471.064 3357.137 0.44 0.661 -5108.804 8050.931
Tp8 | -1077.164 947.6827 -1.14 0.256 -2934.588 780.2597
Tp9 | -199.7646 1138.611 -0.18 0.861 -2431.402 2031.872
Tp10 | -42.14509 1417.086 -0.03 0.976 -2819.583 2735.293
Tp11 | -1983.064 1693.167 -1.17 0.242 -5301.611 1335.483
------------------------------------------------------------------------------
I dont have any idea how to explain the large difference I am seeing in the results from xtdidregress (-682) and from csdid (-2776)
Here is an excerpt of the data- membernum is the grouped member id, month cont is the number of month (First month of data available is 1 and so on), activation_month_monthcont is the month number in which teh Memebr activated and total_allowed amount is the dependent variable of interest.
Any help would be greatly appreciated. Thank you!
I am trying to understand the impact of a health care solution on per member per month cost of healthcare from Claims data. The program implementation month varies for each member as it depends on when they activate the program. I have about 9 months of pre-program data and then one year where the program was available to all Members and they all activated at different times.
My xtdidregress results look like this:
. xtdidregress (total_allowed) (post), group(membernum) time(monthcont)
Number of groups and treatment time
Time variable: monthcont
Control: post = 0
Treatment: post = 1
-----------------------------------
| Control Treatment
-------------+---------------------
Group |
membernum | 498 496
-------------+---------------------
Time |
Minimum | 1 8
Maximum | 1 16
-----------------------------------
Difference-in-differences regression Number of obs = 18,886
Data type: Longitudinal
(Std. err. adjusted for 994 clusters in membernum)
------------------------------------------------------------------------------
| Robust
total_allo~d | Coefficient std. err. t P>|t| [95% conf. interval]
-------------+----------------------------------------------------------------
ATET |
post |
(1 vs 0) | -681.8773 876.5132 -0.78 0.437 -2401.908 1038.154
------------------------------------------------------------------------------
Note: ATET estimate adjusted for panel effects and time effects.
Whereas my csdid results look like this
. csdid total_allowed, i(membernum) time(monthcont) gvar(activation_month_monthcont)
No never treated observations found. Using Not yet treated data
..................................................
..................................................
..................................................
..................................................
................xxxxxxxxxxxxxxxxxx
Difference-in-difference with Multiple Time Periods
Number of obs = 9,804
Outcome model : regression adjustment
Treatment model: none
------------------------------------------------------------------------------
| Coefficient Std. err. z P>|z| [95% conf. interval]
-------------+----------------------------------------------------------------
g8 |
t_1_2 | 2413.011 1557.6 1.55 0.121 -639.8299 5465.852
t_2_3 | 738.025 978.62 0.75 0.451 -1180.035 2656.085
t_3_4 | -1742.566 2322.006 -0.75 0.453 -6293.615 2808.482
t_4_5 | 3439.818 4120.801 0.83 0.404 -4636.803 11516.44
t_5_6 | -3737.644 4047.542 -0.92 0.356 -11670.68 4195.393
t_6_7 | 2109.66 1492.769 1.41 0.158 -816.1128 5035.433
t_7_8 | -1831.654 1451.193 -1.26 0.207 -4675.939 1012.631
t_7_9 | -978.8183 1619.831 -0.60 0.546 -4153.629 2195.992
t_7_10 | -3107.383 1984.5 -1.57 0.117 -6996.931 782.1653
t_7_11 | -13812.28 7847.867 -1.76 0.078 -29193.82 1569.254
t_7_12 | -4866.734 5686.729 -0.86 0.392 -16012.52 6279.05
t_7_13 | -8216.169 9123.062 -0.90 0.368 -26097.04 9664.705
t_7_14 | -7644.596 7347.719 -1.04 0.298 -22045.86 6756.669
t_7_15 | 3141.352 5334.031 0.59 0.556 -7313.157 13595.86
t_7_16 | -1386.692 1496.887 -0.93 0.354 -4320.536 1547.153
t_7_17 | -393.5946 1568.474 -0.25 0.802 -3467.747 2680.558
t_7_18 | -161.3823 1671.064 -0.10 0.923 -3436.608 3113.844
t_7_19 | -1983.064 1693.167 -1.17 0.242 -5301.611 1335.483
-------------+----------------------------------------------------------------
g9 |
t_1_2 | -5947.685 5738.571 -1.04 0.300 -17195.08 5299.706
t_2_3 | 1310.243 1163.599 1.13 0.260 -970.3691 3590.855
t_3_4 | -3222.966 3210.678 -1.00 0.315 -9515.78 3069.847
t_4_5 | -2310.87 1734.721 -1.33 0.183 -5710.86 1089.121
t_5_6 | 4199.424 2764.922 1.52 0.129 -1219.723 9618.572
t_6_7 | -2314.037 2213.014 -1.05 0.296 -6651.466 2023.392
t_7_8 | 600.1207 377.8416 1.59 0.112 -140.4351 1340.677
t_8_9 | -527.6483 346.7358 -1.52 0.128 -1207.238 151.9413
t_8_10 | -1627.864 1393.088 -1.17 0.243 -4358.266 1102.538
t_8_11 | -13817.06 7480.405 -1.85 0.065 -28478.38 844.2658
t_8_12 | -5426.549 5315.599 -1.02 0.307 -15844.93 4991.833
t_8_13 | -5964.215 9071.575 -0.66 0.511 -23744.18 11815.75
t_8_14 | -4301.294 7571.526 -0.57 0.570 -19141.21 10538.62
t_8_15 | 3186.897 3152.748 1.01 0.312 -2992.375 9366.169
t_8_16 | 10541.09 9162.531 1.15 0.250 -7417.141 28499.32
t_8_17 | 512.4385 566.0181 0.91 0.365 -596.9366 1621.814
t_8_18 | 291.7162 864.9723 0.34 0.736 -1403.598 1987.031
t_8_19 | 487.5433 1444.668 0.34 0.736 -2343.954 3319.041
-------------+----------------------------------------------------------------
g10 |
t_1_2 | -14.4397 138.5633 -0.10 0.917 -286.0189 257.1394
t_2_3 | 593.5153 553.7621 1.07 0.284 -491.8384 1678.869
t_3_4 | -493.2139 546.1885 -0.90 0.367 -1563.724 577.296
t_4_5 | 8415.441 8716.804 0.97 0.334 -8669.181 25500.06
t_5_6 | -7263.901 8514.142 -0.85 0.394 -23951.31 9423.51
t_6_7 | -197.2962 1415.894 -0.14 0.889 -2972.397 2577.805
t_7_8 | -907.4951 1037.896 -0.87 0.382 -2941.734 1126.743
t_8_9 | -3.788006 358.6174 -0.01 0.992 -706.6652 699.0891
t_9_10 | 38971.07 23927.72 1.63 0.103 -7926.397 85868.53
t_9_11 | -14457.49 7451.092 -1.94 0.052 -29061.36 146.3865
t_9_12 | -4827.638 5453.202 -0.89 0.376 -15515.72 5860.441
t_9_13 | -9187.64 8807.594 -1.04 0.297 -26450.21 8074.927
t_9_14 | -7324.702 7160.173 -1.02 0.306 -21358.38 6708.98
t_9_15 | -996.4504 577.6921 -1.72 0.085 -2128.706 135.8053
t_9_16 | 195.9426 777.5793 0.25 0.801 -1328.085 1719.97
t_9_17 | 120.1163 463.4531 0.26 0.795 -788.235 1028.468
t_9_18 | -432.3896 435.3778 -0.99 0.321 -1285.714 420.9353
t_9_19 | 227.2957 1422.497 0.16 0.873 -2560.746 3015.338
-------------+----------------------------------------------------------------
g11 |
t_1_2 | 575.6311 367.5341 1.57 0.117 -144.7225 1295.985
t_2_3 | -568.6662 362.7375 -1.57 0.117 -1279.619 142.2862
t_3_4 | 49.61945 65.72968 0.75 0.450 -79.20835 178.4472
t_4_5 | -641.3846 591.7948 -1.08 0.278 -1801.281 518.5119
t_5_6 | 540.7838 599.2793 0.90 0.367 -633.7821 1715.35
t_6_7 | 87.16287 124.2176 0.70 0.483 -156.2992 330.6249
t_7_8 | -337.4202 244.3019 -1.38 0.167 -816.2432 141.4027
t_8_9 | 476.1524 396.5439 1.20 0.230 -301.0593 1253.364
t_9_10 | -622.0626 2171.35 -0.29 0.775 -4877.83 3633.705
t_10_11 | -12663.33 7836.434 -1.62 0.106 -28022.45 2695.803
t_10_12 | 1291.459 6886.467 0.19 0.851 -12205.77 14788.69
t_10_13 | -5962.488 9512.492 -0.63 0.531 -24606.63 12681.65
t_10_14 | 2775.73 11003.12 0.25 0.801 -18789.99 24341.45
t_10_15 | -2063.279 1354.5 -1.52 0.128 -4718.051 591.4925
t_10_16 | -1129.78 1320.829 -0.86 0.392 -3718.558 1458.998
t_10_17 | 711.879 1624.985 0.44 0.661 -2473.033 3896.791
t_10_18 | -1318.808 1249.634 -1.06 0.291 -3768.045 1130.43
t_10_19 | -1864.876 1540.959 -1.21 0.226 -4885.101 1155.349
-------------+----------------------------------------------------------------
g12 |
t_1_2 | -28.5208 69.20077 -0.41 0.680 -164.1518 107.1102
t_2_3 | 20.25091 87.2009 0.23 0.816 -150.6597 191.1615
t_3_4 | -2.600366 68.65269 -0.04 0.970 -137.1572 131.9564
t_4_5 | -345.9046 977.6137 -0.35 0.723 -2261.992 1570.183
t_5_6 | 419.0391 991.8096 0.42 0.673 -1524.872 2362.95
t_6_7 | -175.976 118.8622 -1.48 0.139 -408.9416 56.98971
t_7_8 | 610.6593 511.621 1.19 0.233 -392.0994 1613.418
t_8_9 | 21.27032 804.6844 0.03 0.979 -1555.882 1598.423
t_9_10 | -3187.432 2693.31 -1.18 0.237 -8466.222 2091.358
t_10_11 | 701.6676 15058.65 0.05 0.963 -28812.75 30216.09
t_11_12 | -3683.585 15604.97 -0.24 0.813 -34268.76 26901.6
t_11_13 | -4036.239 18351.43 -0.22 0.826 -40004.39 31931.91
t_11_14 | 1046.542 20507.44 0.05 0.959 -39147.31 41240.39
t_11_15 | 25077.25 26238.71 0.96 0.339 -26349.68 76504.18
t_11_16 | -13096.59 11306.34 -1.16 0.247 -35256.61 9063.431
t_11_17 | -12294.26 11321.76 -1.09 0.278 -34484.51 9895.98
t_11_18 | -11760.31 11420.56 -1.03 0.303 -34144.19 10623.57
t_11_19 | -13401.71 11363.85 -1.18 0.238 -35674.44 8871.025
-------------+----------------------------------------------------------------
g13 |
t_1_2 | 87.22608 120.246 0.73 0.468 -148.4517 322.9038
t_2_3 | 15.79733 64.88187 0.24 0.808 -111.3688 142.9635
t_3_4 | 39.14399 193.2518 0.20 0.839 -339.6226 417.9106
t_4_5 | 4941.776 4887.111 1.01 0.312 -4636.786 14520.34
t_5_6 | -5066.34 4966.664 -1.02 0.308 -14800.82 4668.143
t_6_7 | 395.9956 434.5907 0.91 0.362 -455.7866 1247.778
t_7_8 | 321.8059 786.2214 0.41 0.682 -1219.16 1862.772
t_8_9 | -470.8186 538.4378 -0.87 0.382 -1526.137 584.5
t_9_10 | -3083.443 3125.834 -0.99 0.324 -9209.965 3043.08
t_10_11 | -15193.24 11857.28 -1.28 0.200 -38433.08 8046.597
t_11_12 | 16304.92 13790.79 1.18 0.237 -10724.53 43334.36
t_12_13 | -5411.161 11284.64 -0.48 0.632 -27528.65 16706.33
t_12_14 | -1543.09 12319.87 -0.13 0.900 -25689.59 22603.41
t_12_15 | 7791.391 13462.14 0.58 0.563 -18593.91 34176.7
t_12_16 | -3977.202 4631.667 -0.86 0.391 -13055.1 5100.699
t_12_17 | -4499.681 4500.721 -1.00 0.317 -13320.93 4321.57
t_12_18 | -3672.203 3923.661 -0.94 0.349 -11362.44 4018.032
t_12_19 | 39937.14 38520.43 1.04 0.300 -35561.52 115435.8
-------------+----------------------------------------------------------------
g14 |
t_1_2 | 11.01271 93.41436 0.12 0.906 -172.0761 194.1015
t_2_3 | 21.80897 80.43034 0.27 0.786 -135.8316 179.4495
t_3_4 | -3.950014 46.59644 -0.08 0.932 -95.27736 87.37733
t_4_5 | 188.5827 155.597 1.21 0.226 -116.3818 493.5471
t_5_6 | -4.134538 165.7075 -0.02 0.980 -328.9154 320.6463
t_6_7 | -106.4165 131.5952 -0.81 0.419 -364.3383 151.5053
t_7_8 | -289.063 234.1032 -1.23 0.217 -747.8969 169.7709
t_8_9 | 590.7348 293.8086 2.01 0.044 14.88054 1166.589
t_9_10 | -4459.183 4343.541 -1.03 0.305 -12972.37 4054.001
t_10_11 | -7867.677 18508.2 -0.43 0.671 -44143.07 28407.72
t_11_12 | 3715.006 20030.14 0.19 0.853 -35543.34 42973.36
t_12_13 | 39693.32 31909.96 1.24 0.214 -22849.06 102235.7
t_13_14 | -37652.96 31563.96 -1.19 0.233 -99517.18 24211.26
t_13_15 | -31852.73 30697.96 -1.04 0.299 -92019.63 28314.16
t_13_16 | -22826.53 32244.4 -0.71 0.479 -86024.39 40371.32
t_13_17 | -31391.53 30708.66 -1.02 0.307 -91579.4 28796.34
t_13_18 | -31549.32 30674.04 -1.03 0.304 -91669.33 28570.69
t_13_19 | -32343.61 30694.59 -1.05 0.292 -92503.9 27816.67
-------------+----------------------------------------------------------------
g15 |
t_1_2 | 31.76576 137.2799 0.23 0.817 -237.2979 300.8294
t_2_3 | 17.25459 117.0905 0.15 0.883 -212.2386 246.7477
t_3_4 | 44.06365 79.28775 0.56 0.578 -111.3375 199.4648
t_4_5 | -74.08912 54.19563 -1.37 0.172 -180.3106 32.13237
t_5_6 | 120.4344 69.44929 1.73 0.083 -15.68371 256.5525
t_6_7 | 5.684705 143.5776 0.04 0.968 -275.7223 287.0917
t_7_8 | -47.11638 363.0076 -0.13 0.897 -758.5983 664.3655
t_8_9 | 158.1434 316.7181 0.50 0.618 -462.6127 778.8995
t_9_10 | 13552.65 13215.94 1.03 0.305 -12350.12 39455.42
t_10_11 | -45357.18 26093.93 -1.74 0.082 -96500.35 5785.995
t_11_12 | 18556.8 26202.93 0.71 0.479 -32799.99 69913.59
t_12_13 | 12655.35 12713.87 1.00 0.320 -12263.39 37574.08
t_13_14 | -10085.96 10486.13 -0.96 0.336 -30638.4 10466.47
t_14_15 | 10415.54 10419.03 1.00 0.317 -10005.39 30836.46
t_14_16 | 20682.96 19405.24 1.07 0.286 -17350.62 58716.53
t_14_17 | 395.0887 449.283 0.88 0.379 -485.4898 1275.667
t_14_18 | -308.1028 287.7749 -1.07 0.284 -872.1312 255.9256
t_14_19 | -380.8722 887.2825 -0.43 0.668 -2119.914 1358.169
-------------+----------------------------------------------------------------
g16 |
t_1_2 | -365.3907 274.454 -1.33 0.183 -903.3106 172.5292
t_2_3 | 253.1077 222.2578 1.14 0.255 -182.5095 688.725
t_3_4 | -50.04962 127.5593 -0.39 0.695 -300.0613 199.9621
t_4_5 | -75.12328 85.0183 -0.88 0.377 -241.7561 91.50952
t_5_6 | -32.59038 112.0859 -0.29 0.771 -252.2748 187.094
t_6_7 | 260.7692 249.8886 1.04 0.297 -229.0034 750.5418
t_7_8 | -667.9001 518.3165 -1.29 0.198 -1683.782 347.9816
t_8_9 | 355.7108 415.1914 0.86 0.392 -458.0494 1169.471
t_9_10 | 132.1937 107.558 1.23 0.219 -78.61611 343.0036
t_10_11 | 67012.21 46129.92 1.45 0.146 -23400.78 157425.2
t_11_12 | -39690.7 54899.15 -0.72 0.470 -147291.1 67909.65
t_12_13 | -26278.57 26461.32 -0.99 0.321 -78141.79 25584.66
t_13_14 | -21090.57 19657.51 -1.07 0.283 -59618.58 17437.45
t_14_15 | 19611.27 19528.92 1.00 0.315 -18664.7 57887.24
t_15_16 | 24973.96 22485.6 1.11 0.267 -19097 69044.93
t_15_17 | 2468.15 2186.999 1.13 0.259 -1818.29 6754.589
t_15_18 | 836.8999 914.7263 0.91 0.360 -955.9307 2629.73
t_15_19 | 484.4572 1511.984 0.32 0.749 -2478.977 3447.892
-------------+----------------------------------------------------------------
g17 |
t_1_2 | 227.6724 317.4141 0.72 0.473 -394.4479 849.7927
t_2_3 | -425.2896 398.7306 -1.07 0.286 -1206.787 356.208
t_3_4 | -5.66883 24.13568 -0.23 0.814 -52.97389 41.63623
t_4_5 | -66.4653 88.05049 -0.75 0.450 -239.0411 106.1105
t_5_6 | 86.53354 90.33501 0.96 0.338 -90.51982 263.5869
t_6_7 | 23.99706 37.148 0.65 0.518 -48.81169 96.8058
t_7_8 | -40.24587 601.1852 -0.07 0.947 -1218.547 1138.055
t_8_9 | 38.99763 596.6739 0.07 0.948 -1130.462 1208.457
t_9_10 | 167.8253 134.3069 1.25 0.211 -95.41139 431.062
t_10_11 | 268.9353 97.82905 2.75 0.006 77.19387 460.6767
t_11_12 | -232.9221 221.8151 -1.05 0.294 -667.6718 201.8275
t_12_13 | 52.33254 183.4857 0.29 0.775 -307.2929 411.958
t_13_14 | 134415.7 109768 1.22 0.221 -80725.64 349557.1
t_14_15 | -134163.8 108704.6 -1.23 0.217 -347221 78893.29
t_15_16 | 1524.28 1014.441 1.50 0.133 -463.987 3512.547
t_16_17 | -1135.244 882.6206 -1.29 0.198 -2865.148 594.6609
t_16_18 | -2101.454 1529.578 -1.37 0.169 -5099.372 896.4649
t_16_19 | -2910.872 1801.758 -1.62 0.106 -6442.253 620.5088
-------------+----------------------------------------------------------------
g18 |
t_1_2 | 226.9079 232.8 0.97 0.330 -229.3718 683.1875
t_2_3 | -293.7504 227.9276 -1.29 0.197 -740.4802 152.9794
t_3_4 | -79.27144 46.45663 -1.71 0.088 -170.3248 11.78188
t_4_5 | -211.7149 148.44 -1.43 0.154 -502.6519 79.22219
t_5_6 | 155.2379 150.3373 1.03 0.302 -139.4177 449.8935
t_6_7 | 89.21585 63.36422 1.41 0.159 -34.97573 213.4074
t_7_8 | -619.3127 780.456 -0.79 0.427 -2148.978 910.3529
t_8_9 | 972.9084 792.9242 1.23 0.220 -581.1945 2527.011
t_9_10 | -308.0966 214.6789 -1.44 0.151 -728.8595 112.6663
t_10_11 | 79.84828 31.77692 2.51 0.012 17.56666 142.1299
t_11_12 | -184.2416 205.6794 -0.90 0.370 -587.3658 218.8827
t_12_13 | 37.68445 231.8408 0.16 0.871 -416.7152 492.0841
t_13_14 | 101.5707 105.2853 0.96 0.335 -104.7848 307.9262
t_14_15 | 2598.038 2139.084 1.21 0.225 -1594.49 6790.566
t_15_16 | -2597.289 2164.641 -1.20 0.230 -6839.907 1645.329
t_16_17 | 100.4896 73.42879 1.37 0.171 -43.42822 244.4074
t_17_18 | -56.248 245.7812 -0.23 0.819 -537.9703 425.4743
t_17_19 | 79.92223 1196.879 0.07 0.947 -2265.918 2425.762
-------------+----------------------------------------------------------------
g19 |
t_1_2 | 472.85 . . . . .
t_2_3 | 749.89 1.08e-13 7.0e+15 0.000 749.89 749.89
t_3_4 | 260.8779 11.52322 22.64 0.000 238.2928 283.463
t_4_5 | -91.00224 153.4348 -0.59 0.553 -391.729 209.7245
t_5_6 | 245.0943 164.9581 1.49 0.137 -78.21753 568.4062
t_6_7 | -607.33 . . . . .
t_7_8 | -2404.297 805.1396 -2.99 0.003 -3982.341 -826.2519
t_8_9 | 1000.308 806.0238 1.24 0.215 -579.4699 2580.085
t_9_10 | -80.42 45.6268 -1.76 0.078 -169.8469 9.006895
t_10_11 | 80.60444 33.6353 2.40 0.017 14.68047 146.5284
t_11_12 | -355.77 194.1435 -1.83 0.067 -736.2844 24.74433
t_12_13 | 225.2589 231.6882 0.97 0.331 -228.8416 679.3594
t_13_14 | 47.72777 103.7811 0.46 0.646 -155.6794 251.135
t_14_15 | 40.49333 75.3182 0.54 0.591 -107.1276 188.1143
t_15_16 | -.5244437 48.18157 -0.01 0.991 -94.95859 93.9097
t_16_17 | -15.22111 29.05663 -0.52 0.600 -72.17105 41.72884
t_17_18 | -266.6756 252.8688 -1.05 0.292 -762.2893 228.9382
t_18_19 | -655.4622 528.6882 -1.24 0.215 -1691.672 380.7476
-------------+----------------------------------------------------------------
g20 |
t_1_2 | 0 (omitted)
t_2_3 | 0 (omitted)
t_3_4 | 0 (omitted)
t_4_5 | 0 (omitted)
t_5_6 | 0 (omitted)
t_6_7 | 0 (omitted)
t_7_8 | 0 (omitted)
t_8_9 | 0 (omitted)
t_9_10 | 0 (omitted)
t_10_11 | 0 (omitted)
t_11_12 | 0 (omitted)
t_12_13 | 0 (omitted)
t_13_14 | 0 (omitted)
t_14_15 | 0 (omitted)
t_15_16 | 0 (omitted)
t_16_17 | 0 (omitted)
t_17_18 | 0 (omitted)
t_18_19 | 0 (omitted)
------------------------------------------------------------------------------
Control: Not yet Treated
See Callaway and Sant'Anna (2021) for details
. estat event
ATT by Periods Before and After treatment
Event Study:Dynamic effects
------------------------------------------------------------------------------
| Coefficient Std. err. z P>|z| [95% conf. interval]
-------------+----------------------------------------------------------------
Pre_avg | 86.63651 126.4505 0.69 0.493 -161.202 334.475
Post_avg | -2776.03 2018.926 -1.38 0.169 -6733.052 1180.993
Tm17 | 472.85 . . . . .
Tm16 | 292.2806 202.4182 1.44 0.149 -104.4517 689.0129
Tm15 | -101.1235 196.7657 -0.51 0.607 -486.7772 284.5303
Tm14 | -293.0622 181.8659 -1.61 0.107 -649.5129 63.38848
Tm13 | 82.42142 97.35175 0.85 0.397 -108.3845 273.2274
Tm12 | -.9868379 69.17678 -0.01 0.989 -136.5708 134.5972
Tm11 | -3.465116 46.17736 -0.08 0.940 -93.97109 87.04085
Tm10 | -49.12482 51.01227 -0.96 0.336 -149.107 50.85739
Tm9 | 270.6987 116.4527 2.32 0.020 42.45568 498.9417
Tm8 | 135.6721 355.1604 0.38 0.702 -560.4295 831.7736
Tm7 | -1330.926 1171.007 -1.14 0.256 -3626.058 964.2057
Tm6 | 1170.847 802.3136 1.46 0.144 -401.6584 2743.353
Tm5 | 3686.439 2046.452 1.80 0.072 -324.5323 7697.411
Tm4 | -4839.008 3133.68 -1.54 0.123 -10980.91 1302.892
Tm3 | 2072.816 2518.44 0.82 0.410 -2863.235 7008.868
Tm2 | -3667.093 2475.017 -1.48 0.138 -8518.037 1183.85
Tm1 | 3573.584 1946.767 1.84 0.066 -242.0097 7389.178
Tp0 | 430.5019 3244.946 0.13 0.894 -5929.476 6790.48
Tp1 | -2739.139 2739.627 -1.00 0.317 -8108.709 2630.43
Tp2 | -4576.042 2958.847 -1.55 0.122 -10375.28 1223.193
Tp3 | -6831.446 4151.487 -1.65 0.100 -14968.21 1305.318
Tp4 | -6723.597 3860.199 -1.74 0.082 -14289.45 842.2533
Tp5 | -7677.503 6193.234 -1.24 0.215 -19816.02 4461.012
Tp6 | -3364.055 4329.386 -0.78 0.437 -11849.5 5121.384
Tp7 | 1471.064 3357.137 0.44 0.661 -5108.804 8050.931
Tp8 | -1077.164 947.6827 -1.14 0.256 -2934.588 780.2597
Tp9 | -199.7646 1138.611 -0.18 0.861 -2431.402 2031.872
Tp10 | -42.14509 1417.086 -0.03 0.976 -2819.583 2735.293
Tp11 | -1983.064 1693.167 -1.17 0.242 -5301.611 1335.483
------------------------------------------------------------------------------
I dont have any idea how to explain the large difference I am seeing in the results from xtdidregress (-682) and from csdid (-2776)
Here is an excerpt of the data- membernum is the grouped member id, month cont is the number of month (First month of data available is 1 and so on), activation_month_monthcont is the month number in which teh Memebr activated and total_allowed amount is the dependent variable of interest.
Code:
* Example generated by -dataex-. For more info, type help dataex clear input float(membernum monthcont activation_month_monthcont total_allowed) 86 3 8 0 697 4 8 0 126 17 8 0 57 5 8 0 318 14 8 0 851 16 8 0 310 14 8 1075.26 156 5 8 0 402 4 8 0 562 12 8 44 788 11 8 0 335 16 8 0 597 6 8 0 363 19 8 0 559 15 8 0 739 11 8 0 628 7 8 3888.03 451 19 8 0 189 3 8 515907 390 12 8 2228 511 12 8 102.28 780 6 8 0 420 5 8 0 573 15 8 0 156 17 8 0 870 13 8 112.33 602 15 8 1957.24 191 9 8 1438.6 807 7 8 0 478 3 8 0 5 1 8 0 990 8 8 0 525 14 8 0 442 17 8 0 35 15 8 1377.36 35 1 8 0 783 19 8 0 63 12 8 0 290 12 8 0 215 13 8 0 344 3 8 0 229 10 8 0 739 12 8 0 27 4 8 0 229 13 8 88 532 4 8 0 454 19 8 236.82 259 12 8 717.51 243 11 8 0 511 9 8 25.5 659 2 8 0 621 16 8 593.48 171 1 8 0 783 1 8 0 285 4 8 0 133 14 8 928.39 45 6 8 0 340 18 8 0 675 11 8 0 145 1 8 0 59 3 8 0 720 8 8 0 278 16 8 1585.17 59 5 8 0 600 19 8 0 913 3 8 0 854 10 8 0 168 15 8 0 475 2 8 0 851 3 8 0 27 7 8 0 27 8 8 0 65 11 8 0 800 5 8 0 924 9 8 0 27 9 8 265.62 290 10 8 0 602 9 8 479.76 506 14 8 0 278 11 8 1156.22 334 11 8 0 951 1 8 0 420 2 8 0 100 5 8 173.51 278 10 8 455.18 987 4 8 69.5 628 14 8 0 829 13 8 0 240 2 8 0 335 9 8 0 829 5 8 0 104 15 8 1135.89 59 14 8 75 278 8 8 2548.5 337 13 8 761.64 937 7 8 0 727 5 8 0 492 14 8 0 186 17 8 0 164 6 8 0 end
