-----------------------------------------------------------------------------------------------------------------------------
name: <unnamed>
log: /Users/baum/Documents/Chuck/ ChuckLitGov4/litgov4-11.smcl
log type: smcl
opened on: 5 Feb 2010, 13:57:55
.
. // bring in decision dates, merge with estimation sample database
.
. local in1 caseinputfileDates
. local dpm = 365.25/12
.
. insheet using `in1'.csv, names clear
(4 vars, 555 obs)
. tab action_type
action_type | Freq. Percent Cum.
------------+-----------------------------------
PRI | 500 90.09 90.09
SEC1 | 47 8.47 98.56
SEC2 | 6 1.08 99.64
SEC3 | 2 0.36 100.00
------------+-----------------------------------
Total | 555 100.00
. keep if action_type == "PRI"
(55 observations deleted)
. g dateDismissed = date(dismissal_date, "MDY")
(315 missing values generated)
. g dateSettled = date(settlement_date, "MDY")
(200 missing values generated)
. save `in1'.dta, replace
file caseinputfileDates.dta saved
.
. local ts 9408
. local in2 litgov4_est3`ts'
. use `in2', clear
. drop if ~t56s
(28462 observations deleted)
. drop casetag cc
. egen casetag = tag(case_code)
. keep if casetag
(2831 observations deleted)
. merge 1:1 case_code using `in1'
Result # of obs.
-----------------------------------------
not matched 167
from master 0 (_merge==1)
from using 167 (_merge==2)
matched 333 (_merge==3)
-----------------------------------------
. keep if _merge == 3
(167 observations deleted)
. drop _merge
.
. g dateFiled = date(filing_date, "MDY", 2040)
. format %td date*
. su date*
Variable | Obs Mean Std. Dev. Min Max
-------------+--------------------------------------------------------
dateDismis~d | 135 15678.17 882.8366 13500 17801
dateSettled | 194 15984.25 867.3709 14101 17719
dateFiled | 333 14835.65 722.7854 13174 16049
. g timetoSettle = (dateSettled - dateFiled) / `dpm'
(139 missing values generated)
. g timetoDismiss = (dateDismissed - dateFiled) / `dpm'
(198 missing values generated)
. count if !mi(timetoSettle) | !mi(timetoDismiss)
329
. local ncase `r(N)'
. l case_code if mi(timetoSettle) & mi(timetoDismiss)
+----------+
| case_c~e |
|----------|
139. | FLS__01 |
148. | GILD_01 |
156. | HAL__01 |
298. | TLAB_01 |
+----------+
. su time*, detail
timetoSettle
-------------------------------------------------------------
Percentiles Smallest
1% 11.66324 8.279261
5% 15.67146 11.66324
10% 19.25257 12.22177 Obs 194
25% 25.92197 12.68172 Sum of Wgt. 194
50% 38.39014 Mean 40.47571
Largest Std. Dev. 17.91869
75% 52.43532 86.83368
90% 64.13142 87.42505 Variance 321.0793
95% 69.81519 92.28748 Skewness .549508
99% 92.28748 92.38604 Kurtosis 2.839033
timetoDismiss
-------------------------------------------------------------
Percentiles Smallest
1% 4.041068 2.069815
5% 5.256673 4.041068
10% 8.706366 4.271047 Obs 135
25% 14.45585 4.36961 Sum of Wgt. 135
50% 19.5154 Mean 24.62119
Largest Std. Dev. 15.61842
75% 33.34702 67.54826
90% 45.40452 68.04107 Variance 243.9352
95% 59.46612 74.34908 Skewness 1.233964
99% 74.34908 79.44147 Kurtosis 4.323133
. // within one year
. g oneyrSettled = (timetoSettle <= 12)
. g oneyrDismissed = (timetoDismiss <= 12)
. su oneyr*
Variable | Obs Mean Std. Dev. Min Max
-------------+--------------------------------------------------------
oneyrSettled | 333 .006006 .0773816 0 1
oneyrDismi~d | 333 .0660661 .2487714 0 1
.
. foreach v of varlist insthold sumout gindex {
2. su `v', detail
3. sktest `v'
4. }
Institutional Holdings
-------------------------------------------------------------
Percentiles Smallest
1% 12.68 6.92
5% 22.04 8.6
10% 29.37 11.06 Obs 323
25% 47.8 12.68 Sum of Wgt. 323
50% 64.63 Mean 61.73505
Largest Std. Dev. 20.75696
75% 77.2 96.02
90% 86.52 96.5 Variance 430.8513
95% 91.83 97.01 Skewness -.4915572
99% 96.02 97.11 Kurtosis 2.566439
Skewness/Kurtosis tests for Normality
------- joint ------
Variable | Obs Pr(Skewness) Pr(Kurtosis) adj chi2(2) Prob>chi2
-------------+---------------------------------------------------------------
insthold | 323 0.0005 0.0603 13.69 0.0011
Outside Blockholdings
-------------------------------------------------------------
Percentiles Smallest
1% 0 0
5% 0 0
10% 0 0 Obs 333
25% 0 0 Sum of Wgt. 333
50% 12.22 Mean 13.90853
Largest Std. Dev. 13.43537
75% 22.62 59.5
90% 31.99 61.61 Variance 180.5092
95% 37.2 62.9 Skewness .9866832
99% 59.5 66.3 Kurtosis 3.932603
Skewness/Kurtosis tests for Normality
------- joint ------
Variable | Obs Pr(Skewness) Pr(Kurtosis) adj chi2(2) Prob>chi2
-------------+---------------------------------------------------------------
sumout | 333 0.0000 0.0065 37.93 0.0000
Gindex
-------------------------------------------------------------
Percentiles Smallest
1% 4 3
5% 5 3
10% 6 3 Obs 301
25% 7 4 Sum of Wgt. 301
50% 8 Mean 8.684385
Largest Std. Dev. 2.518608
75% 10 15
90% 12 15 Variance 6.343389
95% 13 16 Skewness .3235794
99% 15 16 Kurtosis 2.795612
Skewness/Kurtosis tests for Normality
------- joint ------
Variable | Obs Pr(Skewness) Pr(Kurtosis) adj chi2(2) Prob>chi2
-------------+---------------------------------------------------------------
gindex | 301 0.0219 0.5315 5.64 0.0596
.
. kdensity timetoSettle, g(x1 dSettled) nogr
. kdensity timetoDismiss, g(x2 dDismissed) nogr
. label var x1 months
. label var dSettled "Time to Settlement"
. label var x2 months
. label var dDismissed "Time to Dismissal"
. line dSettled x1 || line dDismissed x2, scheme(s2mono) ///
> ti("Time to decision of `ncase' SFCA lawsuits") ///
> yti(empirical density) saving(timetoDecision, replace)
(file timetoDecision.gph saved)
. graph export timetoDecision.pdf, replace
(file /Users/baum/Documents/Chuck/ ChuckLitGov4/timetoDecision.pdf written in PDF format)