Research Computing >> Training & publications >> Ph.D. workshops, Summer 2004 >> Data for replication >> Information from the matched IPOs file

INFORMATION FROM THE MATCHED IPOs FILE

Contents of bakerwurgler2.sas7bdat

Path in WRDS server: /projects/nwu/pledesma/corpfin/bakerwurgler2.sas7bdat

Variable      Type    Len    Format       Label
-----------------------------------------------------------------------------------------------
COMNAM        Char     32                 Company Name
END_DATE      Num       4    YYMMDDN8.    Ending Date of Series
PERMNO        Num       6                 CRSP Permanent Number
ST_DATE       Num       4    YYMMDDN8.    Starting Date of Series
cusip         Char      8                 CUSIP number
date          Num       8    YYMMDDN8.    IPO date
end_assets    Num       8                 Year Total Assets series ends
end_mkval     Num       8                 Year Market Value series ends
gvkey         Num       8                 Standard and Poor's Identifier
numday        Num       8                 Number of days after IPO date to appear in CRSP
numyrs        Num       8                 Number of years after IPO year to appear in Compustat
st_assets     Num       8                 Year Total Assets series starts
st_mkval      Num       8                 Year Market Value series starts
yrsassets     Num       8                 Number of years Total Assets should be available
yrsmkval      Num       8                 Number of years Market Value should be available

List of duplicate gvkeys

gvkey    PERMNO     cusip      COMNAM                                  date    st_mkval    numyrs

 1072     56899    00244010    A V X CERAMICS CORP                 19720629      1973          1
 1072     81912    00244410    A V X CORP NEW                      19950814      1973        -22
 1743     48004    04078910    ARKANSAS BEST CORP                  19681126      1968          0
 1743     77595    04079010    ARKANSAS BEST CORP DEL              19920513      1968        -24
 3707     28266    23332510    D S T SYSTEMS INC                   19830316      1983          0
 3707     83186    233326      D S T SYSTEMS INC DEL               19951031      1983        -12
 3713     87151    233860      DAIRY MART CONVENIENCE STORES       19830722      1983          0
 3713     87151    233860      DAIRY MART CONVENIENCE STORES       19851105      1983         -2
 4090     30833    26413810    DUCKWALL STORES INC                 19720516      1972          0
 4090     80971    26414210    DUCKWALL ALCO STORES INC NEW        19941027      1972        -22
 4845     37242    89190910    TRACE INC                           19830712      1983          0
 4845     37242    34637210    FORMASTER CORP                      19831215      1983          0
 4850     54754    34746010    FORT HOWARD PAPER CO                19720504      1971         -1
 4850     81487    34746110    FORT HOWARD CORP NEW                19950309      1971        -24
 4875     67520    35165310    FOXMEYER CORP                       19830712      1983          0
 4875     76806    35165410    FOXMEYER CORP NEW                   19910829      1983         -8
 5718     51561    44106510    HOSPITAL CORP AMERICA               19690304      1969          0
 5718     77370    40412010    H C A HOSPITAL CORP AMERICA         19920226      1969        -23
 6242     46448    47508610    JEFFERSON SMURFIT CORP              19831110      1983          0
 6242     80543    83272710    SMURFIT STONE CONTAINER CORP        19940504      1983        -11
 7221     52653    58491610    MEDIPLEX GROUP INC                  19831027      1983          0
 7221     76777    58494510    MEDIPLEX GROUP INC NEW              19910807      1983         -8
 8404     63298    70437810    PAYLESS CASHWAYS INC                19690508      1969          0
 8404     79043    704378      PAYLESS CASHWAYS INC                19930308      1969        -24
 9023     66174    75891410    REGIS CORP                          19830426      1983          0
 9023     76711    75893210    REGIS CORP MINN                     19910621      1983         -8
 9458     69121    80652710    SCHERER R P CORP                    19710617      1971          0
 9458     77075    80652810    SCHERER RP CORP                     19911011      1971        -20
11297     59838    93886310    WASHINGTON HOMES INC                19690909      1970          1
11297     78920    93886410    WASHINGTON HOMES INC NEW            19930225      1970        -23
12061     51887    29173710    EMPIRE INC                          19700414      1969         -1
12061     10134    29171410    EMPIRE GAS CORP NEW                 19860401      1969        -17
12474     47335    52748020    LEVITZ FURNITURE CORP               19680709      1968          0
12474     79437    52748210    LEVITZ FURNITURE INC                19930702      1968        -25
12615     10723    55305210    M I SCHOTTENSTEIN HOMES INC         19861003      1986          0
12615     79909    55305B10    M I SCHOTTENSTEIN HOMES INC NEW     19931102      1986         -7
12627     76545    03015K      AMERICAN TELECOMMUNICATIONS CO      19710914      1986         15
12627     76545    03015K      AMERICAN TELECOMMUNICATIONS CO      19720831      1986         14
13031     72311    62757810    MUSICLAND GROUP INC                 19870205      1987          0
13031     77371    62758B10    MUSICLAND STORES CORP               19920226      1987         -5
13046     65315    24790910    DELTA WOODSIDE INDS INC NEW         19721122      1987         15
13046     11062    24790410    DELTA WOODSIDE INDS INC             19870203      1987          0
13092     71933    34483910    FOODMAKER INC NEW                   19870224      1987          0
13092     77453    344839      FOODMAKER INC                       19920304      1987         -5
13227     92209    87139810    SYLVAN LEARNING CORP                19850726      1985          0
13227     80037    87139910    SYLVAN LEARNING SYSTEMS INC         19931209      1985         -8
13405     77358    346592      FORSTMANN & COMPANY INC             19870701      1987          0
13405     77358    346592      FORSTMANN & COMPANY INC             19920226      1987         -5
13481     79981    459862      INTERNATIONAL MICROCOMP SOFTW IN    19870630      1988          1
13481     11482    45986210    INTERNATIONAL MICROCOMP SOFTW IN    19870701      1988          1
24386     88838    372917      GENZYME BIOSUGERY                   19860605      1991          5
24386     76776    09060P10    BIOMATRIX INC                       19910806      1991          0
25658     60337    74155510    PRIME COMPUTER INC                  19740228      1974          0
25658     77859    20557T10    COMPUTERVISION CORP NEW             19920814      1974        -18
25682     60856    69523410    PACO PHARMACEUTICAL SVCS INC        19810805      1981          0
25682     77863    69523G10    PACO PHARMACEUTICAL SVCS INC        19920819      1981        -11
63507     83718    025930      AMERICAN GENERAL HOSP CORP          19960725      1996          0
63507     83818    140918      CAPSTAR HOTEL CO                    19960820      1996          0
65275     85276    22003R      CORPORATEFAMILY SOLUTIONS INC       19970812      1997          0
65275     85531    109190      BRIGHT HORIZONS INC                 19971107      1997          0
65748     85626    834025      SOFTWARE A G SYSTEMS INC NEW        19810609      1997         16
65748     85626    834025      SOFTWARE A G SYSTEMS INC NEW        19971118      1997          0

Number of years between IPO year and availability of market capitzalization in Compustat

                                   Cumulative    Cumulative
numyrs    Frequency     Percent     Frequency      Percent
-----------------------------------------------------------
   -48           1        0.01             1         0.01
   -47           1        0.01             2         0.02
   -45           1        0.01             3         0.03
   -44           1        0.01             4         0.04
   -43           2        0.02             6         0.06
   -42           2        0.02             8         0.08
   -41           2        0.02            10         0.11
   -40           1        0.01            11         0.12
   -37           2        0.02            13         0.14
   -33           3        0.03            16         0.17
   -32           1        0.01            17         0.18
   -31           2        0.02            19         0.20
   -30           2        0.02            21         0.22
   -29           3        0.03            24         0.25
   -28           3        0.03            27         0.29
   -27           2        0.02            29         0.31
   -26           2        0.02            31         0.33
   -25           4        0.04            35         0.37
   -24           5        0.05            40         0.42
   -23           6        0.06            46         0.49
   -22           4        0.04            50         0.53
   -20           2        0.02            52         0.55
   -19           3        0.03            55         0.58
   -18           2        0.02            57         0.60
   -17           4        0.04            61         0.64
   -16           1        0.01            62         0.66
   -15           2        0.02            64         0.68
   -14           3        0.03            67         0.71
   -13           2        0.02            69         0.73
   -12           7        0.07            76         0.80
   -11           6        0.06            82         0.87
   -10           1        0.01            83         0.88
    -9           1        0.01            84         0.89
    -8           9        0.10            93         0.98
    -7           6        0.06            99         1.05
    -6           4        0.04           103         1.09
    -5          12        0.13           115         1.22
    -4           5        0.05           120         1.27
    -3           3        0.03           123         1.30
    -2          17        0.18           140         1.48
    -1         235        2.48           375         3.96
     0        7135       75.44          7510        79.40
     1        1223       12.93          8733        92.33
     2         192        2.03          8925        94.36
     3         107        1.13          9032        95.50
     4          50        0.53          9082        96.02
     5          51        0.54          9133        96.56
     6          52        0.55          9185        97.11
     7          46        0.49          9231        97.60
     8          48        0.51          9279        98.11
     9          71        0.75          9350        98.86
    10          32        0.34          9382        99.20
    11          24        0.25          9406        99.45
    12           9        0.10          9415        99.55
    13           9        0.10          9424        99.64
    14           7        0.07          9431        99.71
    15           9        0.10          9440        99.81
    16           3        0.03          9443        99.84
    17           6        0.06          9449        99.90
    18           1        0.01          9450        99.92
    19           4        0.04          9454        99.96
    20           1        0.01          9455        99.97
    21           1        0.01          9456        99.98
    23           1        0.01          9457        99.99
    27           1        0.01          9458       100.00

© 2001-2010 Kellogg School of Management, Northwestern University