-------------------------------------------------------------------------------------------------------------------
log: /Users/baum/Documents/boyan/Boyan-CorpGov/CorpGov_revise/udcl9218-1.smcl
log type: smcl
opened on: 18 Feb 2009, 14:08:30
. // udcl9218-1 examine Gindex for UDCL estimation sample, Compustat through 2007, IRRC through 2006
. use udcl9218_estsample, clear
. desc
Contains data from udcl9218_estsample.dta
obs: 13,240
vars: 215 18 Feb 2009 13:43
size: 8,275,000 (98.4% of memory free)
-------------------------------------------------------------------------------------------------------------------
storage display value
variable name type format label variable label
-------------------------------------------------------------------------------------------------------------------
dnum int %8.0g industry classification code
cnum str6 %6s cusip issuer code
cic str3 %3s cusip issue number and check digit
smbl str8 %9s stock ticker symbol
spdrc str2 %2s s&p lt domest. issuer credit rating- cur
spdrcf str1 %1s ftnt- s&p lt dom issuer cred rating- cur
subdbt str1 %1s s&p subordinated debt rating - current
spcprc str3 %3s s&p st domest. issuer credit rating- cur
date int %d fiscal year
data1 double %10.0g cash and short-term investments (mm$)
data2 double %10.0g receivables - total (mm$)
data5 double %10.0g current liabilities - total (mm$)
data6 double %10.0g assets - total (mm$)
data9 double %10.0g long-term debt - total (mm$)
data10 double %10.0g preferred stock - liquidating value(mm$)
data12 double %10.0g sales (net) (mm$)
data13 float %9.0g operating income before deprec. (mm$)
data14 float %9.0g depreciation and amortization (mm$)
data15 float %9.0g interest expense (mm$)
data16 float %9.0g income taxes - total (mm$)
data17 float %9.0g special items (mm$)
data18 float %9.0g income before extraordinary items (mm$)
data21 float %9.0g dividends - common (mm$)
data25 float %9.0g common shares outstanding (mm)
data34 double %10.0g debt in current liabilities (mm$)
data35 float %9.0g deferred tax & invest tax credit...(mm$)
data46 float %9.0g research and development expense (mm$)
data50 float %9.0g deferred taxes (income account) (mm$)
data51 float %9.0g investment tax credit (income acct)(mm$)
data54 float %9.0g common shares used to calculate eps (mm)
data56 double %10.0g preferred stock - redemption value (mm$)
data79 float %9.0g debt - convertible (mm$)
data108 float %9.0g sale of common and pref. stock... (mm$)
data111 double %10.0g long-term debt - issuance... (mm$)
data114 double %10.0g long-term debt - reduction... (mm$)
data115 float %9.0g purchase of common and pref. stock (mm$)
data128 float %9.0g capital expenditures (scf) (mm$)
data129 double %10.0g acquisitions (statement of cf) (mm$)
data130 float %9.0g preferred stock - carrying value (mm$)
data179 float %9.0g working capital (balance sheet) (mm$)
data180 float %9.0g working capital change - total(soc)(mm$)
data192 float %9.0g extraordinary items (mm$)
data199 double %10.0g price -- fiscal year -- close ($&c)
data236 float %9.0g working capital change- other... (mm$)
data274 float %9.0g cash & cash equiv- increase(dec)...(mm$)
data280 byte %8.0g s&p lt domestic issuer credit rating
data283 int %8.0g s&p st dom. issuer credit rating- hist
data301 double %10.0g changes in current debt (scf) (mm$)
coname str28 %28s company name
yeara float %8.0g fiscal year
gvkey str6 %6s Global Company Key
datadate str8 %8s Data Date
indfmt str12 %12s Industry Format
consol str2 %2s Level of Consolidation - Compan
popsrc str2 %2s Population Source
datafmt str12 %12s Data Format
cusip str10 %10s CUSIP
curcd str4 %4s ISO Currency Code
costat str2 %2s Active/Inactive Status Marker
sic str4 %4s Standard Industry Classificatio
company str48 %48s company name
blankcheck byte %8.0g blank check preferred
cboard byte %8.0g classified board
fairprice byte %8.0g fair price
supermajor byte %8.0g supermajority to approve merger
antigreen byte %8.0g antigreenmail
lwcnst byte %8.0g limit ability to act by written consent
lspmt byte %8.0g limit ability to call special meeting
dutiesnf byte %8.0g director's duties--nonfinancial impact
dualclass byte %8.0g dual class common stock
uneqvote byte %8.0g unequal voting rights
lachtr byte %8.0g limit ability to amend charter
ppill byte %8.0g poison pill
advnr byte %8.0g advance notice requirements
confvote byte %8.0g confidential voting
exsvchg byte %8.0g change in control provisions
sparachute byte %8.0g silver parachute
pparachute byte %8.0g pension parachute
cumvote byte %8.0g cumulative voting
labylw byte %8.0g limit ability to amend bylaws
compplan byte %8.0g compensation plan with change in control
cumvotess byte %8.0g substantial shareholder
gparachute byte %8.0g golden parachutes
oo_buscomp byte %8.0g opt out of buscomb/freezeout law
oo_cashout_pa byte %8.0g opt out of control share cashout law (pa)
oo_csa byte %8.0g opt out of control share acquisition law(csa)
oo_duties byte %8.0g opt out of directors duties law
oo_fairprice byte %8.0g opt out of fair price law
oo_rprofits byte %8.0g opt out of recapture of profits law
oi_bc_ga byte %8.0g opt in to buscomb/freezeout law(ga)
oi_fp_ga byte %8.0g opt in to fair price law(ga)
oi_csa byte %8.0g opt in to control share acquisition law(csa)
exch str6 %6s stocke exchange
dirind byte %8.0g director indemnification
dirindc byte %8.0g indemnification contracts
dirliab byte %8.0g director liability
execsv byte %8.0g executive severance agreement
state str2 %2s state of incorporation
de_inc byte %8.0g delaware incorporation
sl_buscomp byte %8.0g business combination law
sl_fairprice byte %8.0g fair price law
sl_csa byte %8.0g control share acquisition law
sl_rprofits byte %8.0g recapture of profits law
sl_cashout byte %8.0g cash out law
sl_duties byte %8.0g director's duties law
date1 long %d beginning day. date used to create range of time when irrc data is
applicable.
date2 long %d ending day. date used to create range of time when irrc data is
applicable.
gindex byte %8.0g governance index (gompers, ishii, metrick)
secretballot byte %8.0g combined secret ballot
goldenparachute byte %8.0g combined golden parachutes
severance byte %8.0g combined severance
page int %8.0g irrc page number
yr_reinc byte %8.0g year of reincorporation
ecumvote byte %8.0g eliminate cumulative voting
empc byte %8.0g employee contracts
scrtbt byte %8.0g secret ballot
cik str10 %10s cik
mergecusip byte %8.0g
mergeticker byte %8.0g
matched float %9.0g
prsd float %9.0g
TB3MS double %10.0g (mean) TB3MS
CPIAUCSL double %10.0g (mean) CPIAUCSL
dlead float %9.0g (mean) dlead
leadinc_v double %10.0g (mean) leadinc_v
infl_v double %10.0g (mean) infl_v
firmid long %8.0g firmid cusip issuer code
sic2 float %9.0g
ind1 byte %8.0g sic2== 1.0000
ind2 byte %8.0g sic2== 7.0000
ind3 byte %8.0g sic2== 10.0000
ind4 byte %8.0g sic2== 12.0000
ind5 byte %8.0g sic2== 13.0000
ind6 byte %8.0g sic2== 14.0000
ind7 byte %8.0g sic2== 15.0000
ind8 byte %8.0g sic2== 16.0000
ind9 byte %8.0g sic2== 17.0000
ind10 byte %8.0g sic2== 20.0000
ind11 byte %8.0g sic2== 21.0000
ind12 byte %8.0g sic2== 22.0000
ind13 byte %8.0g sic2== 23.0000
ind14 byte %8.0g sic2== 24.0000
ind15 byte %8.0g sic2== 25.0000
ind16 byte %8.0g sic2== 26.0000
ind17 byte %8.0g sic2== 27.0000
ind18 byte %8.0g sic2== 28.0000
ind19 byte %8.0g sic2== 29.0000
ind20 byte %8.0g sic2== 30.0000
ind21 byte %8.0g sic2== 31.0000
ind22 byte %8.0g sic2== 32.0000
ind23 byte %8.0g sic2== 33.0000
ind24 byte %8.0g sic2== 34.0000
ind25 byte %8.0g sic2== 35.0000
ind26 byte %8.0g sic2== 36.0000
ind27 byte %8.0g sic2== 37.0000
ind28 byte %8.0g sic2== 38.0000
ind29 byte %8.0g sic2== 39.0000
ind30 byte %8.0g sic2== 40.0000
ind31 byte %8.0g sic2== 41.0000
ind32 byte %8.0g sic2== 42.0000
ind33 byte %8.0g sic2== 44.0000
ind34 byte %8.0g sic2== 45.0000
ind35 byte %8.0g sic2== 47.0000
ind36 byte %8.0g sic2== 48.0000
ind37 byte %8.0g sic2== 50.0000
ind38 byte %8.0g sic2== 51.0000
ind39 byte %8.0g sic2== 52.0000
ind40 byte %8.0g sic2== 53.0000
ind41 byte %8.0g sic2== 54.0000
ind42 byte %8.0g sic2== 55.0000
ind43 byte %8.0g sic2== 56.0000
ind44 byte %8.0g sic2== 57.0000
ind45 byte %8.0g sic2== 58.0000
ind46 byte %8.0g sic2== 59.0000
ind47 byte %8.0g sic2== 70.0000
ind48 byte %8.0g sic2== 72.0000
ind49 byte %8.0g sic2== 73.0000
ind50 byte %8.0g sic2== 75.0000
ind51 byte %8.0g sic2== 78.0000
ind52 byte %8.0g sic2== 79.0000
ind53 byte %8.0g sic2== 80.0000
ind54 byte %8.0g sic2== 82.0000
ind55 byte %8.0g sic2== 83.0000
ind56 byte %8.0g sic2== 87.0000
yrr1 byte %8.0g yeara== 1990.0000
yrr2 byte %8.0g yeara== 1991.0000
yrr3 byte %8.0g yeara== 1992.0000
yrr4 byte %8.0g yeara== 1993.0000
yrr5 byte %8.0g yeara== 1994.0000
yrr6 byte %8.0g yeara== 1995.0000
yrr7 byte %8.0g yeara== 1996.0000
yrr8 byte %8.0g yeara== 1997.0000
yrr9 byte %8.0g yeara== 1998.0000
yrr10 byte %8.0g yeara== 1999.0000
yrr11 byte %8.0g yeara== 2000.0000
yrr12 byte %8.0g yeara== 2001.0000
yrr13 byte %8.0g yeara== 2002.0000
yrr14 byte %8.0g yeara== 2003.0000
yrr15 byte %8.0g yeara== 2004.0000
yrr16 byte %8.0g yeara== 2005.0000
yrr17 byte %8.0g yeara== 2006.0000
yrr18 byte %8.0g yeara== 2007.0000
CFr float %9.0g
C float %9.0g
I float %9.0g
S float %9.0g
prsd_gindex float %9.0g L.prsd*gindex
infl_v_gindex float %9.0g L.infl_v*gindex
leadinc_v_gin~x float %9.0g L.leadinc_v*gindex
_est_est1 byte %8.0g esample() from estimates store
ds byte %8.0g
_est_est2 byte %8.0g esample() from estimates store
_est_est3 byte %8.0g esample() from estimates store
_est_est4 byte %8.0g esample() from estimates store
_est_est5 byte %8.0g esample() from estimates store
-------------------------------------------------------------------------------------------------------------------
Sorted by: firmid yeara
. su
Variable | Obs Mean Std. Dev. Min Max
-------------+--------------------------------------------------------
dnum | 13240 4076.183 1761.057 100 8742
cnum | 0
cic | 0
smbl | 0
spdrc | 0
-------------+--------------------------------------------------------
spdrcf | 0
subdbt | 0
spcprc | 0
date | 13240 14398.54 1585.951 11688 16802
data1 | 13240 450.289 1896.54 0 60592
-------------+--------------------------------------------------------
data2 | 13172 914.6697 6449.104 0 199407
data5 | 12854 1130.162 3029.067 1.427 51754
data6 | 13240 5283.976 17691.98 12.59 479921
data9 | 13208 1164.12 5237.742 0 207174
data10 | 13222 30.45407 196.9905 0 6532
-------------+--------------------------------------------------------
data12 | 13237 5099.079 15045.54 0 345977
data13 | 13222 763.4599 2355.772 -5743 68355
data14 | 13223 241.0012 853.9988 .033 16519
data15 | 12630 102.9368 482.2088 0 16945
data16 | 13236 150.4787 623.2149 -5878 27902
-------------+--------------------------------------------------------
data17 | 12820 -56.74968 619.833 -51066.2 15006
data18 | 13237 261.4703 1239.842 -56121.9 39500
data21 | 13199 97.24587 503.9171 0 36968
data25 | 13210 176.9868 512.343 0 10862
data34 | 13235 363.9151 3140.561 -882 93105
-------------+--------------------------------------------------------
data35 | 13237 234.1332 1130.977 0 36713
data46 | 8301 205.8954 699.5727 0 12183
data50 | 12855 6.960702 191.4024 -6570 5268
data51 | 8465 2.135851 31.55617 0 2400
data54 | 13217 176.6142 512.8564 1.255 10839
-------------+--------------------------------------------------------
data56 | 13222 31.28876 200.747 0 6532
data79 | 13075 58.3318 243.5628 0 8050
data108 | 12776 52.33407 235.0201 -3.143 10413
data111 | 12628 408.425 2392.966 0 97860
data114 | 12833 334.6373 1923.84 0 92290
-------------+--------------------------------------------------------
data115 | 12531 142.1446 695.7667 0 29558
data128 | 13206 319.0389 1213.832 0 33143
data129 | 12325 101.1745 534.0871 -4507 21087
data130 | 13239 17.47296 109.3831 -79 2397
data179 | 12796 453.4322 1557.552 -33780 55597
-------------+--------------------------------------------------------
data180 | 0
data192 | 13236 -16.45023 346.2139 -22800 2534
data199 | 13226 31.89577 33.26703 .028 998
data236 | 0
data274 | 13224 35.3596 438.5069 -11972 12234
-------------+--------------------------------------------------------
data280 | 7445 11.07871 3.541757 2 29
data283 | 3259 102.5002 1.360085 101 111
data301 | 7127 -7.565929 698.9609 -18273 16973
coname | 0
yeara | 13240 1999.42 4.342025 1992 2006
-------------+--------------------------------------------------------
gvkey | 0
datadate | 0
indfmt | 0
consol | 0
popsrc | 0
-------------+--------------------------------------------------------
datafmt | 0
cusip | 0
curcd | 0
costat | 0
sic | 0
-------------+--------------------------------------------------------
company | 0
blankcheck | 13240 .8640483 .3427502 0 1
cboard | 13240 .5798338 .4936041 0 1
fairprice | 13240 .2736405 .4458435 0 1
supermajor | 13240 .1879909 .3907197 0 1
-------------+--------------------------------------------------------
antigreen | 13240 .0577039 .2331915 0 1
lwcnst | 13240 .3608761 .4802728 0 1
lspmt | 13240 .3901813 .4878092 0 1
dutiesnf | 13240 .0728852 .2599578 0 1
dualclass | 13240 .1095166 .3122981 0 1
-------------+--------------------------------------------------------
uneqvote | 13240 .0153323 .1228755 0 1
lachtr | 13240 .0216767 .1456312 0 1
ppill | 13240 .5930514 .4912837 0 1
advnr | 13240 .5441088 .4980694 0 1
confvote | 13240 .116994 .3214252 0 1
-------------+--------------------------------------------------------
exsvchg | 13240 .5786254 .493798 0 1
sparachute | 13240 .0289275 .1676091 0 1
pparachute | 13240 .0302115 .1711752 0 1
cumvote | 13240 .1129909 .3165937 0 1
labylw | 13240 .1740181 .3791394 0 1
-------------+--------------------------------------------------------
compplan | 13240 .725 .4465311 0 1
cumvotess | 13240 .0037009 .0607247 0 1
gparachute | 13240 .0299849 .170552 0 1
oo_buscomp | 13240 .0197885 .1392781 0 1
oo_cashout~a | 13240 .0037009 .0607247 0 1
-------------+--------------------------------------------------------
oo_csa | 13240 .040861 .1979757 0 1
oo_duties | 13240 .0072508 .0848453 0 1
oo_fairprice | 13240 .0021903 .0467515 0 1
oo_rprofits | 13240 .0180514 .1331422 0 1
oi_bc_ga | 13240 .002719 .0520754 0 1
-------------+--------------------------------------------------------
oi_fp_ga | 13240 .002568 .050612 0 1
oi_csa | 13240 .001284 .0358111 0 1
exch | 0
dirind | 13240 .3028701 .4595169 0 1
dirindc | 13240 .1291541 .3353831 0 1
-------------+--------------------------------------------------------
dirliab | 13240 .5418429 .4982649 0 1
execsv | 13240 .0773414 .2671425 0 1
state | 0
de_inc | 13240 .5820997 .4932322 0 1
sl_buscomp | 13240 .9218278 .2684525 0 1
-------------+--------------------------------------------------------
sl_fairprice | 13240 .3245468 .468223 0 1
sl_csa | 13240 .2656344 .4416871 0 1
sl_rprofits | 13240 .160574 .3671514 0 1
sl_cashout | 13240 .0306647 .172414 0 1
sl_duties | 13240 .0432024 .2033202 0 1
-------------+--------------------------------------------------------
date1 | 13240 14251.77 1605.852 11201 16802
date2 | 12279 14840.17 1422.27 12234 16801
gindex | 13240 9.320393 2.706351 2 18
secretballot | 13240 .1189577 .323751 0 1
goldenpara~e | 13240 .6086103 .4880797 0 1
-------------+--------------------------------------------------------
severance | 13240 .0860272 .2804148 0 1
page | 10155 853.6866 508.8079 4 1918
yr_reinc | 12279 7.504683 24.47399 0 99
ecumvote | 12279 .0658848 .2480908 0 1
empc | 12279 .0093656 .0963256 0 1
-------------+--------------------------------------------------------
scrtbt | 12279 .0021174 .0459687 0 1
cik | 0
mergecusip | 13240 3 0 3 3
mergeticker | 13240 2.551511 .8341994 1 3
matched | 13240 1 0 1 1
-------------+--------------------------------------------------------
prsd | 13209 3.100911 4.992215 .0487132 207.5426
TB3MS | 13240 3.671904 1.538365 1.010833 5.816667
CPIAUCSL | 13240 170.5221 18.29557 140.3083 201.5833
dlead | 13240 112.9977 15.94765 85.81667 137.8583
leadinc_v | 13240 2.498134 .3507368 1.961765 3.137511
-------------+--------------------------------------------------------
infl_v | 13240 4.976699 3.75997 1.778808 15.71469
firmid | 13240 1614.605 940.7141 1 3252
sic2 | 13240 40.35083 17.57743 1 87
ind1 | 13240 .002568 .050612 0 1
ind2 | 13240 .0001511 .0122901 0 1
-------------+--------------------------------------------------------
ind3 | 13240 .0075529 .0865817 0 1
ind4 | 13240 .001284 .0358111 0 1
ind5 | 13240 .0304381 .1717959 0 1
ind6 | 13240 .0026435 .051349 0 1
ind7 | 13240 .0094411 .0967092 0 1
-------------+--------------------------------------------------------
ind8 | 13240 .0040785 .0637356 0 1
ind9 | 13240 .0008308 .028813 0 1
ind10 | 13240 .0385196 .1924543 0 1
ind11 | 13240 .0030211 .054884 0 1
ind12 | 13240 .0112538 .1054892 0 1
-------------+--------------------------------------------------------
ind13 | 13240 .0129154 .112914 0 1
ind14 | 13240 .0087613 .0931946 0 1
ind15 | 13240 .0120091 .10893 0 1
ind16 | 13240 .0260574 .1593121 0 1
ind17 | 13240 .0292296 .1684559 0 1
-------------+--------------------------------------------------------
ind18 | 13240 .0883686 .2838409 0 1
ind19 | 13240 .0160121 .1255264 0 1
ind20 | 13240 .0135952 .1158074 0 1
ind21 | 13240 .0047583 .0688188 0 1
ind22 | 13240 .0114048 .1061867 0 1
-------------+--------------------------------------------------------
ind23 | 13240 .0280211 .1650395 0 1
ind24 | 13240 .0231873 .1505037 0 1
ind25 | 13240 .0805136 .2720969 0 1
ind26 | 13240 .0847432 .2785097 0 1
ind27 | 13240 .0443353 .2058468 0 1
-------------+--------------------------------------------------------
ind28 | 13240 .0550604 .2281068 0 1
ind29 | 13240 .0109517 .1040795 0 1
ind30 | 13240 .0071752 .0844055 0 1
ind31 | 13240 .0000755 .0086907 0 1
ind32 | 13240 .0054381 .0735452 0 1
-------------+--------------------------------------------------------
ind33 | 13240 .0053625 .0730355 0 1
ind34 | 13240 .0101964 .1004648 0 1
ind35 | 13240 .0033988 .0582022 0 1
ind36 | 13240 .0271903 .1626438 0 1
ind37 | 13240 .0314199 .1744564 0 1
-------------+--------------------------------------------------------
ind38 | 13240 .0148792 .1210738 0 1
ind39 | 13240 .0042296 .0649002 0 1
ind40 | 13240 .0152568 .1225772 0 1
ind41 | 13240 .0111782 .1051386 0 1
ind42 | 13240 .0046828 .068273 0 1
-------------+--------------------------------------------------------
ind43 | 13240 .0191088 .1369125 0 1
ind44 | 13240 .0082326 .090363 0 1
ind45 | 13240 .0176737 .1317675 0 1
ind46 | 13240 .0203927 .1413449 0 1
ind47 | 13240 .0033233 .0575541 0 1
-------------+--------------------------------------------------------
ind48 | 13240 .0061178 .0779798 0 1
ind49 | 13240 .083006 .2759018 0 1
ind50 | 13240 .0022659 .0475489 0 1
ind51 | 13240 .0026435 .051349 0 1
ind52 | 13240 .0073263 .0852828 0 1
-------------+--------------------------------------------------------
ind53 | 13240 .014426 .1192432 0 1
ind54 | 13240 .0028701 .0534983 0 1
ind55 | 13240 .0006798 .0260643 0 1
ind56 | 13240 .0097432 .0982293 0 1
yrr1 | 13240 0 0 0 0
-------------+--------------------------------------------------------
yrr2 | 13240 0 0 0 0
yrr3 | 13240 .0609517 .2392507 0 1
yrr4 | 13240 .0602719 .2379989 0 1
yrr5 | 13240 .0570997 .2320418 0 1
yrr6 | 13240 .0648792 .2463218 0 1
-------------+--------------------------------------------------------
yrr7 | 13240 .061858 .2409066 0 1
yrr8 | 13240 .0606495 .2386954 0 1
yrr9 | 13240 .0557402 .229428 0 1
yrr10 | 13240 .0507553 .2195059 0 1
yrr11 | 13240 .0755287 .2642525 0 1
-------------+--------------------------------------------------------
yrr12 | 13240 .070997 .2568295 0 1
yrr13 | 13240 .0763595 .2655825 0 1
yrr14 | 13240 .0719033 .2583375 0 1
yrr15 | 13240 .0888973 .2846062 0 1
yrr16 | 13240 .0715257 .2577106 0 1
-------------+--------------------------------------------------------
yrr17 | 13240 .0725831 .2594607 0 1
yrr18 | 13240 0 0 0 0
CFr | 13223 .0864498 .1233882 -4.13049 .8582552
C | 13240 .1201926 .1509193 0 .9275386
I | 13206 .0591867 .0498824 0 .6511506
-------------+--------------------------------------------------------
S | 13237 1.207599 .7381819 0 7.584212
prsd_gindex | 13215 28.23821 49.55833 .1003324 1596.183
infl_v_gin~x | 13240 39.04809 24.02987 3.753855 182.2004
leadinc_v_~x | 13240 22.69865 7.129067 3.923531 54.1888
_est_est1 | 13240 1 0 1 1
-------------+--------------------------------------------------------
ds | 13240 1 0 1 1
_est_est2 | 13240 .9981118 .0434142 0 1
_est_est3 | 13240 .9981118 .0434142 0 1
_est_est4 | 13240 .9981118 .0434142 0 1
_est_est5 | 13240 .9981118 .0434142 0 1
. egen fcount = tag(firmid)
. count if fcount
1887
. bys firmid: gen nobs = _N
. su nobs
Variable | Obs Mean Std. Dev. Min Max
-------------+--------------------------------------------------------
nobs | 13240 10.40755 4.52727 1 15
. tab nobs
nobs | Freq. Percent Cum.
------------+-----------------------------------
1 | 257 1.94 1.94
2 | 218 1.65 3.59
3 | 792 5.98 9.57
4 | 328 2.48 12.05
5 | 945 7.14 19.18
6 | 492 3.72 22.90
7 | 1,841 13.90 36.81
8 | 384 2.90 39.71
9 | 243 1.84 41.54
10 | 570 4.31 45.85
11 | 352 2.66 48.50
12 | 636 4.80 53.31
13 | 975 7.36 60.67
14 | 392 2.96 63.63
15 | 4,815 36.37 100.00
------------+-----------------------------------
Total | 13,240 100.00
. bys firmid: g dgindex = (D.gindex != 0 & _n > 1)
. bys firmid: g sdgindex = sum(dgindex)
. bys firmid: g fdgindex = sdgindex[_N] if _n == _N & _N > 1
(11610 missing values generated)
. su dgindex sdgindex fdgindex
Variable | Obs Mean Std. Dev. Min Max
-------------+--------------------------------------------------------
dgindex | 13240 .1481873 .355299 0 1
sdgindex | 13240 .8487915 .9592215 0 6
fdgindex | 1630 1.203681 1.134421 0 6
. l firmid gindex dgindex sdgindex fdgindex in 1/50, sepby(firmid)
+-------------------------------------------------+
| firmid gindex dgindex sdgindex fdgindex |
|-------------------------------------------------|
1. | 000361 15 0 0 . |
2. | 000361 15 0 0 . |
3. | 000361 15 0 0 . |
4. | 000361 15 0 0 . |
5. | 000361 15 0 0 . |
6. | 000361 15 0 0 . |
7. | 000361 15 0 0 . |
8. | 000361 15 0 0 . |
9. | 000361 15 0 0 . |
10. | 000361 15 0 0 . |
11. | 000361 15 0 0 . |
12. | 000361 15 0 0 . |
13. | 000361 15 0 0 0 |
|-------------------------------------------------|
14. | 000886 11 0 0 . |
15. | 000886 13 1 1 . |
16. | 000886 13 0 1 . |
17. | 000886 13 0 1 . |
18. | 000886 13 0 1 . |
19. | 000886 13 0 1 . |
20. | 000886 13 0 1 . |
21. | 000886 13 0 1 . |
22. | 000886 12 1 2 . |
23. | 000886 12 0 2 . |
24. | 000886 13 1 3 . |
25. | 000886 13 0 3 . |
26. | 000886 13 0 3 . |
27. | 000886 13 0 3 . |
28. | 000886 13 0 3 3 |
|-------------------------------------------------|
29. | 000957 11 0 0 . |
30. | 000957 11 0 0 . |
31. | 000957 11 0 0 . |
32. | 000957 11 0 0 . |
33. | 000957 10 1 1 . |
34. | 000957 10 0 1 . |
35. | 000957 9 1 2 2 |
|-------------------------------------------------|
36. | 001084 7 0 0 . |
37. | 001084 7 0 0 . |
38. | 001084 7 0 0 . |
39. | 001084 7 0 0 . |
40. | 001084 9 1 1 . |
41. | 001084 9 0 1 . |
42. | 001084 9 0 1 1 |
|-------------------------------------------------|
43. | 001547 9 0 0 . |
44. | 001547 9 0 0 . |
45. | 001547 9 0 0 . |
46. | 001547 9 0 0 . |
47. | 001547 9 0 0 . |
48. | 001547 9 0 0 . |
49. | 001547 8 1 1 1 |
|-------------------------------------------------|
50. | 001744 6 0 0 . |
+-------------------------------------------------+
. tab fdgindex
fdgindex | Freq. Percent Cum.
------------+-----------------------------------
0 | 519 31.84 31.84
1 | 557 34.17 66.01
2 | 341 20.92 86.93
3 | 143 8.77 95.71
4 | 58 3.56 99.26
5 | 10 0.61 99.88
6 | 2 0.12 100.00
------------+-----------------------------------
Total | 1,630 100.00
. // of the 1630 firms that have more than 1 observation in the estimation sample,
. // 519 (31.8%) have not changed their Gindex. 557 (34%) have changed it once,
. // 341 (21%) changed it twice, etc.
.
. log close
log: /Users/baum/Documents/boyan/Boyan-CorpGov/CorpGov_revise/udcl9218-1.smcl
log type: smcl
closed on: 18 Feb 2009, 14:08:30
-------------------------------------------------------------------------------------------------------------------