Announcement

Collapse
No announcement yet.
X
Collapse
  • Page of 1
  • Filter
  • Time
  • Show
Clear All
new posts
  • #1

    Question- Merge Tariff with production data

    Hi!

    I want to merge two datasets (dta files). One dataset has bilateral tariff data by country exporter (isoexp), country importer (isoemp), industry (isic), and year. The other dataset has production, employment, year, and, exports data among other information by country exporter(isoexp). Obviously, in the current structure both datasets cannot be merged. However, the goal I have in mind is to average the tariff data by country (isoexp), year and industry to in the tariff dataset to make both datasets "mergable", so to speak. Any recommendation? Is there a shortcut to do it?

    For Tariff dataset

    dataex isoexp isoimp year isic tariff fntm1 fntm2 fntm3 fntm4 fntm5 fntmal cntm1 cntm2
    > cntm3 cntm4 cntm5 cntmal

    Code:
     * Example generated by -dataex-. To install: ssc install dataex
clear
input str3(isoexp isoimp) float(year isic tariff fntm1 fntm2 fntm3 fntm4 fntm5 fntmal cntm1 cntm2 cntm3 cntm4 cntm5 cntmal)
"NAM" "ZAF" 1994 311 0 0       0  .09995028 .8717056 0  .8731974 0 0            0         1 0         1
"ABW" "KWT" 2001 311 0 .       .          .        . .         . . .            .         . .         .
"AFG" "ITA" 2001 311 0 .       .          .        . .         . . .            .         . .         .
"BGD" "BGD" 1994 311 0 .       .          .        . .         . . .            .         . .         .
"NER" "IRL" 2001 311 0 .       .          .        . .         . . .            .         . .         .
"BRA" "HKG" 1998 311 0 .       .          .        . .         . . .            .         . .         .
"KHM" "CHE" 1998 311 0 .       .          .        . .         . . .            .         . .         .
"IRQ" "SGP" 1999 311 0 .       .          .        . .         . . .            .         . .         .
"IDN" "CHE" 1996 311 0 0       0  .12191457 .5451814 0 .54603994 0 0 .00026266312  .2356573 0  .2356573
"SDN" "SGP" 1999 311 0 .       .          .        . .         . . .            .         . .         .
"FJI" "HKG" 2001 311 0 .       .          .        . .         . . .            .         . .         .
"JAM" "BRB" 2001 311 0 .       .          .        . .         . . .            .         . .         .
"MUS" "SGP" 1998 311 0 .       .          .        . .         . . .            .         . .         .
"PRT" "AUT" 1999 311 0 0       0          0        0 0         0 0 0            0         0 0         0
"TCA" "ITA" 2001 311 0 .       .          .        . .         . . .            .         . .         .
"ALB" "CHE" 1998 311 0 .       .          .        . .         . . .            .         . .         .
"IRQ" "HKG" 1993 311 0 0       0 .007653061 .3035714 0  .3112245 . .            .         . .         .
"STP" "AUT" 2001 311 0 .       .          .        . .         . . .            .         . .         .
"ECU" "HKG" 1994 311 0 0       0          0        0 0         0 0 0            0         0 0         0
"DEU" "ESP" 1995 311 0 0       0          0        0 0         0 0 0            0         0 0         0
"MRT" "HKG" 1994 311 0 0       0          0        0 0         0 0 0            0         0 0         0
"SWZ" "HKG" 1998 311 0 .       .          .        . .         . . .            .         . .         .
"DJI" "EGY" 2001 311 0 .       .          .        . .         . . .            .         . .         .
"TTO" "ATG" 2001 311 0 .       .          .        . .         . . .            .         . .         .
"VCT" "EST" 1995 311 0 .       .          .        . .         . . .            .         . .         .
"BDI" "TKM" 2001 311 0 .       .          .        . .         . . .            .         . .         .
"ESP" "ESP" 1993 311 0 0       0          0        0 0         0 0 0            0         0 0         0
"KHM" "SGP" 1999 311 0 .       .          .        . .         . . .            .         . .         .
"PRT" "PRT" 1996 311 0 0       0          0        0 0         0 0 0            0         0 0         0
"LTT" "EST" 1995 311 0 .       .          .        . .         . . .            .         . .         .
"GAB" "MYS" 2001 311 0 .       .          .        . .         . . .            .         . .         .
"MDV" "TKM" 1998 311 0 .       .          .        . .         . . .            .         . .         .
"SYC" "CHE" 1993 311 0 0 .481982  .10960961 .6306306 0  .8918919 . .            .         . .         .
"CAF" "CHE" 1993 311 0 0 .481982  .10960961 .6306306 0  .8918919 . .            .         . .         .
"GRC" "ITA" 1995 311 0 0       0          0        0 0         0 0 0            0         0 0         0
"THA" "KGZ" 1995 311 0 .       .          .        . .         . . .            .         . .         .
"TON" "NZL" 2001 311 0 .       .          .        . .         . . .            .         . .         .
"TCD" "LTU" 1999 311 0 0       0          0 .5090682 0  .5090682 . .            .         . .         .
"SLE" "SGP" 1995 311 0 .       .          .        . .         . . .            .         . .         .
"MDG" "CZE" 2001 311 0 .       .          .        . .         . . .            .         . .         .
"POL" "HKG" 1993 311 0 0       0 .007653061 .3035714 0  .3112245 0 0            0  .6237113 0  .6237113
"TUN" "HKG" 1993 311 0 0       0 .007653061 .3035714 0  .3112245 . .            .         . .         .
"GIN" "SWE" 2001 311 0 .       .          .        . .         . . .            .         . .         .
"SUR" "GUY" 2001 311 0 .       .          .        . .         . . .            .         . .         .
"PRY" "TKM" 1998 311 0 .       .          .        . .         . . .            .         . .         .
"KEN" "HKG" 1998 311 0 .       .          .        . .         . . .            .         . .         .
"CPV" "SGP" 1995 311 0 .       .          .        . .         . . .            .         . .         .
"MHL" "MYS" 2001 311 0 .       .          .        . .         . . .            .         . .         .
"NER" "HKG" 2001 311 0 .       .          .        . .         . . .            .         . .         .
"CCK" "EST" 1995 311 0 .       .          .        . .         . . .            .         . .         .
"SYC" "BRN" 2001 311 0 .       .          .        . .         . . .            .         . .         .
"HUN" "SGP" 1995 311 0 .       .          .        . .         . . .            .         . .         .
"ESP" "GRC" 1999 311 0 0       0          0        0 0         0 0 0            0         0 0         0
"ZWE" "CHE" 1993 311 0 0 .481982  .10960961 .6306306 0  .8918919 . .            .         . .         .
"BDI" "CHE" 1998 311 0 .       .          .        . .         . . .            .         . .         .
"TGO" "BRN" 1994 311 0 .       .          .        . .         . . .            .         . .         .
"SMR" "CHE" 1996 311 0 0       0  .12191457 .5451814 0 .54603994 . .            .         . .         .
"CZE" "HKG" 1999 311 0 .       .          .        . .         . . .            .         . .         .
"GRL" "CHE" 1998 311 0 .       .          .        . .         . . .            .         . .         .
"TTO" "TTO" 1999 311 0 .       .          .        . .         . . .            .         . .         .
"MSR" "SGP" 1998 311 0 .       .          .        . .         . . .            .         . .         .
"BOL" "KGZ" 1995 311 0 .       .          .        . .         . . .            .         . .         .
"ALB" "CHE" 1993 311 0 0 .481982  .10960961 .6306306 0  .8918919 . .            .         . .         .
"AFG" "SGP" 1995 311 0 .       .          .        . .         . . .            .         . .         .
"VNM" "HKG" 2001 311 0 .       .          .        . .         . . .            .         . .         .
"TWN" "HKG" 1994 311 0 0       0          0        0 0         0 0 0            0         0 0         0
"GIB" "CHE" 1999 311 0 .       .          .        . .         . . .            .         . .         .
"UGA" "HKG" 1994 311 0 0       0          0        0 0         0 0 0            0         0 0         0
"BDI" "NZL" 1999 311 0 0       0          0 .9429066 0  .9429066 . .            .         . .         .
"QAT" "HKG" 1994 311 0 0       0          0        0 0         0 0 0            0         0 0         0
"CHL" "CHE" 1996 311 0 0       0  .12191457 .5451814 0 .54603994 0 0      .115467 .23332734 0 .23332734
"COL" "CHE" 1999 311 0 .       .          .        . .         . . .            .         . .         .
"MDV" "SGP" 1995 311 0 .       .          .        . .         . . .            .         . .         .
"NLD" "NLD" 1993 311 0 0       0          0        0 0         0 0 0            0         0 0         0
"ITA" "NLD" 1996 311 0 0       0          0        0 0         0 0 0            0         0 0         0
"PRT" "ITA" 1998 311 0 0       0          0        0 0         0 0 0            0         0 0         0
"XXX" "BRN" 1994 311 0 .       .          .        . .         . . .            .         . .         .
"NLD" "ITA" 1998 311 0 0       0          0        0 0         0 0 0            0         0 0         0
"IRL" "ITA" 1995 311 0 0       0          0        0 0         0 0 0            0         0 0         0
"JPN" "HKG" 1998 311 0 .       .          .        . .         . . .            .         . .         .
"GIB" "SGP" 1999 311 0 .       .          .        . .         . . .            .         . .         .
"ZAR" "GBR" 2001 311 0 .       .          .        . .         . . .            .         . .         .
"LVA" "CHE" 1999 311 0 .       .          .        . .         . . .            .         . .         .
"VUT" "SGP" 1998 311 0 .       .          .        . .         . . .            .         . .         .
"NAM" "ZAF" 1997 311 0 .       .          .        . .         . . .            .         . .         .
"IRQ" "SGP" 2001 311 0 .       .          .        . .         . . .            .         . .         .
"IDN" "HKG" 2001 311 0 .       .          .        . .         . . .            .         . .         .
"HND" "HKG" 1993 311 0 0       0 .007653061 .3035714 0  .3112245 0 0            0         0 0         0
"VCT" "HKG" 1998 311 0 .       .          .        . .         . . .            .         . .         .
"QAT" "HKG" 2001 311 0 .       .          .        . .         . . .            .         . .         .
"GRL" "SGP" 1998 311 0 .       .          .        . .         . . .            .         . .         .
"OMN" "TKM" 1998 311 0 .       .          .        . .         . . .            .         . .         .
"MNC" "BRN" 1992 311 0 .       .          .        . .         . . .            .         . .         .
"AIA" "IRL" 2001 311 0 .       .          .        . .         . . .            .         . .         .
"GBR" "SGP" 1995 311 0 .       .          .        . .         . . .            .         . .         .
"IRL" "BEL" 1999 311 0 0       0          0        0 0         0 0 0            0         0 0         0
"HND" "EST" 1995 311 0 .       .          .        . .         . . .            .         . .         .
"VGB" "HKG" 1999 311 0 .       .          .        . .         . . .            .         . .         .
"JOR" "HKG" 1994 311 0 0       0          0        0 0         0 0 0            0         0 0         0
"MAR" "HKG" 1994 311 0 0       0          0        0 0         0 0 0            0         0 0         0
end
    For production,exports, employment etc data

    Code:
     * Example generated by -dataex-. To install: ssc install dataex
clear
input str3 isoexp float(year isic) double(firms lab wage prod va) float intflow double(expw impw) float conso
"ABW" 1998 381 32 456 19.411561965942383 . . .  762.8907470703125     33425.19921875 .
"ABW" 1997 332  .   .                  . . . .                  .    1491.5849609375 .
"ABW" 1994 351  .   .                  . . . .  662.2030639648438    3023.4990234375 .
"ABW" 1995 383  .   .                  . . . .  665.3068237304688    20187.357421875 .
"ABW" 1994 372  .   .                  . . . .   1.59865403175354 1120.3909912109375 .
"ABW" 1994 322  .   .                  . . . .   74.8759994506836     9674.154296875 .
"ABW" 1999 382  .   .                  . . . . 1335.7171630859375       99778.640625 .
"ABW" 1993 311  .   .                  . . . . 129.91397094726563       44362.734375 .
"ABW" 1993 321  .   .                  . . . . 2.9079816341400146   4325.06689453125 .
"ABW" 1997 355  .   .                  . . . .  278.8111572265625  3429.075927734375 .
"ABW" 1998 314  .   .                  . . . .                  .     119915.1015625 .
"ABW" 1993 355  .   .                  . . . .  40.24287796020508  1247.594970703125 .
"ABW" 1993 369  6 117                  . . . . 14.757100159635742 1968.2669677734375 .
"ABW" 1997 362  .   .                  . . . .  6.494204998016357 1734.0550537109375 .
"ABW" 1998 311  .   .                  . . . .    6638.2119140625       59884.453125 .
"ABW" 1999 385  .   .                  . . . .  387.8370056152344   12646.3330078125 .
"ABW" 1997 383  .   .                  . . . .   1324.82763671875     21651.79296875 .
"ABW" 1994 371  .   .                  . . . . 108.37322235107422      2164.74609375 .
"ABW" 1995 314  .   .                  . . . .                  .     47201.04296875 .
"ABW" 1998 383  .   .                  . . . .  2054.617431640625     34913.73828125 .
"ABW" 1999 322  .   .                  . . . .  89.48799896240234     9967.166015625 .
"ABW" 1996 371  .   .                  . . . .  614.9658813476563    2952.7470703125 .
"ABW" 1997 385  .   .                  . . . .  445.1409912109375     6131.833984375 .
"ABW" 1999 314  .   .                  . . . .  70.52999877929688    11542.607421875 .
"ABW" 1994 311  .   .                  . . . .   6536.84716796875      46847.0390625 .
"ABW" 1995 355  .   .                  . . . . 1.7359999418258667     1801.251953125 .
"ABW" 1995 341  .   .                  . . . . 28.399417877197266     5712.998046875 .
"ABW" 1995 324  2   5                  . . . . 16.634000778198242   2034.85498046875 .
"ABW" 1996 351  .   .                  . . . .  116.4378433227539  2515.551025390625 .
"ABW" 1995 382  .   .                  . . . .  936.1038208007813     35272.48046875 .
"ABW" 1994 356  2  18                  . . . .                  1   1839.56103515625 .
"ABW" 1997 356 12 191 17.356502532958984 . . . 16.595897674560547      9647.49609375 .
"ABW" 1997 352  6  53 13.233868598937988 . . . 213.54908752441406       34093.171875 .
"ABW" 1994 384  .   .                  . . . .   346.479248046875       20068.296875 .
"ABW" 1996 352  .   .                  . . . . 373.03887939453125    22863.451171875 .
"ABW" 1997 371  .   .                  . . . .  579.6211547851563   4521.65380859375 .
"ABW" 1995 322  .   .                  . . . . 41.765254974365234     9401.955078125 .
"ABW" 1994 352  .   .                  . . . .  324.4296569824219    9655.6923828125 .
"ABW" 1998 384  .   .                  . . . .    7312.1923828125      97045.9921875 .
"ABW" 1999 351  .   .                  . . . .   11297.9482421875           5158.625 .
"ABW" 1994 353  7 592                  . . . .       496619.71875        55272.96875 .
"ABW" 1997 342  .   .                  . . . .  51.51506805419922    4201.6572265625 .
"ABW" 1995 369  7  93                  . . . .                  .   4913.01806640625 .
"ABW" 1999 341 12 201 14.840715408325195 . . . 14.276824951171875   5624.02783203125 .
"ABW" 1993 341  .   .                  . . . . 26.965635299682617   4848.69677734375 .
"ABW" 1996 385  .   .                  . . . . 476.70001220703125        6801.203125 .
"ABW" 1996 323  .   .                  . . . . 3.8359999656677246 1878.3070068359375 .
"ABW" 1997 321  .   .                  . . . .  29.86385726928711     6029.423828125 .
"ABW" 1993 362  .   .                  . . . .  9.104616165161133 1404.9749755859375 .
"ABW" 1999 362  .   .                  . . . . 15.388836860656738  2646.385986328125 .
"ABW" 1998 382  .   .                  . . . . 2040.8912353515625      93398.7890625 .
"ABW" 1996 341  .   .                  . . . . 114.52630615234375   5399.60595703125 .
"ABW" 1997 313  7 155 15.194123268127441 . . . 29.835350036621094      107799.484375 .
"ABW" 1998 385  .   .                  . . . .  764.2730102539063    8850.9775390625 .
"ABW" 1995 332  .   .                  . . . .                  . 2030.7039794921875 .
"ABW" 1997 384  .   .                  . . . .  1279.635498046875     31673.48828125 .
"ABW" 1998 352  6  47 14.955361366271973 . . .  477.3688049316406     27124.91015625 .
"ABW" 1997 353  2 609 23.824756622314453 . . .        884694.8125       62204.734375 .
"ABW" 1993 372  .   .                  . . . . 137.88917541503906  1846.802001953125 .
"ABW" 1999 384  .   .                  . . . .   16177.6494140625     63691.01171875 .
"ABW" 1998 371  .   .                  . . . .  574.9954223632813   4995.05517578125 .
"ABW" 1994 369  6  92                  . . . . 12.150196075439453      4329.74609375 .
"ABW" 1996 355  .   .                  . . . .  37.20100021362305  2119.992919921875 .
"ABW" 1997 323  .   .                  . . . .  61.35200119018555 1481.1600341796875 .
"ABW" 1995 311  .   .                  . . . .   14405.9501953125     47945.77734375 .
"ABW" 1999 342  .   .                  . . . .  44.51665115356445    3386.3740234375 .
"ABW" 1998 331  .   .                  . . . . 1.6130506992340088   7891.84716796875 .
"ABW" 1995 351  .   .                  . . . .  4015.112548828125   3934.27294921875 .
"ABW" 1993 323  .   .                  . . . .  4.568999767303467     738.5830078125 .
"ABW" 1997 311  .   .                  . . . .     21562.18359375       64220.578125 .
"ABW" 1996 381  6  45                  . . . .  187.9371337890625    19262.685546875 .
"ABW" 1997 322  .   .                  . . . .  46.95199966430664    11086.939453125 .
"ABW" 1993 314  .   .                  . . . .                  .    25164.798828125 .
"ABW" 1999 356 12 169 17.754680633544922 . . . 51.376380920410156   7295.26416015625 .
"ABW" 1994 355  .   .                  . . . . 28.578083038330078      987.666015625 .
"ABW" 1996 321  .   .                  . . . . 308.71722412109375   5846.48388671875 .
"ABW" 1995 352  .   .                  . . . . 246.08358764648438      17045.8046875 .
"ABW" 1998 356 10 163 18.190208435058594 . . . 123.86139678955078    6885.9580078125 .
"ABW" 1993 351  .   .                  . . . .  37.24083709716797  3062.096923828125 .
"ABW" 1995 371  .   .                  . . . .  40.67544937133789 1791.1280517578125 .
"ABW" 1998 342  .   .                  . . . .  44.53577423095703   3301.22998046875 .
"ABW" 1996 311  .   .                  . . . .    17025.556640625     50243.21484375 .
"ABW" 1995 321  .   .                  . . . .  188.3024139404297   7761.02587890625 .
"ABW" 1997 381 23 190 21.063215255737305 . . .   316.225830078125    23601.126953125 .
"ABW" 1995 362  .   .                  . . . . 3.8299999237060547 1527.5770263671875 .
"ABW" 1997 372  .   .                  . . . .  749.1602783203125   5064.65576171875 .
"ABW" 1996 362  .   .                  . . . .  7.731365203857422  1685.364013671875 .
"ABW" 1998 341 11 195 13.596758842468262 . . . 107.13569641113281      5497.79296875 .
"ABW" 1996 331  .   .                  . . . . 30.629352569580078   6827.14794921875 .
"ABW" 1993 324  2   2                  . . . .   83.7770004272461 1181.3480224609375 .
"ABW" 1995 381  7  51                  . . . .  295.5492248535156        24295.03125 .
"ABW" 1999 332  .   .                  . . . .  .9235941767692566   2790.27001953125 .
"ABW" 1996 322  .   .                  . . . . 252.86199951171875    10631.685546875 .
"ABW" 1993 331  .   .                  . . . .   4.47047233581543    7562.6298828125 .
"ABW" 1996 313  5 167                  . . . .  138.7043914794922       92096.171875 .
"ABW" 1996 324  2   3                  . . . .  6.176000118255615   2410.85791015625 .
"ABW" 1995 356  2  20                  . . . .   9.21399974822998     5247.466796875 .
"ABW" 1999 369  .   .                  . . . . 17.659276962280273    8336.4482421875 .
"ABW" 1997 314  .   .                  . . . .  .9350000023841858      115392.609375 .
"ABW" 1994 321  .   .                  . . . .  67.99099731445313   4562.31787109375 .
end
    Thank you!
    Tags: None
  • #2
    Obviously, in the current structure both datasets cannot be merged.
    Yes, they can. If you wanted to merge them you could do that with
    Code:
    use tarriff_data, clear
merge m:1 isoexp year isic using production_etc_data
    Now, in the example data sets, there are no actual matches on isoexp, year, and isic. But presumably in the full data you would get matches.

    Of course, if you don't want to merge those data sets and it is better for you to average up the tarriff data by isoexp year and isic, you can do that, and then merge:
    Code:
    use tarriff_data, clear
collapse (mean) tariff fntm1 fntm2 fntm3 fntm4 fntm5 fntmal ///
    cntm1 cntm2 cntm3 cntm4 cntm5 cntmal, by(isoexp isic year)
merge 1:1 isoexp isic year using production_etc_data
    Again, in the example data, there are no matches. But in the real data, presumably there are.
    • 1 like

    Comment

    • #3
      Thank you so much! The production datatset (second dataex) has data sorted by isoexp, country year. Once I do the same sort with the tariff data, I get the following dataex. Which, I think, proves your point of doing the merge m:1. I will try doing it both ways, actually...as a robustness check and see if my estimates change substantially because tariffs are pretty skewed...

      Code:
       * Example generated by -dataex-. To install: ssc install dataex
clear
input str3(isoexp isoimp) float(year isic tariff fntm1 fntm2 fntm3 fntm4 fntm5 fntmal cntm1 cntm2 cntm3 cntm4 cntm5 cntmal) long country
"ABW" "ALB" 1997 311   16.691942 0 0         0          0 0          0 . . . . . . 1
"ABW" "ALB" 1997 313    28.15017 0 0         0          0 0          0 . . . . . . 1
"ABW" "ALB" 1997 314    29.47454 0 0         0          0 0          0 . . . . . . 1
"ABW" "ALB" 1997 321    23.31284 0 0         0          0 0          0 . . . . . . 1
"ABW" "ALB" 1997 322   29.980804 0 0         0          0 0          0 . . . . . . 1
"ABW" "ALB" 1997 323   25.986866 0 0         0          0 0          0 . . . . . . 1
"ABW" "ALB" 1997 324    19.69504 0 0         0          0 0          0 . . . . . . 1
"ABW" "ALB" 1997 331     14.6246 0 0         0          0 0          0 . . . . . . 1
"ABW" "ALB" 1997 332    26.07671 0 0         0          0 0          0 . . . . . . 1
"ABW" "ALB" 1997 341   14.067312 0 0         0          0 0          0 . . . . . . 1
"ABW" "ALB" 1997 342    8.603755 0 0         0          0 0          0 . . . . . . 1
"ABW" "ALB" 1997 351    10.97219 0 0         0 .016025642 0 .016025642 . . . . . . 1
"ABW" "ALB" 1997 352      15.504 0 0         0   .1888889 0   .1888889 . . . . . . 1
"ABW" "ALB" 1997 353          10 0 0         0          0 0          0 . . . . . . 1
"ABW" "ALB" 1997 355    20.03013 0 0         0          0 0          0 . . . . . . 1
"ABW" "ALB" 1997 356      20.575 0 0         0          0 0          0 . . . . . . 1
"ABW" "ALB" 1997 361    21.42124 0 0         0          0 0          0 . . . . . . 1
"ABW" "ALB" 1997 362   17.180502 0 0         0          0 0          0 . . . . . . 1
"ABW" "ALB" 1997 369   17.698982 0 0         0          0 0          0 . . . . . . 1
"ABW" "ALB" 1997 371   18.037815 0 0         0          0 0          0 . . . . . . 1
"ABW" "ALB" 1997 372   12.509932 0 0         0          0 0          0 . . . . . . 1
"ABW" "ALB" 1997 381    22.12789 0 0         0          0 0          0 . . . . . . 1
"ABW" "ALB" 1997 382    7.728777 0 0         0          0 0          0 . . . . . . 1
"ABW" "ALB" 1997 383   11.998616 0 0         0          0 0          0 . . . . . . 1
"ABW" "ALB" 1997 384   14.262854 0 0         0          0 0          0 . . . . . . 1
"ABW" "ALB" 1997 385   13.949114 0 0         0          0 0          0 . . . . . . 1
"ABW" "ALB" 1997 390    25.21327 0 0         0          0 0          0 . . . . . . 1
"ABW" "ALB" 2001 311   15.865485 . .         .          . .          . . . . . . . 1
"ABW" "ALB" 2001 313          10 . .         .          . .          . . . . . . . 1
"ABW" "ALB" 2001 314          20 . .         .          . .          . . . . . . . 1
"ABW" "ALB" 2001 321   15.330188 . .         .          . .          . . . . . . . 1
"ABW" "ALB" 2001 322          20 . .         .          . .          . . . . . . . 1
"ABW" "ALB" 2001 323          20 . .         .          . .          . . . . . . . 1
"ABW" "ALB" 2001 324          20 . .         .          . .          . . . . . . . 1
"ABW" "ALB" 2001 341           6 . .         .          . .          . . . . . . . 1
"ABW" "ALB" 2001 351    9.645891 . .         .          . .          . . . . . . . 1
"ABW" "ALB" 2001 352    3.975292 . .         .          . .          . . . . . . . 1
"ABW" "ALB" 2001 353   11.422944 . .         .          . .          . . . . . . . 1
"ABW" "ALB" 2001 355          20 . .         .          . .          . . . . . . . 1
"ABW" "ALB" 2001 356   18.731344 . .         .          . .          . . . . . . . 1
"ABW" "ALB" 2001 362    9.285714 . .         .          . .          . . . . . . . 1
"ABW" "ALB" 2001 369           5 . .         .          . .          . . . . . . . 1
"ABW" "ALB" 2001 371   18.060585 . .         .          . .          . . . . . . . 1
"ABW" "ALB" 2001 372    9.396551 . .         .          . .          . . . . . . . 1
"ABW" "ALB" 2001 381    7.618214 . .         .          . .          . . . . . . . 1
"ABW" "ALB" 2001 382    4.623908 . .         .          . .          . . . . . . . 1
"ABW" "ALB" 2001 383    5.257207 . .         .          . .          . . . . . . . 1
"ABW" "ALB" 2001 384    3.299189 . .         .          . .          . . . . . . . 1
"ABW" "ALB" 2001 385   13.082191 . .         .          . .          . . . . . . . 1
"ABW" "ALB" 2001 390          20 . .         .          . .          . . . . . . . 1
"ABW" "ARE" 2001 311 .0009680542 . .         .          . .          . . . . . . . 1
"ABW" "ARE" 2001 313     47.8173 . .         .          . .          . . . . . . . 1
"ABW" "ARE" 2001 314         100 . .         .          . .          . . . . . . . 1
"ABW" "ARE" 2001 321           4 . .         .          . .          . . . . . . . 1
"ABW" "ARE" 2001 322           4 . .         .          . .          . . . . . . . 1
"ABW" "ARE" 2001 331           4 . .         .          . .          . . . . . . . 1
"ABW" "ARE" 2001 341           4 . .         .          . .          . . . . . . . 1
"ABW" "ARE" 2001 351           4 . .         .          . .          . . . . . . . 1
"ABW" "ARE" 2001 352    3.184314 . .         .          . .          . . . . . . . 1
"ABW" "ARE" 2001 353           4 . .         .          . .          . . . . . . . 1
"ABW" "ARE" 2001 362           4 . .         .          . .          . . . . . . . 1
"ABW" "ARE" 2001 371           4 . .         .          . .          . . . . . . . 1
"ABW" "ARE" 2001 372    .2136438 . .         .          . .          . . . . . . . 1
"ABW" "ARE" 2001 381           4 . .         .          . .          . . . . . . . 1
"ABW" "ARE" 2001 382           4 . .         .          . .          . . . . . . . 1
"ABW" "ARE" 2001 383           4 . .         .          . .          . . . . . . . 1
"ABW" "ARE" 2001 384    3.979741 . .         .          . .          . . . . . . . 1
"ABW" "ARE" 2001 385           4 . .         .          . .          . . . . . . . 1
"ABW" "ARE" 2001 390    3.956171 . .         .          . .          . . . . . . . 1
"ABW" "ARG" 1993 311    5.951416 0 0         0 .009957326 0 .009957326 . . . . . . 1
"ABW" "ARG" 1993 313    7.582502 0 0         0 .023809524 0 .023809524 . . . . . . 1
"ABW" "ARG" 1993 314    9.754565 0 0         0          0 0          0 . . . . . . 1
"ABW" "ARG" 1993 321   15.925385 0 0         0          0 0          0 . . . . . . 1
"ABW" "ARG" 1993 322   19.882807 0 0         0          0 0          0 . . . . . . 1
"ABW" "ARG" 1993 323   13.853502 0 0         0          0 0          0 . . . . . . 1
"ABW" "ARG" 1993 324    19.55118 0 0         0          0 0          0 . . . . . . 1
"ABW" "ARG" 1993 331    8.548953 0 0         0          0 0          0 . . . . . . 1
"ABW" "ARG" 1993 332   12.053523 0 0         0          0 0          0 . . . . . . 1
"ABW" "ARG" 1993 341    12.54589 0 0         0  .05726872 0  .05726872 . . . . . . 1
"ABW" "ARG" 1993 342   16.268528 0 0         0          0 0          0 . . . . . . 1
"ABW" "ARG" 1993 351    7.867692 0 0         0  .07001522 0  .07001522 . . . . . . 1
"ABW" "ARG" 1993 352     7.51294 0 0         0  .04483696 0  .04483696 . . . . . . 1
"ABW" "ARG" 1993 353           0 0 0         0  .06666667 0  .06666667 . . . . . . 1
"ABW" "ARG" 1993 355   12.517467 0 0         0          0 0          0 . . . . . . 1
"ABW" "ARG" 1993 356   12.904675 0 0         0          0 0          0 . . . . . . 1
"ABW" "ARG" 1993 361    12.30139 0 0         0          0 0          0 . . . . . . 1
"ABW" "ARG" 1993 362   11.096045 0 0         0          0 0          0 . . . . . . 1
"ABW" "ARG" 1993 369    9.064282 0 0         0  .01923077 0  .01923077 . . . . . . 1
"ABW" "ARG" 1993 371    10.26707 0 0         0          0 0          0 . . . . . . 1
"ABW" "ARG" 1993 372    8.391413 0 0         0          0 0          0 . . . . . . 1
"ABW" "ARG" 1993 381    14.85507 0 0         0          0 0          0 . . . . . . 1
"ABW" "ARG" 1993 382   14.176544 0 0         0          0 0          0 . . . . . . 1
"ABW" "ARG" 1993 383   14.986664 0 0         0          0 0          0 . . . . . . 1
"ABW" "ARG" 1993 384     15.2696 0 0 .11518325          0 0  .11518325 . . . . . . 1
"ABW" "ARG" 1993 385    15.54766 0 0         0          0 0          0 . . . . . . 1
"ABW" "ARG" 1993 390   12.947047 0 0         0          0 0          0 . . . . . . 1
"ABW" "ARG" 1995 311   11.942805 0 0 .04597701  .21072797 0  .25478926 . . . . . . 1
"ABW" "ARG" 1995 313   18.731583 0 0         0   .3636364 0   .3636364 . . . . . . 1
"ABW" "ARG" 1995 314   19.734694 0 0         0       .875 0       .875 . . . . . . 1
"ABW" "ARG" 1995 321    19.32149 0 0         0  .24879615 0  .24879615 . . . . . . 1
end
label values country country1
label def country1 1 "ABW", modify

      Comment

      Previous Next
      Working...
      X