-------------------------------------------------------------------------------
log: /Volumes/ecxs2/users/baum/crsp/327evstud4.smcl
log type: smcl
opened on: 20 Feb 2008, 17:14:44
. use 327evstud, clear
. su
Variable | Obs Mean Std. Dev. Min Max
-------------+--------------------------------------------------------
permno | 120040 73573.67 20615.54 10016 91581
permco | 120040 20760.68 13750.25 323 51428
date | 0
ret | 119658 .0008281 .036728 -.7 2.333333
caldt | 120040 16093.33 635.5842 14977 17164
-------------+--------------------------------------------------------
event_date | 120040 16102.33 371.4021 15013 17141
first_date | 120040 15098.66 352.4275 14977 17111
last_date | 120040 17083.34 307.1394 15022 17164
trday | 120040 684.4097 433.7066 1 1507
target | 107 565.5514 318.2292 13 1107
-------------+--------------------------------------------------------
td | 120040 690.1725 252.0905 13 1107
dif | 120040 -5.762862 449.3579 -1106 1121
yymmdd | 0
vwretd | 120040 .0002864 .0095211 -.0468039 .0530638
. // define the event and estmation windows
. local wlo -2
. local whi 2
. local nevent = `whi' - `wlo'
. local elo -60
. local ehi -30
. bys permno: g event_window = (dif >=`wlo' & dif <=`whi')
. egen count_event_obs = count(event_window), by(permno)
. bys permno: g est_window = (dif>=`elo' & dif <= `ehi')
. egen count_est_obs = count(est_window), by(permno)
.
. // screen out firms with inadequate obs
. drop if count_est_obs < abs(`elo') - abs(`ehi')
(0 observations deleted)
. drop if count_event_obs < `whi' - `wlo'
(0 observations deleted)
.
. // estimate normal performance
. g double predicted_return = .
(120040 missing values generated)
. levelsof permno, local(keys)
10016 10550 11411 11581 12260 15667 26607 31051 42200 47248 48961 50876 51706 5
> 1960 57330 59010 59328 65307 67029 67300 67360 68742 73809 75465 75489 75897
> 76136 76148 76194 76224 76274 76702 76900 77026 77855 77860 78193 78213 78807
> 78881 79610 79788 80169 80438 80478 80592 80812 81022 81499 81689 82727 8283
> 9 83414 83825 83923 83953 83956 84550 84648 84782 84808 85332 85347 85482 855
> 22 85706 86452 87096 87347 87429 87444 87521 87571 88219 88298 88580 88609 88
> 860 88868 89009 89093 89156 89255 89335 89396 89436 89458 89681 89730 89810 8
> 9885 89990 90169 90309 90331 90335 90514 90552 90644 90909 91090 91201 91202
> 91282 91381 91497 91581
. foreach f of local keys {
2. capt reg ret vwretd if permno==`f' & est_window
3. if _rc==0 {
4. tempvar rhat
5. qui predict double `rhat' if permno==`f'
6. qui replace predicted_return = `rhat' if permno==`f' & eve
> nt_window
7. }
8. }
.
. // calculate abnormal return and CAR, and test for significance
. gen double abnormal = ret - predicted_return if event_window
(119525 missing values generated)
. egen CAR = sum(abnormal), by(permno)
. egen arsd = sd(abnormal), by(permno)
(1620 missing values generated)
. g test = (1/`nevent') * (CAR / arsd)
(1620 missing values generated)
. g pval = 1-normprob(abs(test))
(1620 missing values generated)
. format test %7.2f
. format pval %5.4f
. format event_date %td
. sort test
. l permno event_date CAR test pval if dif==0 & test < ., noobs sep(0)
+-------------------------------------------------+
| permno event_d~e CAR test pval |
|-------------------------------------------------|
| 76702 09oct2002 -.0461067 -3.62 0.0001 |
| 90552 26aug2005 -.0184955 -1.70 0.0447 |
| 51960 14jul2004 -.0979993 -1.63 0.0511 |
| 91282 18oct2006 -.0580511 -1.26 0.1047 |
| 88860 03jun2004 -.0990096 -1.23 0.1089 |
| 89436 23mar2005 -.0170175 -1.20 0.1151 |
| 89396 16jul2003 -.0933287 -1.19 0.1168 |
| 10550 25sep2003 -.1161364 -1.07 0.1429 |
| 77855 27apr2005 -.0501787 -0.95 0.1722 |
| 90169 02may2006 -.1548956 -0.92 0.1781 |
| 84808 10jan2003 -.0732438 -0.90 0.1835 |
| 81022 21may2003 -.0196086 -0.85 0.1976 |
| 75897 11nov2003 -.0743261 -0.84 0.1993 |
| 90309 26oct2005 -.0783687 -0.82 0.2058 |
| 87444 13apr2004 -.0437653 -0.81 0.2085 |
| 89990 28feb2006 -.0138769 -0.70 0.2415 |
| 89156 07jun2005 -.0247691 -0.69 0.2450 |
| 83414 04may2004 -.0242185 -0.69 0.2465 |
| 80169 23feb2005 -.0370844 -0.61 0.2719 |
| 57330 05feb2004 -.0276352 -0.60 0.2734 |
| 11581 04mar2005 -.0247245 -0.52 0.3016 |
| 80812 03may2005 -.0387972 -0.51 0.3047 |
| 68742 03sep2004 -.0341616 -0.49 0.3130 |
| 15667 09oct2002 -.0797633 -0.47 0.3186 |
| 89255 28jun2002 -.0391066 -0.45 0.3261 |
| 89458 10sep2003 -.0256764 -0.45 0.3271 |
| 89730 13oct2004 -.0151168 -0.42 0.3384 |
| 50876 08mar2005 -.0092315 -0.40 0.3461 |
| 76900 17jul2001 -.0629941 -0.39 0.3486 |
| 86452 05feb2003 -.0071572 -0.38 0.3531 |
| 90514 17nov2005 -.0230865 -0.35 0.3640 |
| 76194 21aug2002 -.0341284 -0.34 0.3662 |
| 87521 16jun2004 -.0481931 -0.34 0.3665 |
| 80478 09mar2004 -.0188547 -0.34 0.3675 |
| 76224 28jan2004 -.0355708 -0.33 0.3723 |
| 80592 23nov2004 -.0183787 -0.33 0.3724 |
| 87571 20aug2003 -.045074 -0.32 0.3751 |
| 79788 28jan2005 -.0109088 -0.32 0.3762 |
| 91381 29sep2006 -.0201364 -0.29 0.3844 |
| 87429 21mar2001 -.1006099 -0.29 0.3852 |
| 89093 27sep2002 -.035091 -0.23 0.4073 |
| 90335 12aug2005 -.0706395 -0.22 0.4125 |
| 42200 28sep2004 -.009896 -0.19 0.4258 |
| 87096 14nov2001 -.0478029 -0.18 0.4283 |
| 12260 24jan2003 -.028681 -0.18 0.4284 |
| 73809 16feb2005 -.010472 -0.17 0.4329 |
| 79610 15aug2002 -.0457576 -0.17 0.4344 |
| 89335 16dec2003 -.0139895 -0.13 0.4491 |
| 78193 14jan2003 -.0105486 -0.04 0.4828 |
| 78881 04apr2003 -.0009639 -0.04 0.4852 |
| 48961 05nov2002 -.0020785 -0.03 0.4895 |
| 91201 24oct2006 -.0007579 -0.02 0.4913 |
| 85522 06feb2004 -.0016847 -0.02 0.4936 |
| 59328 21jan2003 -.0003191 -0.00 0.4987 |
| 26607 03dec2004 .000378 0.00 0.4987 |
| 91090 13jun2006 .0036436 0.02 0.4910 |
| 75465 23oct2003 .0005243 0.03 0.4895 |
| 76148 27feb2004 .0045316 0.03 0.4878 |
| 77026 28aug2003 .008725 0.07 0.4728 |
| 75489 02apr2003 .0091465 0.10 0.4583 |
| 90909 17mar2006 .008025 0.11 0.4579 |
| 87347 20jun2002 .0371063 0.12 0.4537 |
| 67360 31may2005 .00406 0.16 0.4358 |
| 11411 07dec2004 .0216771 0.23 0.4076 |
| 47248 28nov2003 .0084085 0.25 0.3996 |
| 77860 22jul2003 .0230893 0.26 0.3987 |
| 91202 29aug2006 .0313684 0.28 0.3886 |
| 81499 26jan2005 .0277505 0.31 0.3795 |
| 59010 28aug2002 .0154359 0.31 0.3783 |
| 78213 09nov2004 .0895498 0.39 0.3465 |
| 84550 02mar2001 1.921142 0.40 0.3431 |
| 85347 15aug2003 .0279342 0.43 0.3351 |
| 88868 27aug2002 .0294438 0.46 0.3221 |
| 85482 21apr2004 .0376047 0.46 0.3213 |
| 89810 20jan2005 .0507107 0.48 0.3170 |
| 84782 07dec2001 .0596102 0.48 0.3153 |
| 51706 18sep2003 .0169309 0.48 0.3146 |
| 89885 28oct2005 .1426962 0.51 0.3066 |
| 89009 12feb2003 .0069225 0.51 0.3048 |
| 90644 20sep2005 .1561582 0.53 0.2976 |
| 83825 06mar2001 .0457107 0.58 0.2806 |
| 78807 06nov2001 .0138368 0.63 0.2657 |
| 31051 11jan2005 .0502203 0.64 0.2602 |
| 83953 03sep2003 .0461275 0.66 0.2547 |
| 76274 26may2004 .0566912 0.67 0.2516 |
| 88298 16mar2004 .020426 0.69 0.2449 |
| 83923 22feb2005 .2178374 0.71 0.2378 |
| 84648 08apr2003 .0801753 0.76 0.2243 |
| 82839 14jul2004 .0797305 0.78 0.2168 |
| 83956 22nov2002 .1759411 0.79 0.2157 |
| 82727 19jul2002 .0988225 0.81 0.2084 |
| 81689 15nov2001 .4840554 0.82 0.2064 |
| 76136 15oct2003 .018411 0.92 0.1786 |
| 88609 06jan2004 .0162659 0.99 0.1619 |
| 80438 10oct2001 .1175528 0.99 0.1611 |
| 90331 10nov2005 .0253384 1.01 0.1561 |
| 88580 13apr2005 .1094759 1.02 0.1544 |
| 88219 16may2003 .0071333 1.31 0.0953 |
| 89681 27apr2005 .0219369 1.32 0.0937 |
| 65307 11mar2003 .1585437 1.57 0.0586 |
| 85706 14nov2002 .0806415 1.65 0.0498 |
| 85332 30mar2004 .0193681 1.67 0.0477 |
| 10016 21feb2001 .0473362 3.08 0.0010 |
+-------------------------------------------------+
.
. // test across all events
. reg CAR if dif==0, robust
Linear regression Number of obs = 107
F( 0, 106) = 0.00
Prob > F = .
R-squared = 0.0000
Root MSE = .20015
------------------------------------------------------------------------------
| Robust
CAR | Coef. Std. Err. t P>|t| [95% Conf. Interval]
-------------+----------------------------------------------------------------
_cons | .0242587 .0193492 1.25 0.213 -.014103 .0626205
------------------------------------------------------------------------------
.
. log close
log: /Volumes/ecxs2/users/baum/crsp/327evstud4.smcl
log type: smcl
closed on: 20 Feb 2008, 17:15:11
-------------------------------------------------------------------------------