------------------------------------------------------------------------------------------------------------ log: D:\Anands Documents\Working Papers\Devanbu\Data\commit\commit_postgres.txt log type: text opened on: 19 Mar 2007, 12:10:15 . . *reads in event history data from event.dta . use event_postgres . sort id year month . save run1, replace (note: file run1.dta not found) file run1.dta saved . clear . . *reads in patch data from patch.dta . use patch_postgres . sort id year month . . *merges event history and patch data . merge id year month using run1 . . drop _merge . sort id year month . save run2, replace (note: file run2.dta not found) file run2.dta saved . . *reads in node attribute data from node.dta . use node_postgres . sort id year month . . *merges the two datasets . merge id year month using run2 . drop _merge . drop if commit==. (1728 observations deleted) . . *create event history variables, time is specified on an annual scale . gen ts=calendar-start_date . gen tf=ts+0.08333333 . stset tf, id(id) failure (commit=1) id: id failure event: commit == 1 obs. time interval: (tf[_n-1], tf] exit on or before: failure ------------------------------------------------------------------------------ 178510 total obs. 0 exclusions ------------------------------------------------------------------------------ 178510 obs. remaining, representing 3545 subjects 20 failures in single failure-per-subject data 14877.64 total analysis time at risk, at risk from t = 0 earliest observed entry t = 0 last observed exit t = 9.833333 . *generate additional variables . gen dev_pct=(devs_cum/people_cum)*100 . gen time_trend=calendar-1995 . gen patch_any=0 . replace patch_any=1 if patches_submitted_cum>0 (10009 real changes made) . gen patch_current=0 . replace patch_current=1 if patches_submitted>0 (522 real changes made) . gen success_pct=(patches_committed_cum/patches_submitted_cum)*100 (168501 missing values generated) . replace success_pct=0 if success_pct==. (168501 real changes made) . . *save data file to be used in further analysis . save commit_postgres, replace file commit_postgres.dta saved . . *compute descriptive statistics . summ Variable | Obs Mean Std. Dev. Min Max -------------+-------------------------------------------------------- id | 178510 1749.974 1015.763 2 3687 year | 178510 2002.954 1.931266 1998 2006 month | 178510 6.533326 3.528484 1 12 calendar | 178510 2003.415 1.913421 1998 2006.083 between_cum | 178510 475.5001 3557.399 0 162340 -------------+-------------------------------------------------------- indegree_cum | 178510 3.3363 8.998791 0 213 outdegree_~m | 178510 3.003165 10.73875 0 295 norm_betwe~m | 178510 .0001567 .0010404 0 .0587767 norm_indeg~m | 178510 .0022484 .0062286 0 .178571 norm_outde~m | 178510 .0019951 .0071098 0 .230159 -------------+-------------------------------------------------------- between_mo~y | 178510 3.151118 39.71102 0 2972.08 indegree_m~y | 178510 .1529382 .9914616 0 35 outdegree_~y | 178510 .1390118 1.013147 0 41 norm_betwe~y | 178510 .0001891 .0023518 0 .200925 norm_indeg~y | 178510 .0012624 .0082358 0 .309859 -------------+-------------------------------------------------------- norm_outde~y | 178510 .0011359 .0083614 0 .385965 sent_monthly | 178510 .3666629 2.999881 0 155 sent_cum | 178510 13.5153 67.75995 1 2724 people_mon~y | 178510 146.2988 26.75964 33 192 people_cum | 178510 2463.482 863.5203 75 3552 -------------+-------------------------------------------------------- devs_cum | 178510 15.7045 4.212153 1 21 patches_su~d | 178510 .0101787 .4250087 0 90 patches_su~m | 178510 .3017646 3.094019 0 219 patches_co~d | 178510 0 0 0 0 patches_co~m | 178510 0 0 0 0 -------------+-------------------------------------------------------- patch_mess~s | 178510 .0047224 .1175114 0 18 patch_mess~m | 178510 .1497619 1.23317 0 131 start_date | 178510 2000.754 1.907534 1996.333 2006.083 commit | 178510 .000112 .0105843 0 1 ts | 178510 2.660937 1.911121 0 9.75 -------------+-------------------------------------------------------- tf | 178510 2.74427 1.911121 .0833333 9.833333 _st | 178510 1 0 1 1 _d | 178510 .000112 .0105843 0 1 _t | 178510 2.74427 1.911121 .0833333 9.833333 _t0 | 178510 2.660927 1.911129 0 9.749959 -------------+-------------------------------------------------------- dev_pct | 178510 .6765981 .137812 .4065041 1.333333 time_trend | 178510 8.415153 1.913421 3 11.08337 patch_any | 178510 .0560697 .2300569 0 1 patch_curr~t | 178510 .0029242 .053997 0 1 success_pct | 178510 0 0 0 0 . correlate (obs=178510) | id year month calendar betwee~m indegr~m outdeg~m norm_b~m norm_i~m norm_o~m -------------+------------------------------------------------------------------------------------------ id | 1.0000 year | 0.0293 1.0000 month | 0.0001 -0.1365 1.0000 calendar | 0.0296 0.9883 0.0159 1.0000 between_cum | -0.0121 0.0635 0.0016 0.0644 1.0000 indegree_cum | -0.0057 0.0539 0.0012 0.0546 0.8303 1.0000 outdegree_~m | -0.0221 0.0459 0.0010 0.0464 0.8952 0.9159 1.0000 norm_betwe~m | -0.0237 -0.0784 -0.0022 -0.0795 0.6559 0.6548 0.7045 1.0000 norm_indeg~m | -0.0172 -0.1988 -0.0080 -0.2019 0.5284 0.7554 0.6790 0.7778 1.0000 norm_outde~m | -0.0327 -0.1466 -0.0057 -0.1488 0.5995 0.7114 0.7794 0.8662 0.8837 1.0000 between_mo~y | 0.0020 -0.0038 0.0038 -0.0032 0.4096 0.4094 0.4357 0.3883 0.3350 0.3721 indegree_m~y | 0.0060 -0.0492 -0.0002 -0.0497 0.4091 0.5059 0.4773 0.4468 0.5084 0.4775 outdegree_~y | -0.0035 -0.0386 -0.0002 -0.0390 0.4493 0.4972 0.5402 0.4949 0.4837 0.5442 norm_betwe~y | -0.0020 -0.0352 0.0023 -0.0351 0.3400 0.3634 0.3862 0.4924 0.4104 0.4530 norm_indeg~y | 0.0024 -0.0915 -0.0037 -0.0929 0.3451 0.4509 0.4227 0.4886 0.5737 0.5259 norm_outde~y | -0.0072 -0.0747 -0.0029 -0.0758 0.3817 0.4444 0.4827 0.5468 0.5408 0.6044 sent_monthly | 0.0044 -0.0442 -0.0000 -0.0446 0.3754 0.4548 0.4431 0.4304 0.4718 0.4614 sent_cum | -0.0013 0.0316 0.0011 0.0321 0.8402 0.9066 0.8528 0.6413 0.6717 0.6497 people_mon~y | 0.0142 0.4214 0.1073 0.4418 0.0266 0.0236 0.0203 -0.0630 -0.1579 -0.1169 people_cum | 0.0301 0.9856 0.0176 0.9975 0.0643 0.0548 0.0466 -0.0797 -0.2039 -0.1501 devs_cum | 0.0276 0.9620 0.0075 0.9721 0.0618 0.0518 0.0438 -0.0883 -0.2179 -0.1618 patches_su~d | 0.0001 -0.0247 0.0020 -0.0247 0.0122 0.0290 0.0293 0.0627 0.0797 0.0804 patches_su~m | 0.0034 -0.0354 0.0554 -0.0272 0.0679 0.1552 0.1473 0.2034 0.2239 0.2214 patches_co~d | . . . . . . . . . . patches_co~m | . . . . . . . . . . patch_mess~s | 0.0001 -0.0371 0.0002 -0.0374 0.0350 0.0630 0.0599 0.1208 0.1410 0.1320 patch_mess~m | 0.0018 -0.0470 0.0626 -0.0378 0.1177 0.2218 0.1936 0.2790 0.3056 0.2770 start_date | 0.0599 0.4937 0.0089 0.4997 -0.0122 -0.0370 -0.0353 -0.0793 -0.1597 -0.1278 commit | 0.0008 -0.0107 0.0011 -0.0106 0.0374 0.0482 0.0523 0.1035 0.0864 0.0968 ts | -0.0301 0.4968 0.0070 0.5025 0.0766 0.0916 0.0817 -0.0004 -0.0428 -0.0214 tf | -0.0301 0.4968 0.0070 0.5025 0.0766 0.0916 0.0817 -0.0004 -0.0428 -0.0214 _st | . . . . . . . . . . _d | 0.0008 -0.0107 0.0011 -0.0106 0.0374 0.0482 0.0523 0.1035 0.0864 0.0968 _t | -0.0301 0.4968 0.0070 0.5025 0.0766 0.0916 0.0817 -0.0004 -0.0428 -0.0214 _t0 | -0.0301 0.4968 0.0070 0.5025 0.0766 0.0916 0.0817 -0.0004 -0.0428 -0.0214 dev_pct | -0.0296 -0.7730 -0.0228 -0.7837 -0.0510 -0.0463 -0.0403 0.0496 0.1510 0.1062 time_trend | 0.0296 0.9883 0.0159 1.0000 0.0644 0.0546 0.0464 -0.0795 -0.2019 -0.1488 patch_any | 0.0352 -0.0513 0.0928 -0.0375 0.1722 0.2916 0.2493 0.2071 0.3070 0.2571 patch_curr~t | 0.0035 -0.0435 -0.0024 -0.0442 0.0524 0.0832 0.0770 0.1188 0.1503 0.1311 success_pct | . . . . . . . . . . | betwee~y indegr~y outdeg~y norm_b~y norm_i~y norm_o~y sent_m~y sent_cum people~y people~m -------------+------------------------------------------------------------------------------------------ between_mo~y | 1.0000 indegree_m~y | 0.7680 1.0000 outdegree_~y | 0.8063 0.8804 1.0000 norm_betwe~y | 0.8755 0.7343 0.7754 1.0000 norm_indeg~y | 0.6724 0.9499 0.8295 0.7469 1.0000 norm_outde~y | 0.7124 0.8351 0.9514 0.7986 0.8682 1.0000 sent_monthly | 0.7203 0.8776 0.8691 0.7113 0.8470 0.8413 1.0000 sent_cum | 0.4125 0.4912 0.4859 0.3623 0.4351 0.4320 0.4838 1.0000 people_mon~y | 0.0180 -0.0105 -0.0058 -0.0231 -0.0643 -0.0515 -0.0148 0.0123 1.0000 people_cum | -0.0024 -0.0492 -0.0385 -0.0348 -0.0931 -0.0759 -0.0443 0.0319 0.4674 1.0000 devs_cum | -0.0035 -0.0536 -0.0425 -0.0391 -0.1025 -0.0840 -0.0485 0.0299 0.4654 0.9713 patches_su~d | 0.0583 0.1107 0.1116 0.0831 0.1339 0.1353 0.1604 0.0310 -0.0117 -0.0244 patches_su~m | 0.0757 0.1393 0.1439 0.1521 0.1765 0.1856 0.1581 0.1585 -0.0147 -0.0268 patches_co~d | . . . . . . . . . . patches_co~m | . . . . . . . . . . patch_mess~s | 0.1051 0.1889 0.1836 0.1552 0.2273 0.2208 0.2505 0.0660 -0.0179 -0.0372 patch_mess~m | 0.1276 0.2045 0.2036 0.2260 0.2511 0.2527 0.2295 0.2273 -0.0224 -0.0374 start_date | 0.0272 0.0361 0.0308 0.0062 0.0047 0.0044 0.0184 -0.0526 0.2431 0.5010 commit | 0.0738 0.0918 0.0978 0.1162 0.1130 0.1201 0.1323 0.0626 -0.0077 -0.0107 ts | -0.0304 -0.0858 -0.0698 -0.0414 -0.0977 -0.0803 -0.0630 0.0846 0.1997 0.4987 tf | -0.0304 -0.0858 -0.0698 -0.0414 -0.0977 -0.0803 -0.0630 0.0846 0.1997 0.4987 _st | . . . . . . . . . . _d | 0.0738 0.0918 0.0978 0.1162 0.1130 0.1201 0.1323 0.0626 -0.0077 -0.0107 _t | -0.0304 -0.0858 -0.0698 -0.0414 -0.0977 -0.0803 -0.0630 0.0846 0.1997 0.4987 _t0 | -0.0304 -0.0858 -0.0697 -0.0414 -0.0977 -0.0803 -0.0630 0.0846 0.1997 0.4987 dev_pct | -0.0050 0.0286 0.0204 0.0180 0.0608 0.0477 0.0261 -0.0260 -0.5118 -0.8095 time_trend | -0.0032 -0.0497 -0.0390 -0.0351 -0.0929 -0.0758 -0.0446 0.0321 0.4418 0.9975 patch_any | 0.1126 0.1886 0.1746 0.1193 0.1924 0.1760 0.1806 0.2676 -0.0122 -0.0370 patch_curr~t | 0.1243 0.2181 0.1999 0.1542 0.2427 0.2194 0.2427 0.0832 -0.0186 -0.0438 success_pct | . . . . . . . . . . | devs_cum ~bmitted patche.. ~mmitted patche.. patch_~s patch_~m start_~e commit ts -------------+------------------------------------------------------------------------------------------ devs_cum | 1.0000 patches_su~d | -0.0264 1.0000 patches_su~m | -0.0309 0.2500 1.0000 patches_co~d | . . . . patches_co~m | . . . . . patch_mess~s | -0.0414 0.6477 0.2567 . . 1.0000 patch_mess~m | -0.0424 0.1931 0.8343 . . 0.3139 1.0000 start_date | 0.4886 -0.0021 -0.0346 . . -0.0028 -0.0516 1.0000 commit | -0.0102 0.0172 0.0756 . . 0.0491 0.1060 -0.0052 1.0000 ts | 0.4856 -0.0226 0.0073 . . -0.0346 0.0137 -0.4979 -0.0055 1.0000 tf | 0.4856 -0.0226 0.0073 . . -0.0346 0.0137 -0.4979 -0.0055 1.0000 _st | . . . . . . . . . . _d | -0.0102 0.0172 0.0756 . . 0.0491 0.1060 -0.0052 1.0000 -0.0055 _t | 0.4856 -0.0226 0.0073 . . -0.0346 0.0137 -0.4979 -0.0055 1.0000 _t0 | 0.4856 -0.0226 0.0073 . . -0.0346 0.0137 -0.4978 -0.0055 1.0000 dev_pct | -0.6920 0.0131 0.0105 . . 0.0195 0.0175 -0.4063 0.0131 -0.3791 time_trend | 0.9721 -0.0247 -0.0272 . . -0.0374 -0.0378 0.4997 -0.0106 0.5025 patch_any | -0.0397 0.0983 0.4002 . . 0.1649 0.4983 -0.0652 0.0227 0.0275 patch_curr~t | -0.0484 0.4422 0.2020 . . 0.7421 0.2667 -0.0004 0.0582 -0.0439 success_pct | . . . . . . . . . . | tf _st _d _t _t0 dev_pct time_t~d patch_~y patch_~t succes~t -------------+------------------------------------------------------------------------------------------ tf | 1.0000 _st | . . _d | -0.0055 . 1.0000 _t | 1.0000 . -0.0055 1.0000 _t0 | 1.0000 . -0.0055 1.0000 1.0000 dev_pct | -0.3791 . 0.0131 -0.3791 -0.3791 1.0000 time_trend | 0.5025 . -0.0106 0.5025 0.5025 -0.7837 1.0000 patch_any | 0.0275 . 0.0227 0.0275 0.0275 0.0231 -0.0375 1.0000 patch_curr~t | -0.0439 . 0.0582 -0.0439 -0.0439 0.0245 -0.0442 0.2222 1.0000 success_pct | . . . . . . . . . . . . *plot Kaplan-Meier survivor function, time axis in years . sts graph, failure _d: commit == 1 analysis time _t: tf id: id . graph save km_commit_postgres,replace (file km_commit_postgres.gph saved) . graph export km_commit_postgres.eps,replace (file km_commit_postgres.eps written in EPS format) . . *plot Nelson-Aalen cumulative hazard function, time axis in years . sts graph,na failure _d: commit == 1 analysis time _t: tf id: id . graph save na_commit_postgres,replace (file na_commit_postgres.gph saved) . graph export na_commit_postgres.eps,replace (file na_commit_postgres.eps written in EPS format) . . *plot smoothed hazard function, time axis in years . sts graph,hazard failure _d: commit == 1 analysis time _t: tf id: id . graph save haz_commit_postgres,replace (file haz_commit_postgres.gph saved) . graph export haz_commit_postgres.eps,replace (file haz_commit_postgres.eps written in EPS format) . . *erase extraneous files . erase run1.dta . erase run2.dta . . clear . log close log: D:\Anands Documents\Working Papers\Devanbu\Data\commit\commit_postgres.txt log type: text closed on: 19 Mar 2007, 12:11:25 ------------------------------------------------------------------------------------------------------------