Announcement

Collapse
No announcement yet.
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Testing dataex

    Code:
    * Example generated by -dataex-. To install: ssc install dataex
    clear
    input byte id str3 icd10 int diag_date byte(eli2007 eli2008 eli2009)
    1 "I63" 17501 . . .
    1 "B44" 17714 . . .
    1 "I45" 18475 . . .
    2 "A37" 16468 . . .
    2 "A45" 17226 . . .
    2 "K87" 20089 . . .
    3 "C29" 16040 . . .
    3 "C12" 16588 . . .
    3 "N43" 16953 . . .
    end
    format %td diag_date

  • #2
    Code:
    * Example generated by -dataex-. To install: ssc install dataex
    clear
    input long gvkey str10 datadate int fyear str4 indfmt str1(consol popsrc) str3 datafmt str6 tic str9 cusip str3 curcd byte fyr float(gdwl gdwlip) str1 costat float GwlImpaired
    1050 "12/31/2001" 2001 "INDL" "C" "D" "STD" "CECE"   "125141101" "USD" 12   8.135       . "A"      0
    1050 "12/31/2002" 2002 "INDL" "C" "D" "STD" "CECE"   "125141101" "USD" 12   9.527       . "A"      0
    1050 "12/31/2003" 2003 "INDL" "C" "D" "STD" "CECE"   "125141101" "USD" 12   9.527       . "A"      0
    1050 "12/31/2004" 2004 "INDL" "C" "D" "STD" "CECE"   "125141101" "USD" 12   9.527       . "A"      0
    1050 "12/31/2005" 2005 "INDL" "C" "D" "STD" "CECE"   "125141101" "USD" 12   9.527       . "A"      0
    1050 "12/31/2006" 2006 "INDL" "C" "D" "STD" "CECE"   "125141101" "USD" 12   9.527       . "A"      0
    1050 "12/31/2007" 2007 "INDL" "C" "D" "STD" "CECE"   "125141101" "USD" 12  14.761       . "A"      0
    1050 "12/31/2008" 2008 "INDL" "C" "D" "STD" "CECE"   "125141101" "USD" 12  31.116       . "A"      0
    1050 "12/31/2009" 2009 "INDL" "C" "D" "STD" "CECE"   "125141101" "USD" 12  14.591  -17.11 "A"  17.11
    1050 "12/31/2010" 2010 "INDL" "C" "D" "STD" "CECE"   "125141101" "USD" 12  14.713       . "A"      0
    1050 "12/31/2011" 2011 "INDL" "C" "D" "STD" "CECE"   "125141101" "USD" 12  14.661       . "A"      0
    1050 "12/31/2012" 2012 "INDL" "C" "D" "STD" "CECE"   "125141101" "USD" 12  19.548       . "A"      0
    1050 "12/31/2013" 2013 "INDL" "C" "D" "STD" "CECE"   "125141101" "USD" 12  132.22       . "A"      0
    1050 "12/31/2014" 2014 "INDL" "C" "D" "STD" "CECE"   "125141101" "USD" 12 167.547       . "A"      0
    1050 "12/31/2015" 2015 "INDL" "C" "D" "STD" "CECE"   "125141101" "USD" 12 220.163   -3.34 "A"   3.34
    1050 "12/31/2016" 2016 "INDL" "C" "D" "STD" "CECE"   "125141101" "USD" 12 170.153 -57.923 "A" 57.923
    1050 "12/31/2017" 2017 "INDL" "C" "D" "STD" "CECE"   "125141101" "USD" 12 166.951  -7.168 "A"  7.168
    1050 "12/31/2018" 2018 "INDL" "C" "D" "STD" "CECE"   "125141101" "USD" 12 152.156       . "A"      0
    1050 "12/31/2019" 2019 "INDL" "C" "D" "STD" "CECE"   "125141101" "USD" 12  152.02       . "A"      0
    1050 "12/31/2020" 2020 "INDL" "C" "D" "STD" "CECE"   "125141101" "USD" 12  161.82       . "A"      0
    1164 "12/31/2001" 2001 "INDL" "C" "D" "STD" "MCIP"   "552691107" "USD" 12       .       . "I"      0
    1164 "12/31/2002" 2002 "INDL" "C" "D" "STD" "MCIP"   "552691107" "USD" 12       0     -45 "I"     45
    1164 "12/31/2003" 2003 "INDL" "C" "D" "STD" "MCIP"   "552691107" "USD" 12       0       . "I"      0
    1164 "12/31/2004" 2004 "INDL" "C" "D" "STD" "MCIP"   "552691107" "USD" 12       0       . "I"      0
    1177 "12/31/2001" 2001 "FS"   "C" "D" "STD" "AET"    "00817Y108" "USD" 12  6583.8       . "I"      0
    1177 "12/31/2001" 2001 "INDL" "C" "D" "STD" "AET"    "00817Y108" "USD" 12  6583.8       . "I"      0
    1177 "12/31/2002" 2002 "FS"   "C" "D" "STD" "AET"    "00817Y108" "USD" 12  3618.4       . "I"      0
    1177 "12/31/2002" 2002 "INDL" "C" "D" "STD" "AET"    "00817Y108" "USD" 12  3618.4       . "I"      0
    1177 "12/31/2003" 2003 "FS"   "C" "D" "STD" "AET"    "00817Y108" "USD" 12  3679.5       . "I"      0
    1177 "12/31/2003" 2003 "INDL" "C" "D" "STD" "AET"    "00817Y108" "USD" 12  3679.5       . "I"      0
    1177 "12/31/2004" 2004 "FS"   "C" "D" "STD" "AET"    "00817Y108" "USD" 12  3687.8       . "I"      0
    1177 "12/31/2004" 2004 "INDL" "C" "D" "STD" "AET"    "00817Y108" "USD" 12  3687.8       . "I"      0
    1177 "12/31/2005" 2005 "INDL" "C" "D" "STD" "AET"    "00817Y108" "USD" 12  4523.2       . "I"      0
    1177 "12/31/2005" 2005 "FS"   "C" "D" "STD" "AET"    "00817Y108" "USD" 12  4523.2       . "I"      0
    1177 "12/31/2006" 2006 "INDL" "C" "D" "STD" "AET"    "00817Y108" "USD" 12  4603.6       . "I"      0
    1177 "12/31/2006" 2006 "FS"   "C" "D" "STD" "AET"    "00817Y108" "USD" 12  4603.6       . "I"      0
    1177 "12/31/2007" 2007 "INDL" "C" "D" "STD" "AET"    "00817Y108" "USD" 12    5059       . "I"      0
    1177 "12/31/2007" 2007 "FS"   "C" "D" "STD" "AET"    "00817Y108" "USD" 12    5059       . "I"      0
    1177 "12/31/2008" 2008 "FS"   "C" "D" "STD" "AET"    "00817Y108" "USD" 12  5085.6       . "I"      0
    1177 "12/31/2008" 2008 "INDL" "C" "D" "STD" "AET"    "00817Y108" "USD" 12  5085.6       . "I"      0
    1177 "12/31/2009" 2009 "FS"   "C" "D" "STD" "AET"    "00817Y108" "USD" 12  5146.2       . "I"      0
    1177 "12/31/2009" 2009 "INDL" "C" "D" "STD" "AET"    "00817Y108" "USD" 12  5146.2       . "I"      0
    1177 "12/31/2010" 2010 "FS"   "C" "D" "STD" "AET"    "00817Y108" "USD" 12  5146.4       . "I"      0
    1177 "12/31/2010" 2010 "INDL" "C" "D" "STD" "AET"    "00817Y108" "USD" 12  5146.4       . "I"      0
    1177 "12/31/2011" 2011 "FS"   "C" "D" "STD" "AET"    "00817Y108" "USD" 12  6203.9       . "I"      0
    1177 "12/31/2011" 2011 "INDL" "C" "D" "STD" "AET"    "00817Y108" "USD" 12  6203.9       . "I"      0
    1177 "12/31/2012" 2012 "INDL" "C" "D" "STD" "AET"    "00817Y108" "USD" 12  6214.4       . "I"      0
    1177 "12/31/2012" 2012 "FS"   "C" "D" "STD" "AET"    "00817Y108" "USD" 12  6214.4       . "I"      0
    1177 "12/31/2013" 2013 "FS"   "C" "D" "STD" "AET"    "00817Y108" "USD" 12 10227.5       . "I"      0
    1177 "12/31/2013" 2013 "INDL" "C" "D" "STD" "AET"    "00817Y108" "USD" 12 10227.5       . "I"      0
    1177 "12/31/2014" 2014 "INDL" "C" "D" "STD" "AET"    "00817Y108" "USD" 12 10613.2       . "I"      0
    1177 "12/31/2014" 2014 "FS"   "C" "D" "STD" "AET"    "00817Y108" "USD" 12 10613.2       . "I"      0
    1177 "12/31/2015" 2015 "INDL" "C" "D" "STD" "AET"    "00817Y108" "USD" 12 10636.8       . "I"      0
    1177 "12/31/2015" 2015 "FS"   "C" "D" "STD" "AET"    "00817Y108" "USD" 12 10636.8       . "I"      0
    1177 "12/31/2016" 2016 "INDL" "C" "D" "STD" "AET"    "00817Y108" "USD" 12   10637       . "I"      0
    1177 "12/31/2016" 2016 "FS"   "C" "D" "STD" "AET"    "00817Y108" "USD" 12   10637       . "I"      0
    1177 "12/31/2017" 2017 "FS"   "C" "D" "STD" "AET"    "00817Y108" "USD" 12   10571       . "I"      0
    1177 "12/31/2017" 2017 "INDL" "C" "D" "STD" "AET"    "00817Y108" "USD" 12   10571       . "I"      0
    1254 "12/31/2001" 2001 "INDL" "C" "D" "STD" "MATX"   "57686G105" "USD" 12       0       . "A"      0
    1254 "12/31/2002" 2002 "INDL" "C" "D" "STD" "MATX"   "57686G105" "USD" 12       0       . "A"      0
    1254 "12/31/2003" 2003 "INDL" "C" "D" "STD" "MATX"   "57686G105" "USD" 12       .       . "A"      0
    1254 "12/31/2004" 2004 "INDL" "C" "D" "STD" "MATX"   "57686G105" "USD" 12       .       . "A"      0
    1254 "12/31/2005" 2005 "INDL" "C" "D" "STD" "MATX"   "57686G105" "USD" 12       .       . "A"      0
    1254 "12/31/2006" 2006 "INDL" "C" "D" "STD" "MATX"   "57686G105" "USD" 12       9       . "A"      0
    1254 "12/31/2007" 2007 "INDL" "C" "D" "STD" "MATX"   "57686G105" "USD" 12      12       . "A"      0
    1254 "12/31/2008" 2008 "INDL" "C" "D" "STD" "MATX"   "57686G105" "USD" 12      26       . "A"      0
    1254 "12/31/2009" 2009 "INDL" "C" "D" "STD" "MATX"   "57686G105" "USD" 12      27       . "A"      0
    1254 "12/31/2010" 2010 "INDL" "C" "D" "STD" "MATX"   "57686G105" "USD" 12      27       . "A"      0
    1254 "12/31/2011" 2011 "INDL" "C" "D" "STD" "MATX"   "57686G105" "USD" 12      27       . "A"      0
    1254 "12/31/2012" 2012 "INDL" "C" "D" "STD" "MATX"   "57686G105" "USD" 12      27       . "A"      0
    1254 "12/31/2013" 2013 "INDL" "C" "D" "STD" "MATX"   "57686G105" "USD" 12    27.4       . "A"      0
    1254 "12/31/2014" 2014 "INDL" "C" "D" "STD" "MATX"   "57686G105" "USD" 12    27.4       . "A"      0
    1254 "12/31/2015" 2015 "INDL" "C" "D" "STD" "MATX"   "57686G105" "USD" 12   241.6       . "A"      0
    1254 "12/31/2016" 2016 "INDL" "C" "D" "STD" "MATX"   "57686G105" "USD" 12   323.7       . "A"      0
    1254 "12/31/2017" 2017 "INDL" "C" "D" "STD" "MATX"   "57686G105" "USD" 12   323.7       . "A"      0
    1254 "12/31/2018" 2018 "INDL" "C" "D" "STD" "MATX"   "57686G105" "USD" 12   327.8       . "A"      0
    1254 "12/31/2019" 2019 "INDL" "C" "D" "STD" "MATX"   "57686G105" "USD" 12   327.8       . "A"      0
    1254 "12/31/2020" 2020 "INDL" "C" "D" "STD" "MATX"   "57686G105" "USD" 12   327.8       . "A"      0
    1300 "12/31/2001" 2001 "INDL" "C" "D" "STD" "HON"    "438516106" "USD" 12    5441       . "A"      0
    1300 "12/31/2002" 2002 "INDL" "C" "D" "STD" "HON"    "438516106" "USD" 12    5698       . "A"      0
    1300 "12/31/2003" 2003 "INDL" "C" "D" "STD" "HON"    "438516106" "USD" 12    5789       . "A"      0
    1300 "12/31/2004" 2004 "INDL" "C" "D" "STD" "HON"    "438516106" "USD" 12    6013       . "A"      0
    1300 "12/31/2005" 2005 "INDL" "C" "D" "STD" "HON"    "438516106" "USD" 12    7660       . "A"      0
    1300 "12/31/2006" 2006 "INDL" "C" "D" "STD" "HON"    "438516106" "USD" 12    8403       . "A"      0
    1300 "12/31/2007" 2007 "INDL" "C" "D" "STD" "HON"    "438516106" "USD" 12    9175       . "A"      0
    1300 "12/31/2008" 2008 "INDL" "C" "D" "STD" "HON"    "438516106" "USD" 12   10185       . "A"      0
    1300 "12/31/2009" 2009 "INDL" "C" "D" "STD" "HON"    "438516106" "USD" 12   10494       . "A"      0
    1300 "12/31/2010" 2010 "INDL" "C" "D" "STD" "HON"    "438516106" "USD" 12   11597       . "A"      0
    1300 "12/31/2011" 2011 "INDL" "C" "D" "STD" "HON"    "438516106" "USD" 12   11858       . "A"      0
    1300 "12/31/2012" 2012 "INDL" "C" "D" "STD" "HON"    "438516106" "USD" 12   12425       . "A"      0
    1300 "12/31/2013" 2013 "INDL" "C" "D" "STD" "HON"    "438516106" "USD" 12   13046       . "A"      0
    1300 "12/31/2014" 2014 "INDL" "C" "D" "STD" "HON"    "438516106" "USD" 12   12788       . "A"      0
    1300 "12/31/2015" 2015 "INDL" "C" "D" "STD" "HON"    "438516106" "USD" 12   15895       . "A"      0
    1300 "12/31/2016" 2016 "INDL" "C" "D" "STD" "HON"    "438516106" "USD" 12   17707       . "A"      0
    1300 "12/31/2017" 2017 "INDL" "C" "D" "STD" "HON"    "438516106" "USD" 12   18277       . "A"      0
    1300 "12/31/2018" 2018 "INDL" "C" "D" "STD" "HON"    "438516106" "USD" 12   15546       . "A"      0
    1300 "12/31/2019" 2019 "INDL" "C" "D" "STD" "HON"    "438516106" "USD" 12   15563       . "A"      0
    1300 "12/31/2020" 2020 "INDL" "C" "D" "STD" "HON"    "438516106" "USD" 12   16058       . "A"      0
    1324 "03/31/2002" 2001 "INDL" "C" "D" "STD" "SCHR.1" "806530101" "USD"  3       .       . "I"      0
    1327 "03/31/2002" 2001 "INDL" "C" "D" "STD" "SWKS"   "83088M102" "USD"  3       .       . "A"      0
    end

    Comment


    • #3
      Code:
      * Example generated by -dataex-. To install: ssc install dataex
      clear
      fyear     cusip           gdwl    GwlImpaired
      2001 "125141101"   8.135      0
      2002 "125141101"   9.527      0
      2003 "125141101"   9.527      0
      2004 "125141101"   9.527      0
      2005 "125141101"   9.527      0
      2006 "125141101"   9.527      0
      2007 "125141101"  14.761      0
      2008 "125141101"  31.116      0
      2009 "125141101"  14.591  17.11
      2010 "125141101"  14.713      0
      2011 "125141101"  14.661      0
      2012 "125141101"  19.548      0
      2013 "125141101"  132.22      0
      2014 "125141101" 167.547      0
      2015 "125141101" 220.163   3.34
      2016 "125141101" 170.153 57.923
      2017 "125141101" 166.951  7.168
      2018 "125141101" 152.156      0
      2019 "125141101"  152.02      0
      2020 "125141101"  161.82      0
      2001 "552691107"       .      0
      2002 "552691107"       0     45
      2003 "552691107"       0      0
      2004 "552691107"       0      0
      2001 "00817Y108"  6583.8      0
      2001 "00817Y108"  6583.8      0
      2002 "00817Y108"  3618.4      0
      2002 "00817Y108"  3618.4      0
      2003 "00817Y108"  3679.5      0
      2003 "00817Y108"  3679.5      0
      2004 "00817Y108"  3687.8      0
      2004 "00817Y108"  3687.8      0
      2005 "00817Y108"  4523.2      0
      2005 "00817Y108"  4523.2      0
      2006 "00817Y108"  4603.6      0
      2006 "00817Y108"  4603.6      0
      2007 "00817Y108"    5059      0
      2007 "00817Y108"    5059      0
      2008 "00817Y108"  5085.6      0
      2008 "00817Y108"  5085.6      0
      2009 "00817Y108"  5146.2      0
      2009 "00817Y108"  5146.2      0
      2010 "00817Y108"  5146.4      0
      2010 "00817Y108"  5146.4      0
      2011 "00817Y108"  6203.9      0
      2011 "00817Y108"  6203.9      0
      2012 "00817Y108"  6214.4      0
      2012 "00817Y108"  6214.4      0
      2013 "00817Y108" 10227.5      0
      2013 "00817Y108" 10227.5      0
      2014 "00817Y108" 10613.2      0
      2014 "00817Y108" 10613.2      0
      2015 "00817Y108" 10636.8      0
      2015 "00817Y108" 10636.8      0
      2016 "00817Y108"   10637      0
      2016 "00817Y108"   10637      0
      2017 "00817Y108"   10571      0
      2017 "00817Y108"   10571      0
      2001 "57686G105"       0      0
      2002 "57686G105"       0      0
      2003 "57686G105"       .      0
      2004 "57686G105"       .      0
      2005 "57686G105"       .      0
      2006 "57686G105"       9      0
      2007 "57686G105"      12      0
      2008 "57686G105"      26      0
      2009 "57686G105"      27      0
      2010 "57686G105"      27      0
      2011 "57686G105"      27      0
      2012 "57686G105"      27      0
      2013 "57686G105"    27.4      0
      2014 "57686G105"    27.4      0
      2015 "57686G105"   241.6      0
      2016 "57686G105"   323.7      0
      2017 "57686G105"   323.7      0
      2018 "57686G105"   327.8      0
      2019 "57686G105"   327.8      0
      2020 "57686G105"   327.8      0
      2001 "438516106"    5441      0
      2002 "438516106"    5698      0
      2003 "438516106"    5789      0
      2004 "438516106"    6013      0
      2005 "438516106"    7660      0
      2006 "438516106"    8403      0
      2007 "438516106"    9175      0
      2008 "438516106"   10185      0
      2009 "438516106"   10494      0
      2010 "438516106"   11597      0
      2011 "438516106"   11858      0
      2012 "438516106"   12425      0
      2013 "438516106"   13046      0
      2014 "438516106"   12788      0
      2015 "438516106"   15895      0
      2016 "438516106"   17707      0
      2017 "438516106"   18277      0
      2018 "438516106"   15546      0
      2019 "438516106"   15563      0
      2020 "438516106"   16058      0
      2001 "806530101"       .      0
      2001 "83088M102"       .      0
      end

      Comment


      • #4
        Code:
        * Example generated by -dataex-. To install: ssc install dataex
        clear
        fyear     cusip       gdwl    GwlImpaired
        2001 "125141101"   8.135      0
        2002 "125141101"   9.527      0
        2003 "125141101"   9.527      0
        2004 "125141101"   9.527      0
        2005 "125141101"   9.527      0
        2006 "125141101"   9.527      0
        2007 "125141101"  14.761      0
        2008 "125141101"  31.116      0
        2009 "125141101"  14.591  17.11
        2010 "125141101"  14.713      0
        2011 "125141101"  14.661      0
        2012 "125141101"  19.548      0
        2013 "125141101"  132.22      0
        2014 "125141101" 167.547      0
        2015 "125141101" 220.163   3.34
        2016 "125141101" 170.153 57.923
        2017 "125141101" 166.951  7.168
        2018 "125141101" 152.156      0
        2019 "125141101"  152.02      0
        2020 "125141101"  161.82      0
        2001 "552691107"       .      0
        2002 "552691107"       0     45
        2003 "552691107"       0      0
        2004 "552691107"       0      0
        2001 "00817Y108"  6583.8      0
        2001 "00817Y108"  6583.8      0
        2002 "00817Y108"  3618.4      0
        2002 "00817Y108"  3618.4      0
        2003 "00817Y108"  3679.5      0
        2003 "00817Y108"  3679.5      0
        2004 "00817Y108"  3687.8      0
        2004 "00817Y108"  3687.8      0
        2005 "00817Y108"  4523.2      0
        2005 "00817Y108"  4523.2      0
        2006 "00817Y108"  4603.6      0
        2006 "00817Y108"  4603.6      0
        2007 "00817Y108"    5059      0
        2007 "00817Y108"    5059      0
        2008 "00817Y108"  5085.6      0
        2008 "00817Y108"  5085.6      0
        2009 "00817Y108"  5146.2      0
        2009 "00817Y108"  5146.2      0
        2010 "00817Y108"  5146.4      0
        2010 "00817Y108"  5146.4      0
        2011 "00817Y108"  6203.9      0
        2011 "00817Y108"  6203.9      0
        2012 "00817Y108"  6214.4      0
        2012 "00817Y108"  6214.4      0
        2013 "00817Y108" 10227.5      0
        2013 "00817Y108" 10227.5      0
        2014 "00817Y108" 10613.2      0
        2014 "00817Y108" 10613.2      0
        2015 "00817Y108" 10636.8      0
        2015 "00817Y108" 10636.8      0
        2016 "00817Y108"   10637      0
        2016 "00817Y108"   10637      0
        2017 "00817Y108"   10571      0
        2017 "00817Y108"   10571      0
        2001 "57686G105"       0      0
        2002 "57686G105"       0      0
        2003 "57686G105"       .      0
        2004 "57686G105"       .      0
        2005 "57686G105"       .      0
        2006 "57686G105"       9      0
        2007 "57686G105"      12      0
        2008 "57686G105"      26      0
        2009 "57686G105"      27      0
        2010 "57686G105"      27      0
        2011 "57686G105"      27      0
        2012 "57686G105"      27      0
        2013 "57686G105"    27.4      0
        2014 "57686G105"    27.4      0
        2015 "57686G105"   241.6      0
        2016 "57686G105"   323.7      0
        2017 "57686G105"   323.7      0
        2018 "57686G105"   327.8      0
        2019 "57686G105"   327.8      0
        2020 "57686G105"   327.8      0
        2001 "438516106"    5441      0
        2002 "438516106"    5698      0
        2003 "438516106"    5789      0
        2004 "438516106"    6013      0
        2005 "438516106"    7660      0
        2006 "438516106"    8403      0
        2007 "438516106"    9175      0
        2008 "438516106"   10185      0
        2009 "438516106"   10494      0
        2010 "438516106"   11597      0
        2011 "438516106"   11858      0
        2012 "438516106"   12425      0
        2013 "438516106"   13046      0
        2014 "438516106"   12788      0
        2015 "438516106"   15895      0
        2016 "438516106"   17707      0
        2017 "438516106"   18277      0
        2018 "438516106"   15546      0
        2019 "438516106"   15563      0
        2020 "438516106"   16058      0
        2001 "806530101"       .      0
        2001 "83088M102"       .      0
        end

        Comment


        • #5

          * Example generated by -dataex-. To install: ssc install dataex clear fyear cusip gdwl GwlImpaired 2001 "125141101" 8.135 0 2002 "125141101" 9.527 0 2003 "125141101" 9.527 0 2004 "125141101" 9.527 0 2005 "125141101" 9.527 0 2006 "125141101" 9.527 0 2007 "125141101" 14.761 0 2008 "125141101" 31.116 0 2009 "125141101" 14.591 17.11 2010 "125141101" 14.713 0 2011 "125141101" 14.661 0 2012 "125141101" 19.548 0 2013 "125141101" 132.22 0 2014 "125141101" 167.547 0 2015 "125141101" 220.163 3.34 2016 "125141101" 170.153 57.923 2017 "125141101" 166.951 7.168 2018 "125141101" 152.156 0 2019 "125141101" 152.02 0 2020 "125141101" 161.82 0 2001 "552691107" . 0 2002 "552691107" 0 45 2003 "552691107" 0 0 2004 "552691107" 0 0 2001 "00817Y108" 6583.8 0 2001 "00817Y108" 6583.8 0 2002 "00817Y108" 3618.4 0 2002 "00817Y108" 3618.4 0 2003 "00817Y108" 3679.5 0 2003 "00817Y108" 3679.5 0 2004 "00817Y108" 3687.8 0 2004 "00817Y108" 3687.8 0 2005 "00817Y108" 4523.2 0 2005 "00817Y108" 4523.2 0 2006 "00817Y108" 4603.6 0 2006 "00817Y108" 4603.6 0 2007 "00817Y108" 5059 0 2007 "00817Y108" 5059 0 2008 "00817Y108" 5085.6 0 2008 "00817Y108" 5085.6 0 2009 "00817Y108" 5146.2 0 2009 "00817Y108" 5146.2 0 2010 "00817Y108" 5146.4 0 2010 "00817Y108" 5146.4 0 2011 "00817Y108" 6203.9 0 2011 "00817Y108" 6203.9 0 2012 "00817Y108" 6214.4 0 2012 "00817Y108" 6214.4 0 2013 "00817Y108" 10227.5 0 2013 "00817Y108" 10227.5 0 2014 "00817Y108" 10613.2 0 2014 "00817Y108" 10613.2 0 2015 "00817Y108" 10636.8 0 2015 "00817Y108" 10636.8 0 2016 "00817Y108" 10637 0 2016 "00817Y108" 10637 0 2017 "00817Y108" 10571 0 2017 "00817Y108" 10571 0 2001 "57686G105" 0 0 2002 "57686G105" 0 0 2003 "57686G105" . 0 2004 "57686G105" . 0 2005 "57686G105" . 0 2006 "57686G105" 9 0 2007 "57686G105" 12 0 2008 "57686G105" 26 0 2009 "57686G105" 27 0 2010 "57686G105" 27 0 2011 "57686G105" 27 0 2012 "57686G105" 27 0 2013 "57686G105" 27.4 0 2014 "57686G105" 27.4 0 2015 "57686G105" 241.6 0 2016 "57686G105" 323.7 0 2017 "57686G105" 323.7 0 2018 "57686G105" 327.8 0 2019 "57686G105" 327.8 0 2020 "57686G105" 327.8 0 2001 "438516106" 5441 0 2002 "438516106" 5698 0 2003 "438516106" 5789 0 2004 "438516106" 6013 0 2005 "438516106" 7660 0 2006 "438516106" 8403 0 2007 "438516106" 9175 0 2008 "438516106" 10185 0 2009 "438516106" 10494 0 2010 "438516106" 11597 0 2011 "438516106" 11858 0 2012 "438516106" 12425 0 2013 "438516106" 13046 0 2014 "438516106" 12788 0 2015 "438516106" 15895 0 2016 "438516106" 17707 0 2017 "438516106" 18277 0 2018 "438516106" 15546 0 2019 "438516106" 15563 0 2020 "438516106" 16058 0 2001 "806530101" . 0 2001 "83088M102" . 0 end

          Comment


          • #6
            Code:
            * Example generated by -dataex-. To install: ssc install dataex
            clear
            fyear cusip     gdwl   GwlImpaired
            2001 "125141101"   8.135      0
            2002 "125141101"   9.527      0
            2003 "125141101"   9.527      0
            2004 "125141101"   9.527      0
            2005 "125141101"   9.527      0
            2006 "125141101"   9.527      0
            2007 "125141101"  14.761      0
            2008 "125141101"  31.116      0
            2009 "125141101"  14.591  17.11
            2010 "125141101"  14.713      0
            2011 "125141101"  14.661      0
            2012 "125141101"  19.548      0
            2013 "125141101"  132.22      0
            2014 "125141101" 167.547      0
            2015 "125141101" 220.163   3.34
            2016 "125141101" 170.153 57.923
            2017 "125141101" 166.951  7.168
            2018 "125141101" 152.156      0
            2019 "125141101"  152.02      0
            2020 "125141101"  161.82      0
            2001 "552691107"       .      0
            2002 "552691107"       0     45
            2003 "552691107"       0      0
            2004 "552691107"       0      0
            2001 "00817Y108"  6583.8      0
            2001 "00817Y108"  6583.8      0
            2002 "00817Y108"  3618.4      0
            2002 "00817Y108"  3618.4      0
            2003 "00817Y108"  3679.5      0
            2003 "00817Y108"  3679.5      0
            2004 "00817Y108"  3687.8      0
            2004 "00817Y108"  3687.8      0
            2005 "00817Y108"  4523.2      0
            2005 "00817Y108"  4523.2      0
            2006 "00817Y108"  4603.6      0
            2006 "00817Y108"  4603.6      0
            2007 "00817Y108"    5059      0
            2007 "00817Y108"    5059      0
            2008 "00817Y108"  5085.6      0
            2008 "00817Y108"  5085.6      0
            2009 "00817Y108"  5146.2      0
            2009 "00817Y108"  5146.2      0
            2010 "00817Y108"  5146.4      0
            2010 "00817Y108"  5146.4      0
            2011 "00817Y108"  6203.9      0
            2011 "00817Y108"  6203.9      0
            2012 "00817Y108"  6214.4      0
            2012 "00817Y108"  6214.4      0
            2013 "00817Y108" 10227.5      0
            2013 "00817Y108" 10227.5      0
            2014 "00817Y108" 10613.2      0
            2014 "00817Y108" 10613.2      0
            2015 "00817Y108" 10636.8      0
            2015 "00817Y108" 10636.8      0
            2016 "00817Y108"   10637      0
            2016 "00817Y108"   10637      0
            2017 "00817Y108"   10571      0
            2017 "00817Y108"   10571      0
            2001 "57686G105"       0      0
            2002 "57686G105"       0      0
            2003 "57686G105"       .      0
            2004 "57686G105"       .      0
            2005 "57686G105"       .      0
            2006 "57686G105"       9      0
            2007 "57686G105"      12      0
            2008 "57686G105"      26      0
            2009 "57686G105"      27      0
            2010 "57686G105"      27      0
            2011 "57686G105"      27      0
            2012 "57686G105"      27      0
            2013 "57686G105"    27.4      0
            2014 "57686G105"    27.4      0
            2015 "57686G105"   241.6      0
            2016 "57686G105"   323.7      0
            2017 "57686G105"   323.7      0
            2018 "57686G105"   327.8      0
            2019 "57686G105"   327.8      0
            2020 "57686G105"   327.8      0
            2001 "438516106"    5441      0
            2002 "438516106"    5698      0
            2003 "438516106"    5789      0
            2004 "438516106"    6013      0
            2005 "438516106"    7660      0
            2006 "438516106"    8403      0
            2007 "438516106"    9175      0
            2008 "438516106"   10185      0
            2009 "438516106"   10494      0
            2010 "438516106"   11597      0
            2011 "438516106"   11858      0
            2012 "438516106"   12425      0
            2013 "438516106"   13046      0
            2014 "438516106"   12788      0
            2015 "438516106"   15895      0
            2016 "438516106"   17707      0
            2017 "438516106"   18277      0
            2018 "438516106"   15546      0
            2019 "438516106"   15563      0
            2020 "438516106"   16058      0
            2001 "806530101"       .      0
            2001 "83088M102"       .      0
            end

            Comment


            • #7
              Code:
              logit DIMPR Eindex _asize _aTobinsQ_W aleverage_W aFCF_W _tsize _relsize_W _tcash_W _tleverage_W allstock percentagecash dealsize2_W industryrelatedness _hightech i.aIndustry48, robust
              end

              Code:
              mfx compute
              end

              Comment


              • #8
                Code:
                logit DIMPR Eindex _asize _aTobinsQ_W aleverage_W aFCF_W _tsize _relsize_W _tcash_W _tleverage_W allstock percentagecash dealsize2_W industryrelatedness _hightech i.aIndustry48, robust

                Comment

                Working...
                X