i have this database
Code:
nationalidnumber city naceprimary nacesecondary conscode nuts2 nuts3 year ebit loans interest or totalassets ltdebt profitmargin roa numberofemployees capital totaldebtratio interestcoverageratio _merge nace_prim D1 D2 D3 D4 D5 112669417 LISBOA G. Wholesale and retail trade; repair of motor vehicles and motorcycles 4674 NRF PT17 - Area Metropolitana de Lisboa PT170 - Area Metropolitana de Lisboa 2010 1074.7268 160.07111 8350.6473 12186.027 15 13.042 8.937 73 8506.0551 .0012309 matched (3) G 1 0 0 0 112669417 LISBOA G. Wholesale and retail trade; repair of motor vehicles and motorcycles 4674 NRF PT17 - Area Metropolitana de Lisboa PT170 - Area Metropolitana de Lisboa 2011 1042.8341 5.98952 7127.0686 11705.916 15 15.38 9.364 73 8484.7278 .0012814 matched (3) G 1 0 0 0 112669417 LISBOA G. Wholesale and retail trade; repair of motor vehicles and motorcycles 4674 NRF PT17 - Area Metropolitana de Lisboa PT170 - Area Metropolitana de Lisboa 2012 543.79557 6.3963 6370.728 9858.2019 15 10.422 6.735 73 7554.1713 .0015216 matched (3) G 1 0 0 0 112669417 LISBOA G. Wholesale and retail trade; repair of motor vehicles and motorcycles 4674 NRF PT17 - Area Metropolitana de Lisboa PT170 - Area Metropolitana de Lisboa 2013 595.02584 0 5844.5135 8584.0872 15 11.548 7.863 73 6502.4975 .0017474 matched (3) G 1 0 0 0 114058431 MACEDA G. Wholesale and retail trade; repair of motor vehicles and motorcycles 4672 NRF PT16 - Centre PT16D - Regiao de Aveiro 2010 120.3827 229.63937 3325.3493 2539.1449 2.751 3.602 5 1613.1124 matched (3) G 0 0 0 114058431 MACEDA G. Wholesale and retail trade; repair of motor vehicles and motorcycles 4672 NRF PT16 - Centre PT16D - Regiao de Aveiro 2011 128.35412 380 2822.1231 2745.858 3.021 3.105 5 1704.578 matched (3) G 0 0 0 114058431 MACEDA G. Wholesale and retail trade; repair of motor vehicles and motorcycles 4672 NRF PT16 - Centre PT16D - Regiao de Aveiro 2012 67.49097 442.25223 4491.3412 2910.4266 .464 .716 5 1789.8327 matched (3) G 0 0 0 114058431 MACEDA G. Wholesale and retail trade; repair of motor vehicles and motorcycles 4672 NRF PT16 - Centre PT16D - Regiao de Aveiro 2013 36.87203 410.94349 3484.5829 3198.5948 .084 .091 5 1810.6615 matched (3) G 0 0 0 114058431 MACEDA G. Wholesale and retail trade; repair of motor vehicles and motorcycles 4672 NRF PT16 - Centre PT16D - Regiao de Aveiro 2014 37.22483 0 4130.316 3281.5677 .328 .413 5 1813.5804 matched (3) G 0 0 0 123901324 SETÚBAL K. Financial and insurance activities 6622 NRF PT17 - Area Metropolitana de Lisboa PT170 - Area Metropolitana de Lisboa 2010 -13.57025 0 50.62066 133.05805 0 -30.9 -11.755 2 60 0 matched (3) K 1 1 1 0 123901324 SETÚBAL K. Financial and insurance activities 6622 NRF PT17 - Area Metropolitana de Lisboa PT170 - Area Metropolitana de Lisboa 2011 -19.73846 0 38.72169 116.86178 -56.617 -18.76 2 60 matched (3) K 1 1 0 123901324 SETÚBAL K. Financial and insurance activities 6622 NRF PT17 - Area Metropolitana de Lisboa PT170 - Area Metropolitana de Lisboa 2012 -17.31315 0 35.97617 117.6686 71.41328 -53.883 -16.474 2 60 .6069018 matched (3) K 0 1 1 0 123901324 SETÚBAL K. Financial and insurance activities 6622 NRF PT17 - Area Metropolitana de Lisboa PT170 - Area Metropolitana de Lisboa 2013 5.10031 0 57.64859 104.85094 62.01219 5.649 3.106 2 60 .5914319 matched (3) K 0 0 0 0 123901324 SETÚBAL K. Financial and insurance activities 6622 NRF PT17 - Area Metropolitana de Lisboa PT170 - Area Metropolitana de Lisboa 2014 24.67543 16.79846 108.1291 102.22998 36.0083 20.682 21.876 2 60 .3522284 matched (3) K 1 0 0 0 126038287 TERÇOS H. Transportation and storage 4932 NRF PT30 - Regiao Autonoma da Madeira PT300 - Regiao Autonoma da Madeira 2010 6.54004 11.08905 37.94895 0 58.977 17.234 1 7.83384 0 matched (3) H 1 0 0 0 126038287 TERÇOS H. Transportation and storage 4932 NRF PT30 - Regiao Autonoma da Madeira PT300 - Regiao Autonoma da Madeira 2011 3.92343 8.17731 41.76738 47.979 9.394 1 14.37388 matched (3) H 0 0 0 126038287 TERÇOS H. Transportation and storage 4932 NRF PT30 - Regiao Autonoma da Madeira PT300 - Regiao Autonoma da Madeira 2012 3.78077 8.07973 45.54815 46.793 8.301 1 18.29731 matched (3) H 0 0 0 126038287 TERÇOS H. Transportation and storage 4932 NRF PT30 - Regiao Autonoma da Madeira PT300 - Regiao Autonoma da Madeira 2013 4.61787 9.42336 50.16602 49.004 9.205 1 22.07808 matched (3) H 0 0 0 126038287 TERÇOS H. Transportation and storage 4932 NRF PT30 - Regiao Autonoma da Madeira PT300 - Regiao Autonoma da Madeira 2014 4.91777 9.73842 55.08379 50.499 8.928 1 26.69595 matched (3) H 0 0 0 126744270 SAMBADA L. Real estate activities 6820 NRF PT15 - Algarve PT150 - Algarve 2010 110.76372 20.48322 842.553 704.90404 13.108 15.667 2 164.5756 matched (3) L 0 0 0 126744270 SAMBADA L. Real estate activities 6820 NRF PT15 - Algarve PT150 - Algarve 2012 122.20101 18.69055 867.16334 914.08049 14.092 13.369 2 362.96555 matched (3) L 0 0 0 126744270 SAMBADA L. Real estate activities 6820 NRF PT15 - Algarve PT150 - Algarve 2013 85.45094 0 253.78024 314.44505 33.671 27.175 2 0 matched (3) L 0 0 0 126744270 SAMBADA L. Real estate activities 6820 NRF PT15 - Algarve PT150 - Algarve 2014 11.34593 40.19944 301.40274 0 28.224 3.764 2 0 0 matched (3) L 1 0 0 0
any tips? thanks in advance
Afonso Pita
0 Response to How to keep a variable with 3 consecutive years
Post a Comment