-------------------------------------------------------------------------------
       log:  /Volumes/ecxs2/users/baum/compustatcompann/udcl9216-1.smcl
  log type:  smcl
 opened on:  17 Feb 2009, 15:27:43



. // udcl9216-1
. // massage 2007 compustat from xpressfeed for merge with compann
. use compustat2007_9216wrds,clear



. rename tic smbl



. rename fyear yeara



. g dnum = sic



. destring dnum, replace
dnum has all characters numeric; replaced as int



. rename che data1 



. rename at data6



. rename sale data12



. rename dp data14



. rename ib data18



. rename capx data128



. g str6 cnum = substr(cusip,1,6)



. desc



Contains data from compustat2007_9216wrds.dta
  obs:        12,482                          
 vars:            20                          
 size:     1,373,020 (99.7% of memory free)
-------------------------------------------------------------------------------
              storage  display     value
variable name   type   format      label      variable label
-------------------------------------------------------------------------------
gvkey           str6   %6s                    Global Company Key
datadate        str8   %8s                    Data Date
yeara           float  %6.0g                  Data Year - Fiscal
indfmt          str12  %12s                   Industry Format
consol          str2   %2s                    Level of Consolidation - Compan
popsrc          str2   %2s                    Population Source
datafmt         str12  %12s                   Data Format
smbl            str8   %8s                    Ticker Symbol
cusip           str10  %10s                   CUSIP
curcd           str4   %4s                    ISO Currency Code
data6           float  %20.0g                 Assets - Total
data128         float  %20.0g                 Capital Expenditures
data1           float  %20.0g                 Cash and Short-Term Investments
data14          float  %20.0g                 Depreciation and Amortization
data18          float  %20.0g                 Income Before Extraordinary Ite
data12          float  %20.0g                 Sales/Turnover (Net)
costat          str2   %2s                    Active/Inactive Status Marker
sic             str4   %4s                    Standard Industry Classificatio
dnum            int    %10.0g                 
cnum            str6   %9s                    
-------------------------------------------------------------------------------
Sorted by:  
     Note:  dataset has changed since last saved



. su



    Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
       gvkey |         0
    datadate |         0
       yeara |     12481    2007.195    .3960441       2007       2008
      indfmt |         0
      consol |         0
-------------+--------------------------------------------------------
      popsrc |         0
     datafmt |         0
        smbl |         0
       cusip |         0
       curcd |         0
-------------+--------------------------------------------------------
       data6 |      9616    11048.23    103950.7          0    3771200
     data128 |      9452    204.1613     1107.68     -28.61      27548
       data1 |      9612    1086.069    13471.59          0     535019
      data14 |      9266    139.3746     758.646          0   21651.26
      data18 |      9550    205.7968    1410.529     -43297      40610
-------------+--------------------------------------------------------
      data12 |      9548    2904.096    13697.65  -4234.472     375376
      costat |         0
         sic |         0
        dnum |     12482    5126.137    2089.293        100       9997
        cnum |         0



. save compustat2007_9216,replace
file compustat2007_9216.dta saved



. log close
       log:  /Volumes/ecxs2/users/baum/compustatcompann/udcl9216-1.smcl
  log type:  smcl
 closed on:  17 Feb 2009, 15:27:43
-------------------------------------------------------------------------------