-------------------------------------------------------------------------------
log: /Volumes/ecxs2/users/baum/CompustatCompann/UDCL8509-1.smcl
log type: smcl
opened on: 9 May 2008, 09:25:10
. * create extract corresponding to UDCL strategy on annual data to match wi/IR
> RC
. * cfb 7A03 updated 7B20 for corr var list
. * cfb 8206 updated for data34, debt in curr liab
. * cfb 8219 updated for data9, long-term debt
. * cfb 8228 add variables for leverage study
. * cfb 8314 add cic
. * cfb 8509 add variables used by Opler et al
. clear
. set mem 2000m
Current memory allocation
current memory usage
settable value description (1M = 1024k)
--------------------------------------------------------------------
set maxvar 5000 max. variables allowed 1.751M
set memory 2000M max. data space 2,000.000M
set matsize 400 max. RHS vars in models 1.254M
-----------
2,003.006M
. use compann
. desc
Contains data from compann.dta
obs: 788,304
vars: 470 3 Apr 2008 13:17
size: 1,718,502,720 (18.1% 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
file byte %8.0g file identification code
zlist byte %8.0g exchange listing & s&p major
index code
smbl str7 %7s stock ticker symbol
xrel int %8.0g s&p industry index relative code
stk byte %8.0g stock ownership code
dup byte %8.0g duplicate file code
state byte %8.0g company location code - state
county int %8.0g company location code - county
finc byte %8.0g incorporation code - foreign
cpspin str1 %1s s&p index primary market
csspin str2 %2s s&p index secondary identifier
csspii str1 %1s s&p index subset identifier
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
ein str10 %10s employer identification number
naics str6 %6s n. american industry
classification sys.
date int %dD_m_Y fiscal year
fyr byte %8.0g fiscal yearend month of data
ucode byte %8.0g update code
aftnt1 str2 %2s sales (net) (data12)
aftnt2 str2 %2s cost of goods sold (data41)
aftnt3 str2 %2s research and development
expense(data46)
aftnt4 str2 %2s rental expense (data47)
aftnt5 str2 %2s depreciation and amortization
(data14)
aftnt6 str2 %2s interest expense (data15)
aftnt7 str2 %2s income taxes...
(data63,64,173,211)
aftnt8 str2 %2s investment tax credit (data51)
aftnt9 str2 %2s income taxes - total (data16)
aftnt10 str2 %2s income before ei/net
income(data18,172)
aftnt11 str2 %2s income before ei- adj. for cse
(data20)
aftnt12 str2 %2s eps (basic) inc/exc ei
(data53,58)
aftnt13 str2 %2s captial expenditures (scf)
(data128)
aftnt14 str2 %2s rental commitments...
(data96,164-167)
aftnt15 str2 %2s deprec, depletion, and
amort...(data196)
aftnt16 str2 %2s accounts payable/esp from
op(data70,233)
aftnt17 str2 %2s income taxes payable (data71)
aftnt18 str2 %2s equity in earnings (data55)
aftnt19 str2 %2s debt/long-term debt
(data79-84,148,154)
aftnt20 str2 %2s long-term debt - total (data9)
aftnt22 str2 %2s labor and related expense
(data42)
aftnt23 str2 %2s debt - capitalized lease oblig.
(data84)
aftnt24 str2 %2s debt - maturing in ___ year
(data91-94)
aftnt25 str2 %2s employees (data29)
aftnt26 str2 %2s preferred stock- liq/red val
(data10,56)
aftnt27 str2 %2s assets - total... (data6)
aftnt28 str2 %2s common stock (data85)
aftnt29 str2 %2s retained earnings (data36)
aftnt30 str2 %2s foreign currency adj... (data150)
aftnt31 str2 %2s property, plant & equipment...
(data8)
aftnt32 str2 %2s source document code
aftnt33 str2 %2s month of deletion
aftnt34 str2 %2s year of deletion
aftnt35 str2 %2s reason for deletion code
data1 double %10.0g cash and short-term investments
(mm$)
data2 double %10.0g receivables - total (mm$)
data3 double %10.0g inventories - total (mm$)
data4 double %10.0g current assets - total (mm$)
data5 double %10.0g current liabilities - total (mm$)
data6 double %10.0g assets - total (mm$)
data7 double %10.0g property, plant & equip
-...(gross)(mm$)
data8 double %10.0g property, plant & equip - ...
(net)(mm$)
data9 double %10.0g long-term debt - total (mm$)
data10 double %10.0g preferred stock - liquidating
value(mm$)
data11 double %10.0g common equity - tangible (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$)
data19 float %9.0g dividends - preferred (mm$)
data20 float %9.0g income before ei- adj for
common...(mm$)
data21 float %9.0g dividends - common (mm$)
data22 double %10.0g price - calendar year - high
($&c)
data23 float %9.0g price - calendar year - low ($&c)
data24 double %10.0g price - calendar year - close
($&c)
data25 float %9.0g common shares outstanding (mm)
data26 float %9.0g dividends per share - ex-date
($&c)
data27 float %9.0g adjustment factor (cum.) by
ex-date
data28 float %9.0g common shares traded- calendar
year (mm)
data29 float %9.0g employees (m)
data30 float %9.0g property, plant & equip- capital
ex(mm$)
data31 double %10.0g invest. & advances - equity
method (mm$)
data32 double %10.0g investments and advances - other
(mm$)
data33 double %10.0g intangibles (mm$)
data34 double %10.0g debt in current liabilities (mm$)
data35 float %9.0g deferred tax & invest tax
credit...(mm$)
data36 double %10.0g retained earnings (mm$)
data37 double %10.0g invested capital - total (mm$)
data38 float %9.0g minority interest (balance sheet)
(mm$)
data39 float %9.0g convertible debt & preferred
stock (mm$)
data40 float %9.0g common shares reserved for
conver...(mm)
data41 double %10.0g cost of goods sold (mm$)
data42 double %10.0g labor and related expenses (mm$)
data43 float %9.0g pension and retirement expenses
(mm$)
data44 double %10.0g debt - due in one year (mm$)
data45 float %9.0g advertising expense (mm$)
data46 float %9.0g research and development expense
(mm$)
data47 float %9.0g rental expense (mm$)
data48 float %9.0g extra. items & discontinued oper.
(mm$)
data49 float %9.0g minority interest (income
account) (mm$)
data50 float %9.0g deferred taxes (income account)
(mm$)
data51 float %9.0g investment tax credit (income
acct)(mm$)
data52 double %10.0g net oper. loss carry fwd-
unused...(mm$)
data53 double %10.0g eps (basic) - include extra.
items ($&c)
data54 float %9.0g common shares used to calculate
eps (mm)
data55 float %9.0g equity in earnings (mm$)
data56 double %10.0g preferred stock - redemption
value (mm$)
data57 double %10.0g eps (diluted) - excl. extra.
items ($&c)
data58 double %10.0g eps (basic) - exclude extra.
items ($&c)
data59 long %12.0g inventory valuation method...
data60 double %10.0g common equity - total (mm$)
data61 float %9.0g nonoperating income (expense)
(mm$)
data62 float %9.0g interest income (mm$)
data63 float %9.0g income taxes - federal (mm$)
data64 float %9.0g income taxes - foreign (mm$)
data65 float %9.0g amortization of intangibles (mm$)
data66 float %9.0g discontinued operations (mm$)
data67 float %9.0g receivables - estimated doubtful
(mm$)
data68 float %9.0g current assets - other (mm$)
data69 double %10.0g assets - other (mm$)
data70 double %10.0g accounts payable (mm$)
data71 float %9.0g income taxes payable (mm$)
data72 float %9.0g current liabilities - other (mm$)
data73 float %9.0g property, plant & equip- cip...
(mm$)
data74 float %9.0g deferred taxes (balance sheet)
(mm$)
data75 double %10.0g liabilities - other (mm$)
data76 float %9.0g inventories - raw materials (mm$)
data77 float %9.0g inventories - work in process
(mm$)
data78 float %9.0g inventories - finished goods
(mm$)
data79 float %9.0g debt - convertible (mm$)
data80 float %9.0g debt - subordinated (mm$)
data81 double %10.0g debt - notes (mm$)
data82 double %10.0g debt - debentures (mm$)
data83 double %10.0g long-term debt - other (mm$)
data84 float %9.0g debt - capitalized lease
obligation(mm$)
data85 float %9.0g common stock (mm$)
data86 float %9.0g treasury stock (memo entry) (mm$)
data87 float %9.0g treasury stock- num of common
shares(mm)
data88 float %9.0g treasury stock - total dollar amt
(mm$)
data89 float %9.0g pension c- unfunded vested
benefits(mm$)
data90 float %9.0g pension c- unfunded past/prior
serv(mm$)
data91 double %10.0g debt - maturing in 2nd year (mm$)
data92 float %9.0g debt - maturing in 3rd year (mm$)
data93 float %9.0g debt - maturing in 4th year (mm$)
data94 float %9.0g debt - maturing in 5th year (mm$)
data95 float %9.0g rental commitments- min - 5 yr
tota(mm$)
data96 float %9.0g rental commitments - min - 1st
year(mm$)
data97 float %9.0g retained earnings - unrestricted
(mm$)
data98 double %10.0g order backlog (mm$)
data99 float %9.0g retained earnings restatement
(mm$)
data100 double %10.0g common shareholders (m)
data101 float %9.0g interest expense on long-term
debt (mm$)
data102 float %9.0g excise taxes (mm$)
data103 float %9.0g depreciation expense (schedulevi)
(mm$)
data104 double %10.0g short-term borrowings - average
(mm$)
data105 float %9.0g short-term borrowings - avg int.
rate(%)
data106 float %9.0g equity in net loss (earnings) ...
(mm$)
data107 float %9.0g sale of property, plant &
equip... (mm$)
data108 float %9.0g sale of common and pref. stock...
(mm$)
data109 double %10.0g sale of investments... (mm$)
data110 float %9.0g funds from operations - total...
(mm$)
data111 double %10.0g long-term debt - issuance...
(mm$)
data112 float %9.0g sources of funds - total... (mm$)
data113 double %10.0g increase in investments... (mm$)
data114 double %10.0g long-term debt - reduction...
(mm$)
data115 float %9.0g purchase of common and pref.
stock (mm$)
data116 float %9.0g uses of funds - total... (mm$)
data117 double %10.0g sales (restated) (mm$)
data118 double %10.0g income before extra
items(restated)(mm$)
data119 double %10.0g eps (basic) - exclud. ei
(restated)($&c)
data120 double %10.0g assets - total (restated) (mm$)
data121 float %9.0g working captial (restated) (mm$)
data122 float %9.0g pretax income (restated) (mm$)
data123 float %9.0g income before extra items (scf)
(mm$)
data124 float %9.0g ei & discontinued oper (scf)(mm$)
data125 float %9.0g depreciation and amortization
(scf)(mm$)
data126 float %9.0g deferred taxes (statement of cf)
(mm$)
data127 float %9.0g cash dividends (statement of cf)
(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$)
data131 double %10.0g cost of goods sold (restated)
(mm$)
data132 double %10.0g sg&a expenses (restated) (mm$)
data133 float %9.0g deprec. & amortization (restated)
(mm$)
data134 float %9.0g interest expense (restated) (mm$)
data135 float %9.0g income taxes - total (restated)
(mm$)
data136 float %9.0g ei & discontinued oper
(restated)(mm$)
data137 double %10.0g eps (basic) - incl ei
(restarted)($&c)
data138 float %9.0g com shares used to calc eps...
(r)(mm)
data139 double %10.0g eps (diluted) - excl ei
(restated)($&c)
data140 double %10.0g eps (diluted) - incl ei
(restated)($&c)
data141 double %10.0g prop, plant &equip- total
(net)(r)(mm$)
data142 double %10.0g long-term debt - total (restated)
(mm$)
data143 double %10.0g retained earnings (restated)
(mm$)
data144 double %10.0g stockholders' equity (restated)
(mm$)
data145 float %9.0g capital expenditures (restated)
(mm$)
data146 float %9.0g employees (restated) (m)
data147 float %9.0g interest capitalized (mm$)
data148 double %10.0g long-term debt tied to prime
(mm$)
data149 int %8.0g auditor/auditor's opinion (code)
data150 float %9.0g foreign currency adj (income
acct) (mm$)
data151 double %10.0g receivables - trade (mm$)
data152 float %9.0g deferred charges (mm$)
data153 float %9.0g accrued expenses (mm$)
data154 float %9.0g debt - subordinated convertible
(mm$)
data155 float %9.0g ppe - buildings (net) (mm$)
data156 double %10.0g ppe - machinery & equip (net)
(mm$)
data157 float %9.0g ppe - natural resources (net)
(mm$)
data158 float %9.0g ppe - land and improvements (net)
(mm$)
data159 float %9.0g ppe - leases (net) (mm$)
data160 float %9.0g prepaid expense (mm$)
data161 float %9.0g income tax refund (mm$)
data162 float %9.0g cash (mm$)
data163 float %9.0g rental income (mm$)
data164 float %9.0g rental commitments - min - 2nd
year(mm$)
data165 float %9.0g rental commitments - min - 3rd
year(mm$)
data166 float %9.0g rental commitments - min - 4th
year(mm$)
data167 float %9.0g rental commitments - min - 5th
year(mm$)
data168 float %9.0g compensating balance (mm$)
data169 double %10.0g eps (diluted) - incl extra items
($&c)
data170 float %9.0g pretax income (mm$)
data171 float %9.0g com shares used to calc eps (dil)
(mm)
data172 float %9.0g net income (loss) (mm$)
data173 float %9.0g income taxes - state (mm$)
data174 float %9.0g depletion expense (schedule vi)
(mm$)
data175 float %9.0g preferred stock - redeemable
(mm$)
source byte %8.0g source document code
aftnt36 str2 %2s operating income after deprec.
(data178)
aftnt37 str2 %2s acquisition- sales
contribution(data249)
aftnt38 str2 %2s debt - senior convertible
(data188)
aftnt39 str2 %2s deprec, depletion, and
amort...(data196)
aftnt40 str2 %2s capital surplus (data210)
aftnt41 str2 %2s selling, general & adm
expenses(data189)
aftnt42 str2 %2s pretax income dom/foreign
(data272,273)
aftnt43 str2 %2s pension -
prepaid...(overfund)(data290)
aftnt44 str2 %2s pension -
prepaid...(underfund)(data300)
aftnt45 str2 %2s treasury stock (dollar amt)...
(data226)
aftnt46 str2 %2s debt - consolidated subsidiary
(data329)
aftnt47 str2 %2s debt - finance subsidiary
(data328)
aftnt48 str2 %2s contingent guarantees - liab.
(data327)
aftnt49 str2 %2s account changes - cum. effect
(data183)
aftnt50 str2 %2s s&p lt dom issuer credit
rat...(data280)
aftnt51 str2 %2s eps from operations (data233)
data177 double %10.0g net income (loss)(restated) (mm$)
data178 float %9.0g operating income after deprec.
(mm$)
data179 float %9.0g working capital (balance sheet)
(mm$)
data180 float %9.0g working capital change -
total(soc)(mm$)
data181 double %10.0g liabilities - total (mm$)
data182 double %10.0g ppe - beginning balance (sched v)
(mm$)
data183 float %9.0g accounting changes - cum. effect
(mm$)
data184 float %9.0g ppe - retirements (schedule v)
(mm$)
data185 float %9.0g ppe - other changes (schedule v)
(mm$)
data186 float %9.0g inventories - other (mm$)
data187 double %10.0g ppe - ending balance (schedule
v)(mm$)
data188 float %9.0g debt - senior convertible (mm$)
data189 float %9.0g selling, general & admin.
expenses (mm$)
data190 float %9.0g nonop. income (expense)- ex int
inc(mm$)
data191 float %9.0g common stock equiv - dollar
savings(mm$)
data192 float %9.0g extraordinary items (mm$)
data193 double %10.0g short-term investments (mm$)
data194 double %10.0g receivables - current - other
(mm$)
data195 float %9.0g cur assets- other- ex prepaid
expen(mm$)
data196 double %10.0g depr., depl. & amort.
(accum.)(bs)(mm$)
data197 double %10.0g price -- fiscal year -- high
($&c)
data198 float %9.0g price -- fiscal year -- low ($&c)
data199 double %10.0g price -- fiscal year -- close
($&c)
data200 float %9.0g common shares reserved for conv-
cd (mm)
data201 float %9.0g dividends per share - payable
date ($&c)
data202 float %9.0g adjustment factor (cum) by
payable date
data203 float %9.0g common shares reserved for conv-
ps (mm)
data204 double %10.0g goodwill (mm$)
data205 double %10.0g assets- other- excl deferred
charge(mm$)
data206 double %10.0g notes payable (mm$)
data207 float %9.0g cur. liab.- other- excl accrued
exp(mm$)
data208 float %9.0g investment tax credit (balance
sht)(mm$)
data209 float %9.0g preferred stock - nonredeemable
(mm$)
data210 double %10.0g capital surplus (mm$)
data211 float %9.0g income taxes - other (mm$)
data213 float %9.0g sale of ppe & invest-
loss(gain)...(mm$)
data214 float %9.0g preferred stock - convertible
(mm$)
data215 float %9.0g common shares reserved for conv-
so (mm)
data216 double %10.0g stockholders' equity - total
(mm$)
data217 float %9.0g funds from operations -
other(scf)(mm$)
data218 float %9.0g sources of funds - other (soc)
(mm$)
data219 float %9.0g uses of funds - other (soc) (mm$)
data220 double %10.0g deprec. (accum.)- beg.
balanace...(mm$)
data221 float %9.0g deprec. (accum.)- retirements...
(mm$)
data222 float %9.0g deprec. (accum.)- other
changes...(mm$)
data223 double %10.0g deprec. (accum)- ending
balance...(mm$)
data224 float %9.0g nonoperating income (expense)(r)
(mm$)
data225 float %9.0g minority interest (restated)
(mm$)
data226 float %9.0g treasury stock (dollar amt)-
common(mm$)
data227 float %9.0g treasury stock (dollar amt) -
pref (mm$)
data228 float %9.0g currency translaton rate ($&c)
data229 float %9.0g com shares reserved for conv-
war...(mm)
data230 float %9.0g retained earnings - cum. trans.
adj(mm$)
data231 double %10.0g retained earnings - other adj.
(mm$)
data232 double %10.0g common stock -- per share carry
val($&c)
data233 double %10.0g earnings per share from
operations ($&c)
data234 float %9.0g adr ratio
data235 double %10.0g common equity - liquidation value
(mm$)
data236 float %9.0g working capital change- other...
(mm$)
data237 float %9.0g income before ei- avail for
common(mm$)
data238 float %9.0g marketable securities adj (bal
sht)(mm$)
data239 float %9.0g interest capital- net income
effect(mm$)
data240 float %9.0g inventories - lifo reserve (mm$)
data241 float %9.0g debt - mortgages and other
secured (mm$)
data242 float %9.0g dividends - preferred - in
arrears (mm$)
data243 float %9.0g pension benefits - pv of vested
(mm$)
data244 float %9.0g pension benefits - pv of
nonvested (mm$)
data245 float %9.0g pension benefits - net assets
(mm$)
data246 float %9.0g pension benefits - assumed rate
of ret.
data247 float %9.0g pension benefits - info date
(mmddyy)
data248 float %9.0g acquisition - income contribution
(mm$)
data249 double %10.0g acquisition - sales contribution
(mm$)
data250 float %9.0g property, plant & equip-
other(net)(mm$)
data251 float %9.0g deprec (accum)- land and
improvemen(mm$)
data252 float %9.0g deprec. (accum) - natural
resources(mm$)
data253 float %9.0g deprec. (accum) - buildings (mm$)
data254 float %9.0g deprec. (accum) - machinery &
equip(mm$)
data255 float %9.0g depreciation (accumulated) -
leases(mm$)
data256 float %9.0g deprec. (accum) - construct in
prog(mm$)
data257 float %9.0g depreciation (accumulated) -
other (mm$)
data258 float %9.0g net income- adj for com stock
equiv(mm$)
data259 double %10.0g retained earnings - unadjusted
(mm$)
data260 float %9.0g ppe - land and improvements at
cost(mm$)
data261 float %9.0g ppe - natural resources at cost
(mm$)
data263 float %9.0g ppe - buildings at cost (mm$)
data264 double %10.0g ppe - machinery & equipment at
cost(mm$)
data265 float %9.0g ppe - leases at cost (mm$)
data266 float %9.0g ppe - construct in progress at
cost(mm$)
data267 double %10.0g ppe - other at cost (mm$)
data268 float %9.0g debt - unamortized debt
discount...(mm$)
data269 float %9.0g deferred taxes - federal (mm$)
data270 float %9.0g deferred taxes - foreign (mm$)
data271 float %9.0g deferred taxes - state (mm$)
data272 float %9.0g pretax income - domestic (mm$)
data273 float %9.0g pretax income - foreign (mm$)
data274 float %9.0g cash & cash equiv-
increase(dec)...(mm$)
data276 byte %8.0g s&p major index code - historical
data277 int %8.0g s&p industry index code -
historical
data278 float %9.0g fortune industry code
data279 int %8.0g fortune rank
data280 byte %8.0g s&p lt domestic issuer credit
rating
data282 byte %8.0g s&p common stock ranking
data283 int %8.0g s&p st dom. issuer credit rating-
hist
data284 float %9.0g pension- vested benefit
obl.(ovfnd)(mm$)
data285 double %10.0g pension- accum benefit obl.
(ovfnd)(mm$)
data286 double %10.0g pension- projectd benefit
ob(ovfnd)(mm$)
data287 double %10.0g pension plan assets (overfunded)
(mm$)
data288 float %9.0g pension- unrec. prior
serv..(ovfnd)(mm$)
data289 float %9.0g pension - other adj. (overfunded)
(mm$)
data290 float %9.0g pension- prepaid/accrued
cos(ovfnd)(mm$)
data291 float %9.0g pension- vested benefit
obl.(unfnd)(mm$)
data292 float %9.0g periodic postretirement benefit
cos(mm$)
data293 float %9.0g pension- accum benefit
oblig(unfnd)(mm$)
data294 float %9.0g pension- projectd benefit
ob(unfnd)(mm$)
data295 float %9.0g periodic pension cost (net) (mm$)
data296 float %9.0g pension plan assets (underfunded)
(mm$)
data297 float %9.0g pension- unrec prior sv
cost(unfnd)(mm$)
data298 float %9.0g pension- addl min.
liability(unfnd)(mm$)
data299 float %9.0g pension - other adj.
(underfunded) (mm$)
data300 float %9.0g pension- prepaid/accrued
cos(unfnd)(mm$)
data301 double %10.0g changes in current debt (scf)
(mm$)
data302 float %9.0g accounts receivable-
dec(inc)(scf)(mm$)
data303 float %9.0g inventory - decrease(incr.)
(socf)(mm$)
data304 float %9.0g accts payable & accrued liab
inc...(mm$)
data305 float %9.0g income taxes- accrued -
inc(dec)...(mm$)
data307 double %10.0g assets & liab- other(net
chg)(socf)(mm$)
data308 double %10.0g operating activities- net cf
(socf)(mm$)
data309 double %10.0g short-term invest. - change
(socf) (mm$)
data310 float %9.0g investing activities - other
(socf)(mm$)
data311 double %10.0g investing activities- net cf
(socf)(mm$)
data312 double %10.0g financing activities - other
(socf)(mm$)
data313 double %10.0g financing activities- net cf
(socf)(mm$)
data314 float %9.0g exchange rate effect (socf)(mm$)
data315 double %10.0g interest paid - net (socf) (mm$)
data317 double %10.0g income taxes paid (socf) (mm$)
data318 byte %8.0g format code (statement of cash
flows)
data319 float %9.0g dilution adjustment
data320 byte %8.0g s&p subordinated debt rating
data321 float %9.0g interest income - total (fin
serv)(mm$)
data322 float %9.0g diluted available - excl
data323 double %10.0g diluted eps from operations
data324 int %8.0g historical sic code
data327 double %10.0g contingent liab. - guarantees
(mm$)
data328 double %10.0g debt - finance subsidiary (mm$)
data329 double %10.0g debt - consolidated subsidiary
(mm$)
data330 float %9.0g postretirement benefit
asset(liab)(mm$)
data331 float %9.0g pension plans - service cost
(mm$)
data332 float %9.0g pension plans - interest cost
(mm$)
data333 float %9.0g pension plans- return on plan
asset(mm$)
data334 float %9.0g pension plans- other periodic
cc...(mm$)
data335 float %9.0g pension plans- rate of compen.
increase
data336 float %9.0g pension plans- anticipat lt ror
on pa(%)
data337 float %9.0g risk-adjusted capital ratio -
tier i
data339 float %9.0g interest expense -- total(fin
serv)(mm$)
data340 float %9.0g net interest income(tax
equivalent)(mm$)
data341 float %9.0g nonperforming assets -- total
(mm$)
data342 float %9.0g provision for loan/asset losses
(mm$)
data343 float %9.0g reserve for loan/asset losses
(mm$)
data344 double %10.0g net interest margin
data348 float %9.0g risk-adjusted capital ratio --
total
data349 float %9.0g net charge-offs (mm$)
coname str28 %28s company name
iname str28 %28s industry name
gvkey long %12.0g spc permanent number
yeara int %8.0g fiscal year
active byte %8.0g 1 = active; 0 = inactive
data388 float %9.0g in process r&d expense
data389 float %9.0g thereafter portion of leases
data399 float %9.0g implied option expense
data396 float %9.0g common shares issued
data351 float %9.0g current assets of discontinued
operations
data354 float %9.0g other current assets excl
discontinued operations
data357 float %9.0g accumulated other comprehensive
income (loss)
data353 float %9.0g long-term assets of discontinued
operations
data355 double %10.0g other assets excl discontinued
operations
data358 float %9.0g deferred compensation
data356 float %9.0g deferred revenue - current
data397 float %9.0g deferred revenue - long-term
data394 float %9.0g goodwill amortization
data352 double %10.0g other intangibles
data377 float %9.0g restructuring costs after-tax
data379 float %9.0g restructuring costs diluted eps
effect
data378 float %9.0g restructuring costs basic eps
effect
data376 float %9.0g restructuring costs pretax
data359 double %10.0g other stockholders' equity
adjustments
data398 float %9.0g stock compensation expense
data381 float %9.0g write-down after-tax
data383 float %9.0g write-down diluted eps effect
data382 float %9.0g write-down basic eps effect
data380 float %9.0g write-down pretax
data365 float %9.0g gain/loss after-tax
data367 float %9.0g gain/loss diluted eps effect
data366 float %9.0g gain/loss basic eps effect
data364 float %9.0g gain/loss pretax
data373 float %9.0g settlement(litigation/insurance)
after-tax
data375 float %9.0g settlement(litigation/insurance)
diluted eps effect
data374 float %9.0g settlement(litigation/insurance)
basic eps effect
data372 float %9.0g settlement(litigation/insurance)
pretax
data387 float %9.0g other special items diluted eps
effect
data386 float %9.0g other special items basic eps
effect
data385 float %9.0g other special items after-tax
data384 float %9.0g other special items pretax
data400 float %9.0g
data361 float %9.0g acquisition/merger after-tax
data363 float %9.0g acquisition/merger diluted eps
effect
data362 float %9.0g acquisition/merger basic eps
effect
data360 float %9.0g acquisition/merger pretax
data369 float %9.0g impairments of goodwill after-tax
data371 float %9.0g impairments of goodwill diluted
eps effect
data370 float %9.0g impairments of goodwill basic eps
effect
data368 float %9.0g impairments of goodwill pretax
data390 float %9.0g accumulated depreciation of re
property
data393 float %9.0g depreciation/amortization of
property
data391 float %9.0g total re property
data392 float %9.0g gain/loss on sale of property
data395 str2 %2s goodwill amortization footnote
ajex float %9.0g adjustment factor (company) -
cumulative by ex-date
spce float %9.0g s&p core earnings
spced float %9.0g s&p core earnings eps diluted
spceeps float %9.0g s&p core earnings eps basic
-------------------------------------------------------------------------------
Sorted by: cnum yeara
. keep yeara coname dnum cnum cic smbl date data1 data2 data5 data6 ///
> data9 data10 data12 data13 data14 data15 data16 data17 data18 ///
> data21 data25 data34 data35 data44 data46 data56 data79 ///
> data108 data111 data114 data115 data127 data128 data129 ///
> data130 data179 data180 data181 data192 data199 ///
> data236 data274 data280 data283 data301 data308 aftnt2 aftnt3
. sort cnum yeara
. duplicates drop cnum yeara, force
Duplicates in terms of cnum yeara
(9195 observations deleted)
. save `outfile', replace
file UDCL8509.dta saved
. log close
log: /Volumes/ecxs2/users/baum/CompustatCompann/UDCL8509-1.smcl
log type: smcl
closed on: 9 May 2008, 09:25:45
-------------------------------------------------------------------------------