Announcement

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

    Unique identifier for firms (panel dataset)

    Hi all
    I am trying to generate a unique identifier for firms but a little bit confused on how to do it. I have panel dataset from WBES on firms across 4 years for 3 countries. There is a provided unique-identifier for each firm (idstd) in WBES dataset but that differs across years for same firm, and so I cant use it identify firm as panel unit in xtset, I also have a panel_id for each firm. So could someone help me with coding unique identifier in a way that best identify firm in xtset.
    Thanks a lot in advance
    here is my data:

    input float EE byte(MM bankaccount R_D human_capital) float exporter str8 country float(year unique_id_01)
    .02419355 . 0 . . 0 "uganda" 2006 135
    . . 1 . . 0 "uganda" 2006 374
    .02488336 . 1 . . 0 "Tanzania" 2006 2105
    . . 1 . . 0 "uganda" 2006 434
    .10666667 . 1 . . 0 "Tanzania" 2006 2076
    .005066667 . 1 . . 0 "Tanzania" 2006 2235
    .035555556 . 1 . . 0 "uganda" 2006 221
    .07333333 . 1 . . 1 "Tanzania" 2006 2019
    .033333335 . 1 . . 0 "uganda" 2006 224
    .12 . 1 . . 0 "uganda" 2006 27
    .023893805 . 1 . . 0 "Tanzania" 2006 2232
    .00024666666 . 1 . . 0 "Tanzania" 2006 2231
    .02777778 . 1 . . 0 "uganda" 2006 181
    . . 1 . . 0 "Tanzania" 2006 2281
    . . 1 . . 0 "uganda" 2006 562
    . . 1 . . 0 "Tanzania" 2006 2325
    .033333335 . 1 . . 0 "uganda" 2006 214
    .08097687 . 1 . . 0 "Tanzania" 2006 2213
    . . 0 . . 0 "uganda" 2006 538
    .0044230768 . 1 . . 0 "Tanzania" 2006 2220
    . . 1 . . 0 "Tanzania" 2006 2341
    .0022413793 . 1 . . 0 "Tanzania" 2006 2218
    . . 1 . . 0 "Tanzania" 2006 2297
    . . 1 . . 0 "uganda" 2006 473
    .02510638 . 1 . . 0 "Tanzania" 2006 2129
    . . 1 . . 0 "uganda" 2006 447
    .012777777 . 1 . . 0 "uganda" 2006 16
    . . 1 . . 0 "Tanzania" 2006 2417
    .02758333 . . . . 0 "uganda" 2006 8
    . . 1 . . 0 "uganda" 2006 469
    . . 1 . . 0 "uganda" 2006 222
    .036 . 1 . . 0 "uganda" 2006 43
    . . 1 . . 0 "Tanzania" 2006 2415
    . . 1 . . 0 "uganda" 2006 552
    .0016875 . 1 . . 0 "uganda" 2006 140
    .14117648 . 1 . . 0 "uganda" 2006 307
    . . 0 . . 0 "uganda" 2006 393
    .015384615 . 1 . . 0 "Tanzania" 2006 2201
    . . 1 . . 0 "Tanzania" 2006 2413
    .056 . 1 . . 0 "Tanzania" 2006 2117
    . . 1 . . 0 "Tanzania" 2006 2307
    .00793 . 1 . . 0 "uganda" 2006 220
    .0378125 . 1 . . 0 "uganda" 2006 83
    .02830022 . 1 . . 0 "uganda" 2006 79
    . . 1 . . 0 "uganda" 2006 543
    .0003788295 . 1 . . 0 "uganda" 2006 147
    . . 1 . . 0 "Tanzania" 2006 2412
    .036363635 . . . . 0 "uganda" 2006 4
    .015 . 1 . . 0 "uganda" 2006 293
    .06315789 . 1 . . 0 "Tanzania" 2006 2183
    . . 1 . . 0 "uganda" 2006 316
    .0085 . 1 . . 0 "uganda" 2006 211
    . . 1 . . 0 "uganda" 2006 394
    . . 1 . . 0 "uganda" 2006 313
    . . 0 . . 0 "Tanzania" 2006 2308
    . . 1 . . 0 "Tanzania" 2006 2001
    . . 1 . . 0 "Tanzania" 2006 2373
    .005278226 . 1 . . 0 "uganda" 2006 92
    .01084944 . 1 . . 0 "uganda" 2006 40
    .0025 . 1 . . 0 "uganda" 2006 26
    . . 1 . . 0 "uganda" 2006 58
    .002142857 . 1 . . 0 "Tanzania" 2006 2027
    . . 0 . . 0 "uganda" 2006 460
    .05147059 . 0 . . 0 "uganda" 2006 93
    .03783102 . 1 . . 0 "Tanzania" 2006 2066
    .005434783 . 1 . . 0 "Tanzania" 2006 2219
    .05714286 . 1 . . 0 "Tanzania" 2006 2149
    .004 . 1 . . 0 "Tanzania" 2006 2035
    . . 1 . . 0 "uganda" 2006 383
    .04384615 . 1 . . 0 "Tanzania" 2006 2207
    . . 1 . . 0 "uganda" 2006 366
    .01967213 . 1 . . 0 "Tanzania" 2006 2202
    . . 1 . . 0 "Tanzania" 2006 2326
    . . 1 . . 0 "uganda" 2006 325
    . . 0 . . 0 "uganda" 2006 314
    . . 1 . . 0 "uganda" 2006 426
    . . 1 . . 0 "Tanzania" 2006 2331
    . . 0 . . 0 "Tanzania" 2006 2332
    .03 . 1 . . 0 "Tanzania" 2006 2186
    . . 1 . . 0 "Tanzania" 2006 2345
    .008888889 . 1 . . 0 "uganda" 2006 245
    . . 1 . . 0 "Tanzania" 2006 2390
    .015652174 . 1 . . 0 "uganda" 2006 215
    .02777778 . 1 . . 0 "uganda" 2006 115
    . . 0 . . 0 "Tanzania" 2006 2340
    .032470588 . 1 . . 0 "Tanzania" 2006 2095
    . . 1 . . 0 "Tanzania" 2006 2348
    .07081138 . 1 . . 0 "Tanzania" 2006 2185
    . . 0 . . 0 "Tanzania" 2006 2405
    .024 . 0 . . 0 "Tanzania" 2006 2088
    . . 1 . . 0 "Tanzania" 2006 2355
    . . 1 . . 0 "Tanzania" 2006 2356
    . . 1 . . 0 "Tanzania" 2006 2357
    . . 1 . . 0 "Tanzania" 2006 2303
    . . 1 . . 0 "uganda" 2006 357
    .0026 . 0 . . 1 "Tanzania" 2006 2257
    .073846154 . 1 . . 0 "Tanzania" 2006 2057
    .028328214 . 1 . . 0 "uganda" 2006 28
    . . 1 . . 0 "uganda" 2006 362
    .007512755 . 1 . . 0 "Tanzania" 2006 2253
    .26785713 . 1 . . 0 "uganda" 2006 302
    . . 1 . . 0 "uganda" 2006 486
    .005714286 . 1 . . 0 "Tanzania" 2006 2032
    .003140979 . 1 . . 1 "uganda" 2006 248
    .05545454 . 1 . . 0 "Tanzania" 2006 2137
    .025 . 1 . . 0 "Tanzania" 2006 2133
    . . 1 . . 0 "uganda" 2006 412
    . . 1 . . 0 "uganda" 2006 368
    .007857143 . 0 . . 0 "uganda" 2006 84
    . . 1 . . 0 "uganda" 2006 390
    .031927735 . 1 . . 0 "uganda" 2006 42
    .01 . 1 . . 0 "uganda" 2006 5
    . . 1 . . 0 "uganda" 2006 371
    . . 1 . . 0 "Tanzania" 2006 2299
    . . 1 . . 0 "uganda" 2006 415
    .03032491 . 1 . . 1 "Tanzania" 2006 2224
    .11333334 . 1 . . 0 "Tanzania" 2006 2268
    .04216216 . 0 . . 0 "uganda" 2006 114
    . . 1 . . 0 "Tanzania" 2006 2350
    . . 1 . . 0 "uganda" 2006 375
    . . 1 . . 0 "uganda" 2006 475
    . . 1 . . 0 "uganda" 2006 318
    .14604463 . 1 . . 0 "Tanzania" 2006 2041
    . . 1 . . 0 "Tanzania" 2006 2418
    . . 1 . . 0 "uganda" 2006 381
    .034444444 . 1 . . 0 "uganda" 2006 112
    .005882353 . 1 . . 0 "uganda" 2006 127
    .1 . . . . 0 "uganda" 2006 260
    .0024 . 1 . . 1 "Tanzania" 2006 2180
    .04878049 . 0 . . 0 "uganda" 2006 203
    . . 1 . . 0 "uganda" 2006 382
    . . 1 . . 0 "uganda" 2006 331
    . . 1 . . 0 "Tanzania" 2006 2377
    .18333334 . 1 . . 1 "Tanzania" 2006 2266
    .008571428 . 1 . . 0 "Tanzania" 2006 2200
    .003157895 . 0 . . 0 "Tanzania" 2006 2163
    .01375 . 1 . . 0 "uganda" 2006 67
    .036169186 . 1 . . 0 "Tanzania" 2006 2230
    .027508514 . 1 . . 0 "uganda" 2006 71
    .03515625 . 1 . . 0 "uganda" 2006 280
    .08 . 0 . . 0 "uganda" 2006 200
    . . 1 . . 0 "uganda" 2006 373
    . . 0 . . 0 "Tanzania" 2006 2382
    .0252 . 1 . . 0 "Tanzania" 2006 2073
    .1734104 . 1 . . 0 "uganda" 2006 236
    . . 1 . . 0 "Tanzania" 2006 2075
    . . 1 . . 0 "uganda" 2006 333
    . . 1 . . 0 "uganda" 2006 345
    .03758865 . 1 . . 0 "Tanzania" 2006 2246
    . . 0 . . 0 "uganda" 2006 387
    . . 1 . . 0 "Tanzania" 2006 2397
    . . 1 . . 0 "uganda" 2006 444
    . . 1 . . 0 "uganda" 2006 330
    .10428572 . 1 . . 1 "uganda" 2006 13
    . . 1 . . 0 "uganda" 2006 404
    . . 0 . . 0 "Tanzania" 2006 2349
    .018666666 . 1 . . 0 "uganda" 2006 150
    . . 0 . . 0 "Tanzania" 2006 2359
    .0176 . 0 . . 0 "Tanzania" 2006 2176
    . . 1 . . 0 "Tanzania" 2006 2402
    .012 . 0 . . 0 "uganda" 2006 261
    .00021980295 . 1 . . 0 "uganda" 2006 146
    .08494502 . 1 . . 0 "Tanzania" 2006 2214
    . . 1 . . 0 "Tanzania" 2006 2313
    . . 1 . . 0 "Tanzania" 2006 2287
    .024896266 . 1 . . 0 "uganda" 2006 286
    .016666668 . 1 . . 0 "uganda" 2006 104
    .0305 . 1 . . 0 "Tanzania" 2006 2061
    .02722222 . 1 . . 0 "uganda" 2006 288
    .0075 . 1 . . 0 "Tanzania" 2006 2191
    . . 1 . . 0 "uganda" 2006 471
    .04779686 . 1 . . 0 "Tanzania" 2006 2112
    .014816754 . 0 . . 0 "uganda" 2006 108
    . . 0 . . 0 "Tanzania" 2006 2351
    . . 1 . . 0 "uganda" 2006 508
    .04931298 . 1 . . 0 "Tanzania" 2006 2247
    .03125 . 1 . . 0 "uganda" 2006 45
    . . 1 . . 0 "uganda" 2006 378
    . . 1 . . 0 "Tanzania" 2006 2408
    .0125 . 1 . . 0 "uganda" 2006 68
    .03075 . 1 . . 0 "Tanzania" 2006 2104
    .015748031 . 1 . . 1 "uganda" 2006 247
    .23214285 . 1 . . 0 "uganda" 2006 3
    . . 1 . . 0 "uganda" 2006 502
    . . 1 . . 0 "uganda" 2006 320
    . . 1 . . 0 "uganda" 2006 501
    .03157895 . 1 . . 0 "Tanzania" 2006 2100
    .04020275 . 1 . . 0 "Tanzania" 2006 2099
    .0195 . 1 . . 0 "uganda" 2006 95
    .0875 . 0 . . 0 "Tanzania" 2006 2217
    . . 1 . . 0 "Tanzania" 2006 2337
    .023809524 . 1 . . 0 "Tanzania" 2006 2242
    .084 . 1 . . 0 "Tanzania" 2006 2103
    .01942446 . 0 . . 0 "uganda" 2006 306
    .02109705 . 1 . . 0 "Tanzania" 2006 2011
    .12 . 1 . . 0 "uganda" 2006 296
    .016033359 . 1 . . 0 "uganda" 2006 55
    .023592396 . . . . 0 "uganda" 2006 162
    .0040571243 . 1 . . 0 "Tanzania" 2006 2178
    .009087883 . 0 . . 0 "Tanzania" 2006 2262
    .02522449 . 1 . . 0 "Tanzania" 2006 2172
    . . 1 . . 0 "uganda" 2006 317
    .0336 . 1 . . 0 "Tanzania" 2006 2060
    .13 . 1 . . 0 "uganda" 2006 15
    . . 1 . . 0 "uganda" 2006 340
    . . 1 . . 0 "Tanzania" 2006 2396
    .02 . 1 . . 0 "uganda" 2006 118
    .06114769 . 1 . . 0 "uganda" 2006 189
    . . 1 . . 0 "uganda" 2006 409
    . . 0 . . 0 "uganda" 2006 500
    . . 0 . . 0 "Tanzania" 2006 2366
    .010344828 . 1 . . 0 "uganda" 2006 37
    . . 1 . . 0 "uganda" 2006 545
    . . 0 . . 0 "uganda" 2006 379
    .10857143 . 1 . . 1 "uganda" 2006 47
    .037142858 . 1 . . 1 "uganda" 2006 268
    . . 1 . . 0 "uganda" 2006 474
    . . 1 . . 0 "Tanzania" 2006 2285
    .028 . 1 . . 0 "Tanzania" 2006 2043
    . . 1 . . 0 "Tanzania" 2006 2334
    .021 . 1 . . 0 "Tanzania" 2006 2205
    . . 1 . . 0 "uganda" 2006 406
    .0576 . 1 . . 0 "uganda" 2006 99
    . . 1 . . 0 "Tanzania" 2006 2318
    .04285714 . 1 . . 0 "uganda" 2006 44
    . . 1 . . 0 "Tanzania" 2006 2416
    .0447 . 1 . . 0 "Tanzania" 2006 2151
    .05090909 . 0 . . 0 "Tanzania" 2006 2156
    .17258064 . 1 . . 0 "uganda" 2006 63
    . . 1 . . 0 "uganda" 2006 425
    .1764706 . 1 . . 0 "uganda" 2006 291
    .0044444446 . 1 . . 0 "Tanzania" 2006 2036
    .029310346 . 1 . . 0 "Tanzania" 2006 2101
    .044 . 1 . . 0 "Tanzania" 2006 2210
    .0045454544 . 1 . . 0 "uganda" 2006 97
    . . 1 . . 0 "uganda" 2006 529
    . . 1 . . 0 "uganda" 2006 461
    .015454546 . 1 . . 0 "Tanzania" 2006 2157
    . . 0 . . 0 "uganda" 2006 360
    . . 1 . . 0 "uganda" 2006 429
    . . 0 . . 0 "uganda" 2006 117
    .07777778 . 1 . . 0 "uganda" 2006 72
    .15 . 1 . . 0 "uganda" 2006 34
    . . 1 . . 0 "uganda" 2006 472
    . . 1 . . 0 "uganda" 2006 556
    .05227273 . . . . 0 "uganda" 2006 201
    .005555556 . 0 . . 0 "Tanzania" 2006 2030
    . . 1 . . 0 "uganda" 2006 470
    .024 . 1 . . 0 "Tanzania" 2006 2198
    . . 0 . . 0 "uganda" 2006 524
    .09444445 . 1 . . 0 "uganda" 2006 225
    . . 1 . . 0 "Tanzania" 2006 2279
    .002962963 . 1 . . 1 "Tanzania" 2006 2018
    .0306572 . 1 . . 0 "Tanzania" 2006 2009
    . . 1 . . 0 "Tanzania" 2006 2298
    . . 1 . . 0 "uganda" 2006 531
    .007017544 . 0 . . 0 "Tanzania" 2006 2033
    .065625 . 1 . . 0 "uganda" 2006 275
    . . 1 . . 0 "Tanzania" 2006 2336
    . . 1 . . 0 "uganda" 2006 439
    .029649124 . 1 . . 0 "uganda" 2006 87
    .0009473684 . 1 . . 0 "uganda" 2006 171
    .05398111 . 1 . . 0 "Tanzania" 2006 2016
    . . 1 . . 0 "Tanzania" 2006 2131
    .028 . 1 . . 0 "Tanzania" 2006 2063
    .01111111 . 1 . . 0 "uganda" 2006 39
    .06818182 . 1 . . 0 "Tanzania" 2006 2008
    .010555555 . 1 . . 0 "uganda" 2006 173
    .10738916 . 1 . . 0 "uganda" 2006 305
    . . 1 . . 0 "Tanzania" 2006 2312
    . . 1 . . 0 "Tanzania" 2006 2339
    . . 1 . . 0 "uganda" 2006 554
    . . 1 . . 0 "uganda" 2006 349
    .0025 . 0 . . 0 "Tanzania" 2006 2010
    . . 1 . . 0 "uganda" 2006 555
    .04 . 0 . . 0 "uganda" 2006 185
    .005615469 . 1 . . 0 "uganda" 2006 234
    . . 1 . . 0 "Tanzania" 2006 2411
    .0016666667 . 0 . . 0 "Tanzania" 2006 2196
    . . 1 . . 0 "uganda" 2006 443
    . . 0 . . 0 "uganda" 2006 372
    . . 0 . . 0 "Tanzania" 2006 2379
    .016375 . 1 . . 1 "Tanzania" 2006 2034
    . . 1 . . 0 "Tanzania" 2006 2387
    .04329674 . 1 . . 0 "Tanzania" 2006 2140
    . . 1 . . 0 "Tanzania" 2006 2394
    .19444445 . 1 . . 0 "uganda" 2006 138
    . . 1 . . 0 "uganda" 2006 367
    .004625 . 1 . . 0 "uganda" 2006 57
    .027692307 . 1 . . 0 "uganda" 2006 254
    .08 . 1 . . 0 "Tanzania" 2006 2148
    . . 1 . . 0 "Tanzania" 2006 2189
    .011 . 0 . . 0 "Tanzania" 2006 2025
    .04897959 . 1 . . 0 "uganda" 2006 217
    .12727273 . 1 . . 1 "uganda" 2006 153
    . . 1 . . 0 "Tanzania" 2006 2358
    . . 1 . . 0 "Tanzania" 2006 2414
    . . 1 . . 0 "uganda" 2006 403
    .02625 . 1 . . 0 "uganda" 2006 129
    . . 1 . . 0 "Tanzania" 2006 2389
    .08755981 . 1 . . 0 "uganda" 2006 172
    .2988895 . 1 . . 0 "Tanzania" 2006 2184
    .13125 . 1 . . 1 "Tanzania" 2006 2136
    .15652174 . 1 . . 0 "uganda" 2006 292
    . . 1 . . 1 "uganda" 2006 400
    . . 1 . . 0 "Tanzania" 2006 2403
    .003 . 1 . . 0 "Tanzania" 2006 2002
    . . 1 . . 0 "Tanzania" 2006 2386
    . . 1 . . 0 "Kenya" 2007 4586
    . . 1 . . 1 "Kenya" 2007 4090
    . . 1 . . 0 "Kenya" 2007 4242
    . . 1 . . 0 "Kenya" 2007 4384
    . . 0 . . 0 "Kenya" 2007 4401
    . . 1 . . 0 "Kenya" 2007 4082
    .05 . 1 . . 0 "Kenya" 2007 4522
    . . 1 . . 0 "Kenya" 2007 4395
    .12777779 . 1 . . 0 "Kenya" 2007 4076
    . . 1 . . 0 "Kenya" 2007 4443
    . . 1 . . 1 "Kenya" 2007 4054
    . . 1 . . 1 "Kenya" 2007 4338
    . . 1 . . 0 "Kenya" 2007 4455
    .02117007 . 1 . . 0 "Kenya" 2007 4433
    . . 1 . . 0 "Kenya" 2007 4257
    . . 1 . . 1 "Kenya" 2007 4442
    . . 0 . . 0 "Kenya" 2007 4404
    . . 1 . . 1 "Kenya" 2007 4329
    . . 1 . . 0 "Kenya" 2007 4251
    .033834588 . 1 . . 0 "Kenya" 2007 4493
    .1255 . 1 . . 1 "Kenya" 2007 4133
    . . 1 . . 0 "Kenya" 2007 4618
    . . 1 . . 0 "Kenya" 2007 4641
    . . 1 . . 0 "Kenya" 2007 4342
    . . 1 . . 1 "Kenya" 2007 4389
    .0192 . 1 . . 1 "Kenya" 2007 4036
    .0020737327 . 1 . . 0 "Kenya" 2007 4517
    . . 1 . . 0 "Kenya" 2007 4468
    .033333335 . 1 . . 1 "Kenya" 2007 4267
    . . 1 . . 0 "Kenya" 2007 4339
    .02036 . 1 . . 0 "Kenya" 2007 4357
    .025 . 1 . . 0 "Kenya" 2007 4580
    .05618421 . 1 . . 1 "Kenya" 2007 4373
    . . 1 . . 1 "Kenya" 2007 4142
    .024305556 . 1 . . 0 "Kenya" 2007 4055
    . . 1 . . 0 "Kenya" 2007 4651
    .066 . 1 . . 1 "Kenya" 2007 4003
    . . 1 . . 0 "Kenya" 2007 4100
    .01402 . 1 . . 0 "Kenya" 2007 4589
    .007142857 . 1 . . 0 "Kenya" 2007 4592
    . . 1 . . 0 "Kenya" 2007 4334
    .0825 . 1 . . 0 "Kenya" 2007 4030
    . . 1 . . 0 "Kenya" 2007 4353
    . . 1 . . 0 "Kenya" 2007 4017
    .0888889 . 1 . . 1 "Kenya" 2007 4042
    . . 1 . . 1 "Kenya" 2007 4104
    . . 1 . . 0 "Kenya" 2007 4488
    .05361111 . 1 . . 0 "Kenya" 2007 4562
    . . 1 . . 0 "Kenya" 2007 4035
    . . 1 . . 1 "Kenya" 2007 4232
    .053 . 1 . . 0 "Kenya" 2007 4524
    .0345 . 1 . . 0 "Kenya" 2007 4002
    . . 1 . . 1 "Kenya" 2007 4300
    .0175 . 1 . . 0 "Kenya" 2007 4040
    . . 1 . . 1 "Kenya" 2007 4286
    .0225 . 1 . . 0 "Kenya" 2007 4074
    . . 1 . . 0 "Kenya" 2007 4656
    .05833333 . 1 . . 0 "Kenya" 2007 4498
    .055 . 1 . . 1 "Kenya" 2007 4000
    .1857143 . 1 . . 0 "Kenya" 2007 4216
    . . 1 . . 0 "Kenya" 2007 4059
    . . 1 . . 0 "Kenya" 2007 4414
    . . 0 . . 0 "Kenya" 2007 4612
    . . 1 . . 1 "Kenya" 2007 4121
    . . 1 . . 1 "Kenya" 2007 4282
    . . 1 . . 0 "Kenya" 2007 4325
    . . 1 . . 0 "Kenya" 2007 4051
    . . 1 . . 0 "Kenya" 2007 4638
    . . 1 . . 0 "Kenya" 2007 4464
    .00325 . 1 . . 0 "Kenya" 2007 4302
    .11020322 . 1 . . 0 "Kenya" 2007 4519
    . . 1 . . 0 "Kenya" 2007 4491
    . . 1 . . 0 "Kenya" 2007 4124
    . . 1 . . 1 "Kenya" 2007 4343
    .025 . 1 . . 0 "Kenya" 2007 4504
    .023700954 . 0 . . 0 "Kenya" 2007 4555
    . . 1 . . 0 "Kenya" 2007 4597
    . . 0 . . 0 "Kenya" 2007 4405
    .02131579 . 1 . . 1 "Kenya" 2007 4020
    . . 1 . . 1 "Kenya" 2007 4174
    . . 1 . . 0 "Kenya" 2007 4610
    . . 1 . . 0 "Kenya" 2007 4065
    .024615385 . 1 . . 0 "Kenya" 2007 4010
    . . 1 . . 0 "Kenya" 2007 4162
    . . 1 . . 1 "Kenya" 2007 4160
    . . 1 . . 0 "Kenya" 2007 4083
    . . 1 . . 0 "Kenya" 2007 4070
    . . 1 . . 0 "Kenya" 2007 4375
    . . 1 . . 0 "Kenya" 2007 4596
    . . 1 . . 0 "Kenya" 2007 4117
    . . 1 . . 0 "Kenya" 2007 4243
    . . 1 . . 0 "Kenya" 2007 4594
    .0375 . 1 . . 0 "Kenya" 2007 4579
    .03076923 . 1 . . 0 "Kenya" 2007 4496
    .1713062 . 1 . . 1 "Kenya" 2007 4320
    . . 1 . . 0 "Kenya" 2007 4378
    . . 1 . . 0 "Kenya" 2007 4043
    .0106 . 1 . . 1 "Kenya" 2007 4021
    . . 1 . . 1 "Kenya" 2007 4288
    .05215 . 1 . . 0 "Kenya" 2007 4571
    . . 1 . . 0 "Kenya" 2007 4241
    . . 1 . . 0 "Kenya" 2007 4223
    . . 1 . . 1 "Kenya" 2007 4444
    .05625 . 1 . . 0 "Kenya" 2007 4540
    . . 1 . . 0 "Kenya" 2007 4122
    . . 1 . . 0 "Kenya" 2007 4624
    .03 . 0 . . 0 "Kenya" 2007 4502
    .03788462 . 1 . . 0 "Kenya" 2007 4572
    .04 . 1 . . 0 "Kenya" 2007 4430
    . . 1 . . 0 "Kenya" 2007 4441
    . . 1 . . 0 "Kenya" 2007 4461
    . . 1 . . 0 "Kenya" 2007 4391
    . . 1 . . 0 "Kenya" 2007 4435
    . . 1 . . 0 "Kenya" 2007 4203
    . . 1 . . 0 "Kenya" 2007 4644
    . . 1 . . 0 "Kenya" 2007 4556
    .06522551 . 1 . . 0 "Kenya" 2007 4044
    . . 1 . . 0 "Kenya" 2007 4396
    . . 1 . . 1 "Kenya" 2007 4352
    .035971224 . 1 . . 0 "Kenya" 2007 4530
    . . 1 . . 0 "Kenya" 2007 4152
    .007333333 . 1 . . 0 "Kenya" 2007 4497
    .04411765 . 1 . . 0 "Kenya" 2007 4432
    .01250991 . 1 . . 0 "Kenya" 2007 4292
    . . 0 . . 0 "Kenya" 2007 4403
    . . 1 . . 0 "Kenya" 2007 4608
    . . 1 . . 0 "Kenya" 2007 4634
    .164 . 1 . . 0 "Kenya" 2007 4147
    . . 1 . . 1 "Kenya" 2007 4131
    . . 1 . . 0 "Kenya" 2007 4637
    . . 0 . . 0 "Kenya" 2007 4239
    .05 . 1 . . 0 "Kenya" 2007 4066
    . . 1 . . 0 "Kenya" 2007 4409
    .09142857 . 1 . . 0 "Kenya" 2007 4410
    . . 1 . . 0 "Kenya" 2007 4411
    .0612 . 1 . . 0 "Kenya" 2007 4049
    . . 1 . . 0 "Kenya" 2007 4613
    .18333334 . 1 . . 0 "Kenya" 2007 4413
    . . 1 . . 0 "Kenya" 2007 4168
    .04540984 . 1 . . 0 "Kenya" 2007 4574
    . . 1 . . 0 "Kenya" 2007 4138
    . . 1 . . 1 "Kenya" 2007 4252
    . . 1 . . 0 "Kenya" 2007 4457
    .03733333 . 1 . . 0 "Kenya" 2007 4418
    .027857143 . 1 . . 0 "Kenya" 2007 4511
    .002 . 1 . . 1 "Kenya" 2007 4135
    . . 1 . . 0 "Kenya" 2007 4115
    .00425 . 1 . . 0 "Kenya" 2007 4421
    .00738114 . 1 . . 0 "Kenya" 2007 4560
    .32 1 1 0 . 0 "Tanzania" 2013 2954
    . 1 1 0 100 0 "Kenya" 2013 4422
    .000125 0 1 1 70 0 "Tanzania" 2013 2702
    . 1 1 0 50 1 "Tanzania" 2013 2736
    . 1 1 0 100 1 "Kenya" 2013 5035
    . 0 1 1 90 0 "Kenya" 2013 4247
    . 1 1 0 40 0 "Kenya" 2013 4956
    .01225 1 1 1 100 0 "Kenya" 2013 4464
    . 0 0 0 2 0 "Tanzania" 2013 3017
    . 1 1 0 100 0 "Kenya" 2013 5202
    . 1 1 0 100 0 "Kenya" 2013 4766
    . 1 1 0 67 0 "Kenya" 2013 4394
    . 0 1 0 100 0 "Kenya" 2013 4227
    . 1 1 1 100 0 "Kenya" 2013 4706
    . 1 1 0 10 0 "uganda" 2013 565
    .11428571 0 1 0 50 0 "Tanzania" 2013 2809
    . 0 1 1 80 1 "uganda" 2013 795
    . 1 1 0 3 0 "uganda" 2013 897
    . 1 1 0 100 0 "Tanzania" 2013 2679
    . 0 1 1 80 0 "uganda" 2013 849
    . 0 1 0 70 1 "Tanzania" 2013 2804
    . 1 1 0 100 0 "Kenya" 2013 4377
    . 0 1 0 40 0 "uganda" 2013 1025
    . 0 1 0 1 0 "Tanzania" 2013 2810
    .023030303 0 1 0 30 0 "Tanzania" 2013 2182
    . 1 1 0 100 0 "Kenya" 2013 4780
    . 0 0 0 3 0 "Tanzania" 2013 2472
    .013333334 0 1 0 90 1 "Kenya" 2013 5180
    . 1 1 1 99 0 "Kenya" 2013 5012
    . 1 1 0 52 0 "uganda" 2013 751
    .04645455 0 0 1 65 1 "Tanzania" 2013 2254
    . 1 1 1 80 0 "Tanzania" 2013 2407
    . 1 1 1 30 1 "uganda" 2013 953
    . 0 1 0 90 1 "uganda" 2013 476
    . 0 1 1 100 0 "uganda" 2013 478
    . 1 1 1 80 0 "uganda" 2013 205
    .1851852 1 1 0 2 0 "uganda" 2013 1040
    . 0 1 0 15 0 "Kenya" 2013 4382
    . 0 1 0 100 0 "uganda" 2013 1065
    . 0 1 0 100 1 "Kenya" 2013 4989
    . 0 1 0 80 0 "Kenya" 2013 4988
    0 1 1 0 2 0 "uganda" 2013 614
    .3777778 1 1 0 70 0 "uganda" 2013 166
    . 1 0 0 100 0 "Kenya" 2013 4822
    . 1 1 0 . 0 "uganda" 2013 10
    . 0 1 1 10 1 "Tanzania" 2013 2555
    .023333333 0 1 0 1 0 "Kenya" 2013 5207
    . 1 1 0 7 0 "uganda" 2013 801
    .082 1 1 1 100 0 "Kenya" 2013 4368
    . 1 0 0 40 1 "Kenya" 2013 4830
    . 1 1 0 50 0 "uganda" 2013 741
    .2798165 0 0 0 5 0 "uganda" 2013 1104
    .004 1 1 1 60 1 "Kenya" 2013 5208
    . 0 1 0 45 0 "Tanzania" 2013 3024
    . 0 1 0 100 0 "Kenya" 2013 5191
    .08857143 0 1 1 100 1 "Kenya" 2013 4180
    . 1 1 0 60 0 "uganda" 2013 757
    . 0 1 1 80 0 "uganda" 2013 221
    . 0 1 1 100 0 "Kenya" 2013 4915
    .345 0 1 0 85 0 "uganda" 2013 46
    .031 1 1 0 100 0 "Tanzania" 2013 2783
    0 1 1 0 70 0 "uganda" 2013 967
    . 0 1 0 70 0 "Kenya" 2013 4306
    . 1 1 0 50 0 "uganda" 2013 512
    . 1 1 0 10 1 "Tanzania" 2013 3107
    .14025 0 1 1 70 1 "Tanzania" 2013 2126
    . 0 1 1 5 0 "uganda" 2013 649
    . 0 1 1 100 0 "Kenya" 2013 4712
    . 0 0 0 50 0 "uganda" 2013 880
    . 0 1 0 1 1 "Tanzania" 2013 2568
    . 1 1 0 100 0 "Kenya" 2013 4593
    . 1 1 1 100 1 "Kenya" 2013 4866
    .1894737 0 0 0 70 0 "Tanzania" 2013 2260
    . 0 1 1 100 0 "uganda" 2013 1086
    . 1 1 0 70 0 "uganda" 2013 744
    . 0 1 1 65 0 "uganda" 2013 804
    . 0 0 0 10 0 "uganda" 2013 1022
    . 0 1 0 15 0 "uganda" 2013 817
    .11 0 1 0 90 1 "Kenya" 2013 4106
    . 1 0 1 100 0 "Kenya" 2013 4934
    0 0 0 0 90 0 "uganda" 2013 836
    . 1 1 0 10 0 "Tanzania" 2013 2700
    . 1 1 1 100 1 "Kenya" 2013 4102
    . 0 1 0 90 0 "Kenya" 2013 4745
    . 1 1 0 3 1 "Tanzania" 2013 2912
    . 0 1 1 100 1 "Kenya" 2013 5026
    . 1 1 0 30 0 "Kenya" 2013 5076
    . 0 1 0 . 0 "uganda" 2013 688
    . 0 1 0 100 0 "Kenya" 2013 4871
    . 1 1 1 100 0 "Kenya" 2013 4848
    . 1 0 1 98 0 "uganda" 2013 680
    . 1 1 . 60 0 "Kenya" 2013 4765
    . 1 1 0 11 0 "uganda" 2013 888
    .08484849 1 1 1 90 1 "Kenya" 2013 4000
    .0046875 0 0 0 5 0 "uganda" 2013 635
    . 0 1 1 75 0 "uganda" 2013 748
    . 0 1 0 90 0 "Kenya" 2013 5002
    . 1 1 0 10 0 "Tanzania" 2013 2707
    .062765956 0 1 1 60 1 "Tanzania" 2013 2058
    . 0 0 0 10 0 "Tanzania" 2013 3018
    . 0 1 . 80 1 "Kenya" 2013 4917
    . 1 1 1 100 0 "Kenya" 2013 4681
    . 0 1 0 100 0 "uganda" 2013 1034
    . 0 1 0 35 0 "uganda" 2013 935
    . 0 1 0 . 0 "Tanzania" 2013 2648
    . 0 1 1 . 0 "Tanzania" 2013 2365
    .1895238 0 0 1 50 1 "Tanzania" 2013 2064
    . 0 0 0 . 0 "Tanzania" 2013 2465
    . 0 1 1 6 0 "Kenya" 2013 4823
    . 0 1 0 17 0 "uganda" 2013 640
    . 0 1 0 40 0 "uganda" 2013 573
    .06 1 1 0 60 0 "uganda" 2013 98
    . 0 1 0 . 1 "Tanzania" 2013 2585
    . 1 1 0 10 1 "Tanzania" 2013 2892
    . 0 1 1 . 0 "uganda" 2013 384
    . 0 1 0 80 0 "uganda" 2013 685
    . 0 1 1 100 0 "uganda" 2013 243
    . 0 1 1 100 1 "uganda" 2013 790
    .096 1 1 1 90 1 "Kenya" 2013 4027
    . 0 1 . 18 0 "uganda" 2013 708
    . 0 0 0 80 0 "uganda" 2013 347
    . 1 1 0 20 0 "uganda" 2013 64
    .05833333 0 0 1 10 1 "Tanzania" 2013 2561
    .1 1 0 0 90 0 "Kenya" 2013 5184
    . 0 1 0 100 0 "uganda" 2013 889
    .2 1 1 0 6 0 "uganda" 2013 202
    . 1 1 0 90 0 "Kenya" 2013 5071
    . 0 1 1 90 1 "Kenya" 2013 4861
    .168 1 1 0 90 0 "uganda" 2013 803
    .02142857 1 1 0 90 0 "Kenya" 2013 4221
    . 1 1 0 100 0 "Kenya" 2013 5057
    .021666666 0 1 0 100 0 "Kenya" 2013 4006
    . 0 1 0 100 0 "uganda" 2013 670
    . 0 1 . 95 1 "uganda" 2013 774
    . 0 1 1 4 0 "Kenya" 2013 4679
    . 1 1 0 40 0 "Tanzania" 2013 3073
    .8333333 1 0 0 50 0 "Tanzania" 2013 2756
    0 0 1 0 4 0 "Tanzania" 2013 2868
    . 0 0 0 100 0 "Kenya" 2013 4994
    .02782609 1 0 1 100 0 "Kenya" 2013 5285
    . 0 1 0 . 0 "Tanzania" 2013 3064
    0 1 1 0 80 0 "Tanzania" 2013 3078
    . 0 1 0 92 1 "Kenya" 2013 4250
    . 0 1 0 . 0 "uganda" 2013 70
    . 0 1 0 . 0 "Tanzania" 2013 2748
    . 1 1 1 100 0 "uganda" 2013 679
    . 0 1 1 15 1 "Kenya" 2013 5084
    . 1 0 0 4 0 "Kenya" 2013 4752
    . 1 1 0 . 0 "Kenya" 2013 4123
    . 0 1 0 20 0 "Tanzania" 2013 2514
    .07594936 1 1 0 100 0 "Kenya" 2013 5240
    .21328 0 1 1 40 0 "Kenya" 2013 5144
    .04615385 0 1 0 3 0 "Tanzania" 2013 2973
    end
    Tags: None
  • #2
    There is a provided unique-identifier for each firm (idstd) in WBES dataset but that differs across years for same firm
    Your data example doesn't include firm names or any other identifying information, as far as I can see. We don't have any special powers, so we're stumped as well. The data provider needs to provide you with a way to track firms across years. So, you may need to contact them, unless you have more information than you're showing us here.

    Comment

    • #3
      Thanks, Andrew for your reply. I apologize for not providing you with sufficient information of the relevant variables. here are the listed variables of idstd and panel_id for one of the countries

      Code:
      * Example generated by -dataex-. For more info, type help dataex
clear
input str8 country long idstd_01 int idPANEL2006 double id2013
"uganda"  97401 1001        .
"uganda"  97402 1002        .
"uganda"  97403 1003        .
"uganda"  97404 1004        .
"uganda"  97405 1005        .
"uganda" 534428 1005     9185
"uganda"  97406 1006        .
"uganda"  97407 1007        .
"uganda"  97408 1008        .
"uganda" 533857 1008      161
"uganda"  97409 1009        .
"uganda"  97410 1010        .
"uganda" 533818 1010       44
"uganda"  97411 1011        .
"uganda" 534233 1011     1116
"uganda"  97412 1012        .
"uganda"  97413 1013        .
"uganda" 534507 1013 34436885
"uganda"  97414 1015        .
"uganda"  97415 1016        .
"uganda" 534433 1016    10610
"uganda"  97416 1017        .
"uganda"  97417 1018        .
"uganda" 533814 1018       36
"uganda"  97418 1019        .
"uganda" 534180 1019      958
"uganda"  97419 1020        .
"uganda"  97420 1021        .
"uganda"  97421 1022        .
"uganda"  97422 1023        .
"uganda" 534466 1023 33665772
"uganda"  97423 1024        .
"uganda"  97424 1025        .
"uganda" 534545 1025 35318483
"uganda"  97425 1026        .
"uganda" 534181 1026      959
"uganda"  97426 1027        .
"uganda" 534488 1027 34087737
"uganda"  97427 1028        .
"uganda"  97428 1029        .
"uganda" 534527 1029 35027137
"uganda"  97429 1030        .
"uganda" 534395 1030     2777
"uganda"  97430 1031        .
"uganda"  97431 1032        .
"uganda" 534546 1032 35420710
"uganda"  97432 1033        .
"uganda" 534522 1033 34944864
"uganda"  97433 1034        .
"uganda"  97434 1035        .
"uganda" 533856 1035      158
"uganda"  97435 1036        .
"uganda"  97436 1037        .
"uganda" 534457 1037 33526267
"uganda"  97437 1038        .
"uganda"  97438 1040        .
"uganda"  97439 1041        .
"uganda"  97440 1042        .
"uganda"  97441 1043        .
"uganda" 534464 1043 33659854
"uganda"  97442 1044        .
"uganda"  97443 1045        .
"uganda" 534530 1045 35037008
"uganda"  97444 1046        .
"uganda"  97445 1047        .
"uganda" 533901 1047      280
"uganda"  97446 1048        .
"uganda" 534525 1048 34971937
"uganda"  97447 1049        .
"uganda"  97448 1050        .
"uganda" 534404 1050     2870
"uganda"  97449 1051        .
"uganda"  97450 1052        .
"uganda" 534486 1052 33988795
"uganda"  97451 1053        .
"uganda"  97452 1054        .
"uganda"  97453 1055        .
"uganda" 534515 1055 34834762
"uganda"  97454 1056        .
"uganda"  97455 1057        .
"uganda"  97456 1058        .
"uganda"  97457 1059        .
"uganda" 534403 1059     2869
"uganda"  97458 1060        .
"uganda" 534463 1060 33659342
"uganda"  97459 1062        .
"uganda" 534443 1062 33151206
"uganda"  97460 1063        .
"uganda" 534487 1063 34046421
"uganda"  97461 1064        .
"uganda" 534400 1064     2848
"uganda"  97462 1065        .
"uganda"  97463 1066        .
"uganda"  97464 1067        .
"uganda" 534533 1067 35180837
"uganda"  97465 1068        .
"uganda"  97466 1069        .
"uganda"  97467 1070        .
"uganda" 534462 1070 33657172
"uganda"  97468 1071        .
end

      Comment

      • #4
        You have 3 identifiers, "idstd_01", "idPANEL2006" and "id2013". How do these identifiers relate to each other? Is one indicating the ID of a firm in a previous wave? If so, I would append all waves and name one ID variable "current" and the other "previous". Then I'd install group_id from SSC and from these two variables, create a unique group ID. Here is an example #6: https://www.statalist.org/forums/for...neophyte-stata. For firms with no previous ID, assign a unique negative value to previous ID before running group_id.

        Code:
        replace previous=-_n if missing(previous)

        Comment

        Previous Next
        Working...
        X