Announcement

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

    Merging Different Datasets downloaded from different data sources

    Dear Statalisters

    I want to merge several datasets into a consolidated one. Some of the datasets were downloaded from the same source so they used the same country code for each country. However, one of the datasets was downloaded from a different source & hence used different country code. For instance, the datasets from the first source denote "Australia" as "AU" & "Austria" as "AT",but another dataset from the second source denote "Australia" & "Austria" as "AUS" & "AUT" respectively.

    Here are the data examples:

    1st Source
    Code:
    * Example generated by -dataex-. To install: ssc install dataex
clear
input str2 Country_Code str14 Country int Time double Cred_GDP_Gap
"AT" "Austria"   156  -1.3
"AT" "Austria"   157   -.6
"AT" "Austria"   158   2.3
"AT" "Austria"   159   4.2
"AT" "Austria"   160   3.1
"AT" "Austria"   161     5
"AT" "Austria"   162   9.4
"AT" "Austria"   163   7.2
"AT" "Austria"   164     5
"AT" "Austria"   165   4.2
"AT" "Austria"   166   4.4
"AT" "Austria"   167   5.4
"AT" "Austria"   168   3.9
"AT" "Austria"   169   3.4
"AT" "Austria"   170   2.8
"AT" "Austria"   171   2.1
"AT" "Austria"   172    .6
"AT" "Austria"   173    .3
"AT" "Austria"   174   -.2
"AT" "Austria"   175   1.5
"AT" "Austria"   176    .5
"AT" "Austria"   177    .5
"AT" "Austria"   178   -.5
"AT" "Austria"   179  -1.7
"AT" "Austria"   180  -2.3
"AT" "Austria"   181    .2
"AT" "Austria"   182    .9
"AT" "Austria"   183   -.5
"AT" "Austria"   184    .1
"AT" "Austria"   185   1.3
"AT" "Austria"   186   1.5
"AT" "Austria"   187    -1
"AT" "Austria"   188  -2.9
"AT" "Austria"   189   -.9
"AT" "Austria"   190   -.4
"AT" "Austria"   191   1.2
"AT" "Austria"   192    .7
"AT" "Austria"   193     0
"AT" "Austria"   194   -.3
"AT" "Austria"   195   1.3
"AT" "Austria"   196    .9
"AT" "Austria"   197    .9
"AT" "Austria"   198   1.6
"AT" "Austria"   199    .8
"AT" "Austria"   200    .8
"AT" "Austria"   201   1.3
"AT" "Austria"   202   -.1
"AT" "Austria"   203   -.4
"AT" "Austria"   204  -3.1
"AT" "Austria"   205  -3.4
"AT" "Austria"   206  -4.2
"AT" "Austria"   207  -4.3
"AT" "Austria"   208  -5.3
"AT" "Austria"   209  -4.5
"AT" "Austria"   210  -5.1
"AT" "Austria"   211  -7.1
"AT" "Austria"   212  -7.8
"AT" "Austria"   213  -8.6
"AT" "Austria"   214  -8.9
"AT" "Austria"   215  -4.6
"AT" "Austria"   216  -6.2
"AT" "Austria"   217  -5.9
"AT" "Austria"   218    -6
"AT" "Austria"   219  -9.6
"AT" "Austria"   220  -8.9
"AT" "Austria"   221 -11.2
"AT" "Austria"   222 -10.5
"AT" "Austria"   223  -9.5
"AT" "Austria"   224 -10.6
"AT" "Austria"   225 -10.7
"AT" "Austria"   226  -9.2
"AT" "Austria"   227  -7.9
"AT" "Austria"   228    -8
"AT" "Austria"   229  -9.5
"AT" "Austria"   230  -9.9
"AT" "Austria"   231 -10.7
"AU" "Australia" 156    .1
"AU" "Australia" 157   -.7
"AU" "Australia" 158    .4
"AU" "Australia" 159   2.1
"AU" "Australia" 160   2.9
"AU" "Australia" 161   4.9
"AU" "Australia" 162   4.9
"AU" "Australia" 163   7.4
"AU" "Australia" 164   9.1
"AU" "Australia" 165   6.8
"AU" "Australia" 166   7.1
"AU" "Australia" 167   5.1
"AU" "Australia" 168   4.5
"AU" "Australia" 169   6.3
"AU" "Australia" 170   7.6
"AU" "Australia" 171   6.7
"AU" "Australia" 172   5.3
"AU" "Australia" 173     7
"AU" "Australia" 174     7
"AU" "Australia" 175   8.5
"AU" "Australia" 176     8
"AU" "Australia" 177   9.2
"AU" "Australia" 178   9.2
"AU" "Australia" 179  10.5
"AU" "Australia" 180  10.4
"AU" "Australia" 181  13.2
"AU" "Australia" 182  14.3
"AU" "Australia" 183  15.4
"AU" "Australia" 184  14.4
"AU" "Australia" 185  16.1
"AU" "Australia" 186  17.3
"AU" "Australia" 187  17.2
"AU" "Australia" 188  16.1
"AU" "Australia" 189  16.6
"AU" "Australia" 190  18.3
"AU" "Australia" 191  17.9
"AU" "Australia" 192  16.9
"AU" "Australia" 193  14.8
"AU" "Australia" 194  12.8
"AU" "Australia" 195  11.2
"AU" "Australia" 196   7.2
"AU" "Australia" 197   4.3
"AU" "Australia" 198   3.8
"AU" "Australia" 199   3.6
"AU" "Australia" 200   2.1
"AU" "Australia" 201   -.3
"AU" "Australia" 202  -4.1
"AU" "Australia" 203  -8.3
"AU" "Australia" 204   -10
"AU" "Australia" 205 -12.5
"AU" "Australia" 206 -12.5
"AU" "Australia" 207 -13.8
"AU" "Australia" 208   -14
"AU" "Australia" 209 -13.2
"AU" "Australia" 210 -12.9
"AU" "Australia" 211 -12.6
"AU" "Australia" 212 -12.6
"AU" "Australia" 213  -9.7
"AU" "Australia" 214  -9.5
"AU" "Australia" 215  -7.8
"AU" "Australia" 216  -8.9
"AU" "Australia" 217  -7.4
"AU" "Australia" 218  -5.9
"AU" "Australia" 219  -3.6
"AU" "Australia" 220     0
"AU" "Australia" 221   1.6
"AU" "Australia" 222   3.3
"AU" "Australia" 223     3
"AU" "Australia" 224   3.4
"AU" "Australia" 225   3.5
"AU" "Australia" 226   1.6
"AU" "Australia" 227   -.5
"AU" "Australia" 228  -4.8
"AU" "Australia" 229  -5.6
"AU" "Australia" 230  -8.3
"AU" "Australia" 231  -8.2
"BE" "Belgium"   156  14.9
"BE" "Belgium"   157  15.7
"BE" "Belgium"   158  17.4
"BE" "Belgium"   159  17.8
"BE" "Belgium"   160  18.5
"BE" "Belgium"   161    19
"BE" "Belgium"   162  19.6
"BE" "Belgium"   163  20.6
"BE" "Belgium"   164  19.7
"BE" "Belgium"   165    20
"BE" "Belgium"   166  18.9
"BE" "Belgium"   167  19.2
"BE" "Belgium"   168  16.3
"BE" "Belgium"   169  14.1
"BE" "Belgium"   170  11.7
"BE" "Belgium"   171   9.5
"BE" "Belgium"   172   7.1
"BE" "Belgium"   173   8.6
"BE" "Belgium"   174   9.2
"BE" "Belgium"   175  10.3
"BE" "Belgium"   176   9.4
"BE" "Belgium"   177   8.2
"BE" "Belgium"   178   7.3
"BE" "Belgium"   179     7
"BE" "Belgium"   180     5
"BE" "Belgium"   181   3.8
"BE" "Belgium"   182   2.1
"BE" "Belgium"   183    .7
"BE" "Belgium"   184   -.2
"BE" "Belgium"   185   -.1
"BE" "Belgium"   186   -.3
"BE" "Belgium"   187  -1.3
"BE" "Belgium"   188    .5
"BE" "Belgium"   189     2
"BE" "Belgium"   190   3.9
"BE" "Belgium"   191     5
"BE" "Belgium"   192   7.9
"BE" "Belgium"   193  10.8
"BE" "Belgium"   194  13.6
"BE" "Belgium"   195  18.6
"BE" "Belgium"   196  22.1
"BE" "Belgium"   197  22.9
"BE" "Belgium"   198    23
"BE" "Belgium"   199  20.9
"BE" "Belgium"   200  16.2
"BE" "Belgium"   201  12.6
"BE" "Belgium"   202   5.7
"BE" "Belgium"   203    .4
"BE" "Belgium"   204    .4
"BE" "Belgium"   205   2.8
"BE" "Belgium"   206   2.8
"BE" "Belgium"   207   4.1
"BE" "Belgium"   208   3.7
"BE" "Belgium"   209   4.7
"BE" "Belgium"   210   3.8
"BE" "Belgium"   211   3.4
"BE" "Belgium"   212   7.5
"BE" "Belgium"   213   6.1
"BE" "Belgium"   214     1
"BE" "Belgium"   215  -2.4
"BE" "Belgium"   216  -5.5
"BE" "Belgium"   217  -5.3
"BE" "Belgium"   218  -4.2
"BE" "Belgium"   219  -4.8
"BE" "Belgium"   220  -2.3
"BE" "Belgium"   221  -8.3
"BE" "Belgium"   222   1.7
"BE" "Belgium"   223  -3.6
"BE" "Belgium"   224   3.3
"BE" "Belgium"   225   2.3
"BE" "Belgium"   226  -1.5
"BE" "Belgium"   227   2.3
"BE" "Belgium"   228   -.3
"BE" "Belgium"   229  -3.8
"BE" "Belgium"   230  -9.1
"BE" "Belgium"   231 -10.1
end
format %tq Time


    2nd Source

    Code:
    * Example generated by -dataex-. To install: ssc install dataex
clear
input str4 Country float Time str7 measure float equity_price str7 indicator str1 flagcodes
"AUS"  -8 "IDX2010" 2.997673 "SHPRICE" ""
"AUS"  -7 "IDX2010" 3.020671 "SHPRICE" ""
"AUS"  -6 "IDX2010" 3.175909 "SHPRICE" ""
"AUS"  -5 "IDX2010" 3.183096 "SHPRICE" ""
"AUS"  -4 "IDX2010" 3.367082 "SHPRICE" ""
"AUS"  -3 "IDX2010" 3.579815 "SHPRICE" ""
"AUS"  -2 "IDX2010" 4.058466 "SHPRICE" ""
"AUS"  -1 "IDX2010" 4.420688 "SHPRICE" ""
"AUS"   0 "IDX2010" 4.712477 "SHPRICE" ""
"AUS"   1 "IDX2010" 4.802314 "SHPRICE" ""
"AUS"   2 "IDX2010"  4.95899 "SHPRICE" ""
"AUS"   3 "IDX2010" 4.316477 "SHPRICE" ""
"AUS"   4 "IDX2010" 4.161958 "SHPRICE" ""
"AUS"   5 "IDX2010" 4.414219 "SHPRICE" ""
"AUS"   6 "IDX2010" 4.410626 "SHPRICE" ""
"AUS"   7 "IDX2010" 4.321508 "SHPRICE" ""
"AUS"   8 "IDX2010" 4.553646 "SHPRICE" ""
"AUS"   9 "IDX2010" 4.393377 "SHPRICE" ""
"AUS"  10 "IDX2010" 4.228796 "SHPRICE" ""
"AUS"  11 "IDX2010" 4.247482 "SHPRICE" ""
"AUS"  12 "IDX2010" 4.431468 "SHPRICE" ""
"AUS"  13 "IDX2010" 4.583113 "SHPRICE" ""
"AUS"  14 "IDX2010" 4.991331 "SHPRICE" ""
"AUS"  15 "IDX2010" 5.072543 "SHPRICE" ""
"AUS"  16 "IDX2010" 5.432609 "SHPRICE" ""
"AUS"  17 "IDX2010" 5.372957 "SHPRICE" ""
"AUS"  18 "IDX2010" 5.418954 "SHPRICE" ""
"AUS"  19 "IDX2010" 5.226344 "SHPRICE" ""
"AUS"  20 "IDX2010" 5.027266 "SHPRICE" ""
"AUS"  21 "IDX2010" 4.629827 "SHPRICE" ""
"AUS"  22 "IDX2010" 4.581675 "SHPRICE" ""
"AUS"  23 "IDX2010" 4.594612 "SHPRICE" ""
"AUS"  24 "IDX2010" 4.698103 "SHPRICE" ""
"AUS"  25 "IDX2010"  4.68373 "SHPRICE" ""
"AUS"  26 "IDX2010"  4.72182 "SHPRICE" ""
"AUS"  27 "IDX2010" 4.612579 "SHPRICE" ""
"AUS"  28 "IDX2010" 4.787941 "SHPRICE" ""
"AUS"  29 "IDX2010" 4.971926 "SHPRICE" ""
"AUS"  30 "IDX2010" 5.733742 "SHPRICE" ""
"AUS"  31 "IDX2010"  6.45028 "SHPRICE" ""
"AUS"  32 "IDX2010" 6.751413 "SHPRICE" ""
"AUS"  33 "IDX2010" 8.032125 "SHPRICE" ""
"AUS"  34 "IDX2010" 8.683981 "SHPRICE" ""
"AUS"  35 "IDX2010" 8.046499 "SHPRICE" ""
"AUS"  36 "IDX2010"   9.0038 "SHPRICE" ""
"AUS"  37 "IDX2010" 8.770944 "SHPRICE" ""
"AUS"  38 "IDX2010" 8.194551 "SHPRICE" ""
"AUS"  39 "IDX2010"  8.69045 "SHPRICE" ""
"AUS"  40 "IDX2010" 9.079982 "SHPRICE" ""
"AUS"  41 "IDX2010" 7.971756 "SHPRICE" ""
"AUS"  42 "IDX2010" 8.364881 "SHPRICE" ""
"AUS"  43 "IDX2010" 7.794238 "SHPRICE" ""
"AUS"  44 "IDX2010" 7.254498 "SHPRICE" ""
"AUS"  45 "IDX2010" 7.241562 "SHPRICE" ""
"AUS"  46 "IDX2010"  6.85778 "SHPRICE" ""
"AUS"  47 "IDX2010" 6.383441 "SHPRICE" ""
"AUS"  48 "IDX2010"  7.61672 "SHPRICE" ""
"AUS"  49 "IDX2010" 8.545273 "SHPRICE" ""
"AUS"  50 "IDX2010" 8.498558 "SHPRICE" ""
"AUS"  51 "IDX2010" 8.681107 "SHPRICE" ""
"AUS"  52 "IDX2010" 8.676076 "SHPRICE" ""
"AUS"  53 "IDX2010" 8.033563 "SHPRICE" ""
"AUS"  54 "IDX2010" 7.736742 "SHPRICE" ""
"AUS"  55 "IDX2010" 6.727696 "SHPRICE" ""
"AUS"  56 "IDX2010" 7.329243 "SHPRICE" ""
"AUS"  57 "IDX2010" 6.690324 "SHPRICE" ""
"AUS"  58 "IDX2010" 4.729007 "SHPRICE" ""
"AUS"  59 "IDX2010" 4.379004 "SHPRICE" ""
"AUS"  60 "IDX2010" 5.067513 "SHPRICE" ""
"AUS"  61 "IDX2010"  5.23928 "SHPRICE" ""
"AUS"  62 "IDX2010"  5.36577 "SHPRICE" ""
"AUS"  63 "IDX2010" 6.080871 "SHPRICE" ""
"AUS"  64 "IDX2010" 6.688886 "SHPRICE" ""
"AUS"  65 "IDX2010" 6.742788 "SHPRICE" ""
"AUS"  66 "IDX2010" 7.209221 "SHPRICE" ""
"AUS"  67 "IDX2010" 6.283543 "SHPRICE" ""
"AUS"  68 "IDX2010" 6.346788 "SHPRICE" ""
"AUS"  69 "IDX2010" 6.558803 "SHPRICE" ""
"AUS"  70 "IDX2010" 6.420814 "SHPRICE" ""
"AUS"  71 "IDX2010" 6.497714 "SHPRICE" ""
"AUS"  72 "IDX2010" 6.678106 "SHPRICE" ""
"AUS"  73 "IDX2010" 7.039609 "SHPRICE" ""
"AUS"  74 "IDX2010" 7.715181 "SHPRICE" ""
"AUS"  75 "IDX2010" 7.830891 "SHPRICE" ""
"AUS"  76 "IDX2010" 8.418064 "SHPRICE" ""
"AUS"  77 "IDX2010" 8.463342 "SHPRICE" ""
"AUS"  78 "IDX2010" 9.110167 "SHPRICE" ""
"AUS"  79 "IDX2010" 10.19468 "SHPRICE" ""
"AUS"  80 "IDX2010" 12.24583 "SHPRICE" ""
"AUS"  81 "IDX2010" 12.59368 "SHPRICE" ""
"AUS"  82 "IDX2010"  14.3092 "SHPRICE" ""
"AUS"  83 "IDX2010" 15.65747 "SHPRICE" ""
"AUS"  84 "IDX2010" 14.49678 "SHPRICE" ""
"AUS"  85 "IDX2010" 15.23129 "SHPRICE" ""
"AUS"  86 "IDX2010" 13.20744 "SHPRICE" ""
"AUS"  87 "IDX2010" 12.49953 "SHPRICE" ""
"AUS"  88 "IDX2010" 10.79407 "SHPRICE" ""
"AUS"  89 "IDX2010" 10.64745 "SHPRICE" ""
"AUS"  90 "IDX2010" 10.42897 "SHPRICE" ""
"AUS"  91 "IDX2010" 10.59643 "SHPRICE" ""
"AUS"  92 "IDX2010" 11.12754 "SHPRICE" ""
"AUS"  93 "IDX2010" 13.05867 "SHPRICE" ""
"AUS"  94 "IDX2010" 15.03005 "SHPRICE" ""
"AUS"  95 "IDX2010" 15.86158 "SHPRICE" ""
"AUS"  96 "IDX2010" 16.19937 "SHPRICE" ""
"AUS"  97 "IDX2010" 14.87553 "SHPRICE" ""
"AUS"  98 "IDX2010" 15.48355 "SHPRICE" ""
"AUS"  99 "IDX2010" 16.02113 "SHPRICE" ""
"AUS" 100 "IDX2010" 17.21574 "SHPRICE" ""
"AUS" 101 "IDX2010" 18.75382 "SHPRICE" ""
"AUS" 102 "IDX2010" 20.56155 "SHPRICE" ""
"AUS" 103 "IDX2010"  21.7157 "SHPRICE" ""
"AUS" 104 "IDX2010" 23.44387 "SHPRICE" ""
"AUS" 105 "IDX2010" 26.10225 "SHPRICE" ""
"AUS" 106 "IDX2010" 25.60068 "SHPRICE" ""
"AUS" 107 "IDX2010" 30.40026 "SHPRICE" ""
"AUS" 108 "IDX2010" 34.49782 "SHPRICE" ""
"AUS" 109 "IDX2010" 37.98766 "SHPRICE" ""
"AUS" 110 "IDX2010" 46.20894 "SHPRICE" ""
"AUS" 111 "IDX2010" 28.33696 "SHPRICE" ""
"AUS" 112 "IDX2010"  28.1948 "SHPRICE" ""
"AUS" 113 "IDX2010" 32.90577 "SHPRICE" ""
"AUS" 114 "IDX2010" 34.02176 "SHPRICE" ""
"AUS" 115 "IDX2010"  32.6686 "SHPRICE" ""
"AUS" 116 "IDX2010" 32.31041 "SHPRICE" ""
"AUS" 117 "IDX2010" 32.71237 "SHPRICE" ""
"AUS" 118 "IDX2010" 36.89402 "SHPRICE" ""
"AUS" 119 "IDX2010" 35.27085 "SHPRICE" ""
"AUS" 120 "IDX2010" 34.39483 "SHPRICE" ""
"AUS" 121 "IDX2010" 31.95889 "SHPRICE" ""
"AUS" 122 "IDX2010" 32.18528 "SHPRICE" ""
"AUS" 123 "IDX2010" 28.22104 "SHPRICE" ""
"AUS" 124 "IDX2010"  29.9791 "SHPRICE" ""
"AUS" 125 "IDX2010" 32.70382 "SHPRICE" ""
"AUS" 126 "IDX2010" 33.59679 "SHPRICE" ""
"AUS" 127 "IDX2010" 35.51283 "SHPRICE" ""
"AUS" 128 "IDX2010" 34.63746 "SHPRICE" ""
"AUS" 129 "IDX2010" 36.20422 "SHPRICE" ""
"AUS" 130 "IDX2010" 34.11713 "SHPRICE" ""
"AUS" 131 "IDX2010" 31.47377 "SHPRICE" ""
"AUS" 132 "IDX2010" 34.44629 "SHPRICE" ""
"AUS" 133 "IDX2010" 36.75042 "SHPRICE" ""
"AUS" 134 "IDX2010" 40.12541 "SHPRICE" ""
"AUS" 135 "IDX2010" 43.42134 "SHPRICE" ""
"AUS" 136 "IDX2010" 46.07979 "SHPRICE" ""
"AUS" 137 "IDX2010" 43.07421 "SHPRICE" ""
"AUS" 138 "IDX2010" 42.95275 "SHPRICE" ""
"AUS" 139 "IDX2010" 40.71977 "SHPRICE" ""
"AUS" 140 "IDX2010"  39.4944 "SHPRICE" ""
"AUS" 141 "IDX2010" 42.57472 "SHPRICE" ""
"AUS" 142 "IDX2010"  44.9076 "SHPRICE" ""
"AUS" 143 "IDX2010" 45.18143 "SHPRICE" ""
"AUS" 144 "IDX2010" 47.41872 "SHPRICE" ""
"AUS" 145 "IDX2010" 47.17508 "SHPRICE" ""
"AUS" 146 "IDX2010" 46.38524 "SHPRICE" ""
"AUS" 147 "IDX2010" 49.45334 "SHPRICE" ""
"AUS" 148 "IDX2010" 51.29248 "SHPRICE" ""
"AUS" 149 "IDX2010" 53.35298 "SHPRICE" ""
"AUS" 150 "IDX2010" 56.44839 "SHPRICE" ""
"AUS" 151 "IDX2010"  54.0918 "SHPRICE" ""
"AUS" 152 "IDX2010" 56.39593 "SHPRICE" ""
"AUS" 153 "IDX2010" 57.67448 "SHPRICE" ""
"AUS" 154 "IDX2010" 55.57662 "SHPRICE" ""
"AUS" 155 "IDX2010" 55.57087 "SHPRICE" ""
"AUS" 156 "IDX2010" 60.15254 "SHPRICE" ""
"AUS" 157 "IDX2010" 63.32055 "SHPRICE" ""
"AUS" 158 "IDX2010" 63.30114 "SHPRICE" ""
"AUS" 159 "IDX2010" 63.38451 "SHPRICE" ""
"AUS" 160 "IDX2010" 67.67368 "SHPRICE" ""
"AUS" 161 "IDX2010" 67.04769 "SHPRICE" ""
"AUS" 162 "IDX2010" 71.26356 "SHPRICE" ""
"AUS" 163 "IDX2010"  70.6153 "SHPRICE" ""
"AUS" 164 "IDX2010"  70.8079 "SHPRICE" ""
"AUS" 165 "IDX2010" 72.37035 "SHPRICE" ""
"AUS" 166 "IDX2010" 70.66416 "SHPRICE" ""
"AUS" 167 "IDX2010" 70.86108 "SHPRICE" ""
"AUS" 168 "IDX2010" 74.12467 "SHPRICE" ""
"AUS" 169 "IDX2010"  72.1612 "SHPRICE" ""
"AUS" 170 "IDX2010" 67.17059 "SHPRICE" ""
"AUS" 171 "IDX2010" 64.79962 "SHPRICE" ""
"AUS" 172 "IDX2010" 62.55514 "SHPRICE" ""
"AUS" 173 "IDX2010" 64.68678 "SHPRICE" ""
"AUS" 174 "IDX2010" 67.78938 "SHPRICE" ""
"AUS" 175 "IDX2010" 69.69896 "SHPRICE" ""
"AUS" 176 "IDX2010" 72.05125 "SHPRICE" ""
"AUS" 177 "IDX2010" 74.26266 "SHPRICE" ""
"AUS" 178 "IDX2010" 76.61064 "SHPRICE" ""
"AUS" 179 "IDX2010" 83.00414 "SHPRICE" ""
"AUS" 180 "IDX2010" 89.22012 "SHPRICE" ""
"AUS" 181 "IDX2010" 88.67104 "SHPRICE" ""
"AUS" 182 "IDX2010"  95.4548 "SHPRICE" ""
"AUS" 183 "IDX2010" 98.43738 "SHPRICE" ""
"AUS" 184 "IDX2010" 105.5949 "SHPRICE" ""
"AUS" 185 "IDX2010" 110.5704 "SHPRICE" ""
"AUS" 186 "IDX2010" 108.4818 "SHPRICE" ""
"AUS" 187 "IDX2010" 116.8216 "SHPRICE" ""
"AUS" 188 "IDX2010"  125.553 "SHPRICE" ""
"AUS" 189 "IDX2010" 134.7357 "SHPRICE" ""
"AUS" 190 "IDX2010" 134.1313 "SHPRICE" ""
"AUS" 191 "IDX2010" 141.0488 "SHPRICE" ""
"AUS" 192 "IDX2010" 120.6551 "SHPRICE" ""
"AUS" 193 "IDX2010" 120.0873 "SHPRICE" ""
"AUS" 194 "IDX2010" 106.6607 "SHPRICE" ""
"AUS" 195 "IDX2010" 83.25568 "SHPRICE" ""
"AUS" 196 "IDX2010" 74.86062 "SHPRICE" ""
"AUS" 197 "IDX2010" 82.44788 "SHPRICE" ""
"AUS" 198 "IDX2010" 93.01699 "SHPRICE" ""
"AUS" 199 "IDX2010" 101.5723 "SHPRICE" ""
"AUS" 200 "IDX2010" 102.4405 "SHPRICE" ""
"AUS" 201 "IDX2010"  99.6721 "SHPRICE" ""
"AUS" 202 "IDX2010" 96.73695 "SHPRICE" ""
"AUS" 203 "IDX2010" 101.1505 "SHPRICE" ""
"AUS" 204 "IDX2010" 103.1441 "SHPRICE" ""
"AUS" 205 "IDX2010" 101.6277 "SHPRICE" ""
"AUS" 206 "IDX2010" 92.24152 "SHPRICE" ""
"AUS" 207 "IDX2010"  90.1379 "SHPRICE" ""
"AUS" 208 "IDX2010" 91.41861 "SHPRICE" ""
"AUS" 209 "IDX2010" 90.59858 "SHPRICE" ""
"AUS" 210 "IDX2010"  92.1869 "SHPRICE" ""
"AUS" 211 "IDX2010"  97.1387 "SHPRICE" ""
"AUS" 212 "IDX2010" 106.3674 "SHPRICE" ""
"AUS" 213 "IDX2010"  107.015 "SHPRICE" ""
"AUS" 214 "IDX2010" 109.7762 "SHPRICE" ""
"AUS" 215 "IDX2010" 114.0754 "SHPRICE" ""
"AUS" 216 "IDX2010" 114.7956 "SHPRICE" ""
"AUS" 217 "IDX2010" 117.6222 "SHPRICE" ""
"AUS" 218 "IDX2010" 119.1595 "SHPRICE" ""
"AUS" 219 "IDX2010" 115.5272 "SHPRICE" ""
"AUS" 220 "IDX2010" 123.2898 "SHPRICE" ""
"AUS" 221 "IDX2010" 123.3948 "SHPRICE" ""
"AUS" 222 "IDX2010" 115.2412 "SHPRICE" ""
"AUS" 223 "IDX2010" 111.7577 "SHPRICE" ""
"AUS" 224 "IDX2010" 107.8674 "SHPRICE" ""
"AUS" 225 "IDX2010" 112.7947 "SHPRICE" ""
"AUS" 226 "IDX2010" 117.0099 "SHPRICE" ""
"AUS" 227 "IDX2010" 117.3951 "SHPRICE" ""
"AUS" 228 "IDX2010" 123.6441 "SHPRICE" ""
"AUS" 229 "IDX2010" 125.2648 "SHPRICE" ""
"AUS" 230 "IDX2010" 123.3948 "SHPRICE" ""
"AUS" 231 "IDX2010" 128.1324 "SHPRICE" ""
"AUS" 232 "IDX2010" 128.7073 "SHPRICE" ""
"AUT" -12 "IDX2010" 5.639756 "SHPRICE" ""
"AUT" -11 "IDX2010" 5.184722 "SHPRICE" ""
"AUT" -10 "IDX2010" 5.141738 "SHPRICE" ""
"AUT"  -9 "IDX2010" 5.009823 "SHPRICE" ""
"AUT"  -8 "IDX2010" 4.863085 "SHPRICE" ""
"AUT"  -7 "IDX2010" 4.667436 "SHPRICE" ""
"AUT"  -6 "IDX2010" 4.605183 "SHPRICE" ""
"AUT"  -5 "IDX2010" 5.123952 "SHPRICE" ""
"AUT"  -4 "IDX2010" 5.238081 "SHPRICE" ""
"AUT"  -3 "IDX2010" 5.484126 "SHPRICE" ""
"AUT"  -2 "IDX2010" 7.434695 "SHPRICE" ""
"AUT"  -1 "IDX2010" 7.243492 "SHPRICE" ""
"AUT"   0 "IDX2010" 7.742992 "SHPRICE" ""
"AUT"   1 "IDX2010" 8.245457 "SHPRICE" ""
"AUT"   2 "IDX2010" 8.884283 "SHPRICE" ""
"AUT"   3 "IDX2010" 9.782494 "SHPRICE" ""
"AUT"   4 "IDX2010" 11.83089 "SHPRICE" ""
"AUT"   5 "IDX2010" 13.13226 "SHPRICE" ""
"AUT"   6 "IDX2010" 14.86791 "SHPRICE" ""
"AUT"   7 "IDX2010" 15.72758 "SHPRICE" ""
"AUT"   8 "IDX2010" 16.78735 "SHPRICE" ""
"AUT"   9 "IDX2010" 15.24142 "SHPRICE" ""
"AUT"  10 "IDX2010" 13.15004 "SHPRICE" ""
"AUT"  11 "IDX2010" 12.62683 "SHPRICE" ""
"AUT"  12 "IDX2010" 12.50381 "SHPRICE" ""
"AUT"  13 "IDX2010"  12.1466 "SHPRICE" ""
"AUT"  14 "IDX2010" 11.49591 "SHPRICE" ""
"AUT"  15 "IDX2010" 11.50629 "SHPRICE" ""
"AUT"  16 "IDX2010" 11.60708 "SHPRICE" ""
"AUT"  17 "IDX2010" 11.22467 "SHPRICE" ""
"AUT"  18 "IDX2010" 11.11202 "SHPRICE" ""
"AUT"  19 "IDX2010" 11.39364 "SHPRICE" ""
"AUT"  20 "IDX2010" 11.16835 "SHPRICE" ""
"AUT"  21 "IDX2010" 10.96084 "SHPRICE" ""
"AUT"  22 "IDX2010" 10.67033 "SHPRICE" ""
"AUT"  23 "IDX2010" 10.58584 "SHPRICE" ""
"AUT"  24 "IDX2010" 10.49395 "SHPRICE" ""
"AUT"  25 "IDX2010" 10.64661 "SHPRICE" ""
"AUT"  26 "IDX2010" 10.27458 "SHPRICE" ""
"AUT"  27 "IDX2010" 9.843264 "SHPRICE" ""
"AUT"  28 "IDX2010" 9.598701 "SHPRICE" ""
"AUT"  29 "IDX2010" 9.500876 "SHPRICE" ""
"AUT"  30 "IDX2010" 9.588326 "SHPRICE" ""
"AUT"  31 "IDX2010" 10.32053 "SHPRICE" ""
"AUT"  32 "IDX2010" 10.51714 "SHPRICE" ""
"AUT"  33 "IDX2010" 10.27895 "SHPRICE" ""
"AUT"  34 "IDX2010" 10.28279 "SHPRICE" ""
"AUT"  35 "IDX2010" 10.22734 "SHPRICE" ""
"AUT"  36 "IDX2010" 10.28802 "SHPRICE" ""
"AUT"  37 "IDX2010"  10.1011 "SHPRICE" ""
"AUT"  38 "IDX2010" 10.15132 "SHPRICE" ""
"AUT"  39 "IDX2010" 10.85227 "SHPRICE" ""
"AUT"  40 "IDX2010" 11.10755 "SHPRICE" ""
"AUT"  41 "IDX2010" 11.18183 "SHPRICE" ""
"AUT"  42 "IDX2010" 11.89569 "SHPRICE" ""
"AUT"  43 "IDX2010" 12.02472 "SHPRICE" ""
"AUT"  44 "IDX2010" 11.85628 "SHPRICE" ""
"AUT"  45 "IDX2010" 11.93823 "SHPRICE" ""
"AUT"  46 "IDX2010" 11.69551 "SHPRICE" ""
"AUT"  47 "IDX2010" 11.44582 "SHPRICE" ""
"AUT"  48 "IDX2010" 11.49987 "SHPRICE" ""
"AUT"  49 "IDX2010" 12.03169 "SHPRICE" ""
"AUT"  50 "IDX2010" 13.58565 "SHPRICE" ""
"AUT"  51 "IDX2010" 13.90963 "SHPRICE" ""
"AUT"  52 "IDX2010"  14.8418 "SHPRICE" ""
"AUT"  53 "IDX2010" 15.62087 "SHPRICE" ""
"AUT"  54 "IDX2010" 15.54729 "SHPRICE" ""
"AUT"  55 "IDX2010" 14.47632 "SHPRICE" ""
"AUT"  56 "IDX2010"  14.6887 "SHPRICE" ""
"AUT"  57 "IDX2010" 14.65697 "SHPRICE" ""
"AUT"  58 "IDX2010" 14.07423 "SHPRICE" ""
"AUT"  59 "IDX2010" 13.76455 "SHPRICE" ""
"AUT"  60 "IDX2010" 14.16316 "SHPRICE" ""
"AUT"  61 "IDX2010" 14.33788 "SHPRICE" ""
"AUT"  62 "IDX2010" 14.16072 "SHPRICE" ""
"AUT"  63 "IDX2010" 14.20361 "SHPRICE" ""
"AUT"  64 "IDX2010" 14.61895 "SHPRICE" ""
"AUT"  65 "IDX2010" 14.61093 "SHPRICE" ""
"AUT"  66 "IDX2010" 14.37903 "SHPRICE" ""
"AUT"  67 "IDX2010" 14.11329 "SHPRICE" ""
"AUT"  68 "IDX2010" 14.01774 "SHPRICE" ""
"AUT"  69 "IDX2010" 13.92637 "SHPRICE" ""
"AUT"  70 "IDX2010"  13.5717 "SHPRICE" ""
"AUT"  71 "IDX2010" 12.70126 "SHPRICE" ""
"AUT"  72 "IDX2010"  12.6622 "SHPRICE" ""
"AUT"  73 "IDX2010" 12.56386 "SHPRICE" ""
"AUT"  74 "IDX2010" 12.79472 "SHPRICE" ""
"AUT"  75 "IDX2010" 12.68522 "SHPRICE" ""
"AUT"  76 "IDX2010" 12.49969 "SHPRICE" ""
"AUT"  77 "IDX2010" 12.81565 "SHPRICE" ""
"AUT"  78 "IDX2010" 12.63675 "SHPRICE" ""
"AUT"  79 "IDX2010" 13.15706 "SHPRICE" ""
"AUT"  80 "IDX2010" 13.58007 "SHPRICE" ""
"AUT"  81 "IDX2010" 13.34154 "SHPRICE" ""
"AUT"  82 "IDX2010" 13.16996 "SHPRICE" ""
"AUT"  83 "IDX2010" 13.01757 "SHPRICE" ""
"AUT"  84 "IDX2010" 12.64337 "SHPRICE" ""
"AUT"  85 "IDX2010" 12.23884 "SHPRICE" ""
"AUT"  86 "IDX2010" 11.57834 "SHPRICE" ""
"AUT"  87 "IDX2010" 11.17032 "SHPRICE" ""
"AUT"  88 "IDX2010" 11.11731 "SHPRICE" ""
"AUT"  89 "IDX2010"  10.7351 "SHPRICE" ""
"AUT"  90 "IDX2010" 10.24478 "SHPRICE" ""
"AUT"  91 "IDX2010"   10.197 "SHPRICE" ""
"AUT"  92 "IDX2010"  10.6099 "SHPRICE" ""
"AUT"  93 "IDX2010" 11.68819 "SHPRICE" ""
"AUT"  94 "IDX2010" 11.61182 "SHPRICE" ""
"AUT"  95 "IDX2010" 11.55741 "SHPRICE" ""
"AUT"  96 "IDX2010" 11.66413 "SHPRICE" ""
"AUT"  97 "IDX2010" 11.62158 "SHPRICE" ""
"AUT"  98 "IDX2010" 11.49115 "SHPRICE" ""
"AUT"  99 "IDX2010" 12.16875 "SHPRICE" ""
"AUT" 100 "IDX2010"  13.7942 "SHPRICE" ""
"AUT" 101 "IDX2010" 21.72407 "SHPRICE" ""
"AUT" 102 "IDX2010" 24.41282 "SHPRICE" ""
"AUT" 103 "IDX2010" 26.33609 "SHPRICE" ""
"AUT" 104 "IDX2010" 28.53102 "SHPRICE" ""
"AUT" 105 "IDX2010" 28.43722 "SHPRICE" ""
"AUT" 106 "IDX2010" 27.97375 "SHPRICE" ""
"AUT" 107 "IDX2010" 27.48029 "SHPRICE" ""
"AUT" 108 "IDX2010" 24.95092 "SHPRICE" ""
"AUT" 109 "IDX2010" 22.94046 "SHPRICE" ""
"AUT" 110 "IDX2010" 24.57324 "SHPRICE" ""
"AUT" 111 "IDX2010"   23.081 "SHPRICE" ""
"AUT" 112 "IDX2010" 20.82817 "SHPRICE" ""
"AUT" 113 "IDX2010" 21.50019 "SHPRICE" ""
"AUT" 114 "IDX2010" 23.16993 "SHPRICE" ""
"AUT" 115 "IDX2010" 25.34045 "SHPRICE" ""
"AUT" 116 "IDX2010" 27.60339 "SHPRICE" ""
"AUT" 117 "IDX2010" 36.64957 "SHPRICE" ""
"AUT" 118 "IDX2010" 43.70761 "SHPRICE" ""
"AUT" 119 "IDX2010" 49.22215 "SHPRICE" ""
"AUT" 120 "IDX2010" 69.01772 "SHPRICE" ""
"AUT" 121 "IDX2010" 69.35355 "SHPRICE" ""
"AUT" 122 "IDX2010" 66.38582 "SHPRICE" ""
"AUT" 123 "IDX2010" 54.12257 "SHPRICE" ""
"AUT" 124 "IDX2010" 53.18656 "SHPRICE" ""
"AUT" 125 "IDX2010" 60.60519 "SHPRICE" ""
"AUT" 126 "IDX2010" 55.34732 "SHPRICE" ""
"AUT" 127 "IDX2010" 46.54945 "SHPRICE" ""
"AUT" 128 "IDX2010" 48.56095 "SHPRICE" ""
"AUT" 129 "IDX2010" 46.71823 "SHPRICE" ""
"AUT" 130 "IDX2010" 39.41887 "SHPRICE" ""
"AUT" 131 "IDX2010"  36.5997 "SHPRICE" ""
"AUT" 132 "IDX2010" 37.77877 "SHPRICE" ""
"AUT" 133 "IDX2010" 38.40614 "SHPRICE" ""
"AUT" 134 "IDX2010" 43.40107 "SHPRICE" ""
"AUT" 135 "IDX2010" 47.64447 "SHPRICE" ""
"AUT" 136 "IDX2010" 51.63853 "SHPRICE" ""
"AUT" 137 "IDX2010" 48.32729 "SHPRICE" ""
"AUT" 138 "IDX2010" 47.52625 "SHPRICE" ""
"AUT" 139 "IDX2010" 44.36532 "SHPRICE" ""
"AUT" 140 "IDX2010" 42.47902 "SHPRICE" ""
"AUT" 141 "IDX2010" 41.25949 "SHPRICE" ""
"AUT" 142 "IDX2010" 42.76114 "SHPRICE" ""
"AUT" 143 "IDX2010" 39.69925 "SHPRICE" ""
"AUT" 144 "IDX2010" 42.89436 "SHPRICE" ""
"AUT" 145 "IDX2010" 45.14091 "SHPRICE" ""
"AUT" 146 "IDX2010" 42.35905 "SHPRICE" ""
"AUT" 147 "IDX2010" 43.81188 "SHPRICE" ""
"AUT" 148 "IDX2010" 47.09312 "SHPRICE" ""
"AUT" 149 "IDX2010" 48.33532 "SHPRICE" ""
"AUT" 150 "IDX2010" 51.96285 "SHPRICE" ""
"AUT" 151 "IDX2010" 49.71421 "SHPRICE" ""
"AUT" 152 "IDX2010" 54.26555 "SHPRICE" ""
"AUT" 153 "IDX2010" 63.18339 "SHPRICE" ""
"AUT" 154 "IDX2010" 56.93023 "SHPRICE" ""
"AUT" 155 "IDX2010" 47.67237 "SHPRICE" ""
"AUT" 156 "IDX2010" 48.59896 "SHPRICE" ""
"AUT" 157 "IDX2010" 51.44394 "SHPRICE" ""
"AUT" 158 "IDX2010" 51.31525 "SHPRICE" ""
"AUT" 159 "IDX2010" 49.55589 "SHPRICE" ""
"AUT" 160 "IDX2010"  49.8823 "SHPRICE" ""
"AUT" 161 "IDX2010" 50.11282 "SHPRICE" ""
"AUT" 162 "IDX2010" 50.65649 "SHPRICE" ""
"AUT" 163 "IDX2010" 48.58257 "SHPRICE" ""
"AUT" 164 "IDX2010" 50.01587 "SHPRICE" ""
"AUT" 165 "IDX2010" 51.51612 "SHPRICE" ""
"AUT" 166 "IDX2010" 50.67742 "SHPRICE" ""
"AUT" 167 "IDX2010" 47.23296 "SHPRICE" ""
"AUT" 168 "IDX2010" 50.62301 "SHPRICE" ""
"AUT" 169 "IDX2010" 54.21638 "SHPRICE" ""
"AUT" 170 "IDX2010" 49.35432 "SHPRICE" ""
"AUT" 171 "IDX2010" 47.91404 "SHPRICE" ""
"AUT" 172 "IDX2010" 50.69311 "SHPRICE" ""
"AUT" 173 "IDX2010" 54.78551 "SHPRICE" ""
"AUT" 174 "IDX2010"  57.6263 "SHPRICE" ""
"AUT" 175 "IDX2010" 61.79194 "SHPRICE" ""
"AUT" 176 "IDX2010" 72.68954 "SHPRICE" ""
"AUT" 177 "IDX2010" 78.00496 "SHPRICE" ""
"AUT" 178 "IDX2010" 81.55228 "SHPRICE" ""
"AUT" 179 "IDX2010" 90.06211 "SHPRICE" ""
"AUT" 180 "IDX2010"  103.026 "SHPRICE" ""
"AUT" 181 "IDX2010" 109.0594 "SHPRICE" ""
"AUT" 182 "IDX2010" 125.5493 "SHPRICE" ""
"AUT" 183 "IDX2010" 131.8084 "SHPRICE" ""
"AUT" 184 "IDX2010" 150.8971 "SHPRICE" ""
"AUT" 185 "IDX2010" 150.5784 "SHPRICE" ""
"AUT" 186 "IDX2010" 147.0453 "SHPRICE" ""
"AUT" 187 "IDX2010" 163.8554 "SHPRICE" ""
"AUT" 188 "IDX2010" 180.5207 "SHPRICE" ""
"AUT" 189 "IDX2010" 190.7986 "SHPRICE" ""
"AUT" 190 "IDX2010" 182.3523 "SHPRICE" ""
"AUT" 191 "IDX2010" 176.2264 "SHPRICE" ""
"AUT" 192 "IDX2010" 153.6762 "SHPRICE" ""
"AUT" 193 "IDX2010" 161.4425 "SHPRICE" ""
"AUT" 194 "IDX2010" 135.8335 "SHPRICE" ""
"AUT" 195 "IDX2010" 74.13644 "SHPRICE" ""
"AUT" 196 "IDX2010" 63.89027 "SHPRICE" ""
"AUT" 197 "IDX2010" 77.15126 "SHPRICE" ""
"AUT" 198 "IDX2010" 90.77911 "SHPRICE" ""
"AUT" 199 "IDX2010" 100.0045 "SHPRICE" ""
"AUT" 200 "IDX2010" 97.67952 "SHPRICE" ""
"AUT" 201 "IDX2010" 98.11928 "SHPRICE" ""
"AUT" 202 "IDX2010" 96.73898 "SHPRICE" ""
"AUT" 203 "IDX2010" 107.4622 "SHPRICE" ""
"AUT" 204 "IDX2010"  115.465 "SHPRICE" ""
"AUT" 205 "IDX2010" 112.6556 "SHPRICE" ""
"AUT" 206 "IDX2010" 95.39391 "SHPRICE" ""
"AUT" 207 "IDX2010" 79.94776 "SHPRICE" ""
"AUT" 208 "IDX2010" 88.47083 "SHPRICE" ""
"AUT" 209 "IDX2010"  83.8501 "SHPRICE" ""
"AUT" 210 "IDX2010" 85.10485 "SHPRICE" ""
"AUT" 211 "IDX2010" 92.01467 "SHPRICE" ""
"AUT" 212 "IDX2010" 98.94403 "SHPRICE" ""
"AUT" 213 "IDX2010" 96.70724 "SHPRICE" ""
"AUT" 214 "IDX2010" 96.53881 "SHPRICE" ""
"AUT" 215 "IDX2010" 101.6663 "SHPRICE" ""
"AUT" 216 "IDX2010" 103.0253 "SHPRICE" ""
"AUT" 217 "IDX2010" 101.1086 "SHPRICE" ""
"AUT" 218 "IDX2010" 95.66279 "SHPRICE" ""
"AUT" 219 "IDX2010"  89.4996 "SHPRICE" ""
"AUT" 220 "IDX2010" 95.41937 "SHPRICE" ""
"AUT" 221 "IDX2010" 103.2056 "SHPRICE" ""
"AUT" 222 "IDX2010" 96.56496 "SHPRICE" ""
"AUT" 223 "IDX2010" 97.48701 "SHPRICE" ""
"AUT" 224 "IDX2010" 90.13639 "SHPRICE" ""
"AUT" 225 "IDX2010" 93.03716 "SHPRICE" ""
"AUT" 226 "IDX2010" 94.33934 "SHPRICE" ""
"AUT" 227 "IDX2010" 103.2164 "SHPRICE" ""
"AUT" 228 "IDX2010" 114.3543 "SHPRICE" ""
"AUT" 229 "IDX2010" 125.3572 "SHPRICE" ""
"AUT" 230 "IDX2010" 132.1798 "SHPRICE" ""
"AUT" 231 "IDX2010" 137.7181 "SHPRICE" ""
"AUT" 232 "IDX2010" 142.3793 "SHPRICE" ""
end
format %tq Time
    Does anyone know how to merge these 2 datasets that have different country codes/abbreviations?

    Thank you very much.
    Tags: None
  • #2
    I guess these country codes follow some international standard. You could get a conversion table for these two standards. In your case something like this: https://en.wikipedia.org/wiki/ISO_3166-1#Current_codes
    You merge the conversion table to the first dataset. And then you merge the second dataset using the additional country identifier that is in now in your data.

    I hope that helps! Best, Christoph
    • 1 like

    Comment

    • #3
      The user-written kountry may be useful.

      Code:
      ssc install kountry

clear
input str2 Country_Code str14 Country int Time double Cred_GDP_Gap
"AT" "Austria"   156  -1.3
...
"BE" "Belgium"   231 -10.1
end
format %tq Time

sort Country_Code Time
save data1, replace

clear
input str4 Country float Time str7 measure float equity_price str7 indicator str1 flagcodes
"AUS"  -8 "IDX2010" 2.997673 "SHPRICE" ""
...
"AUT" 232 "IDX2010" 142.3793 "SHPRICE" ""
end
format %tq Time

kountry Country, from(iso3c) to(iso2c) marker
tab MARKER
rename _ISO2C_ Country_Code
sort Country_Code Time

merge Country_Code Time using data1
      • 1 like

      Comment

      • #4
        Originally posted by Christoph Halbmeier View Post
        I guess these country codes follow some international standard. You could get a conversion table for these two standards. In your case something like this: https://en.wikipedia.org/wiki/ISO_3166-1#Current_codes
        You merge the conversion table to the first dataset. And then you merge the second dataset using the additional country identifier that is in now in your data.

        I hope that helps! Best, Christoph
        Thank you very much for your help,Christoph. It does helps.

        Comment

        • #5
          Originally posted by Rafal Raciborski (StataCorp) View Post
          The user-written kountry may be useful.

          Code:
          ssc install kountry

clear
input str2 Country_Code str14 Country int Time double Cred_GDP_Gap
"AT" "Austria" 156 -1.3
...
"BE" "Belgium" 231 -10.1
end
format %tq Time

sort Country_Code Time
save data1, replace

clear
input str4 Country float Time str7 measure float equity_price str7 indicator str1 flagcodes
"AUS" -8 "IDX2010" 2.997673 "SHPRICE" ""
...
"AUT" 232 "IDX2010" 142.3793 "SHPRICE" ""
end
format %tq Time

kountry Country, from(iso3c) to(iso2c) marker
tab MARKER
rename _ISO2C_ Country_Code
sort Country_Code Time

merge Country_Code Time using data1
          Thank you very much for your help, Rafal.It is very helpful.

          Comment

          Previous Next
          Working...
          X