Hello,

Thank you in advance for helping. I am new to Stata.

I am replicating a study and therefore need to match the SALARY of EXECID to the ROE of the same EXECID in their old firm (included GVKEY of firms in the sample).
Can someone help me how to do this?

I hope I have made my question clear and this is something that I can post here.

Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input str6 GVKEY double(EXECDIR SALARY) long BECAMECEO float(YEARBECAMECEO ROE)
"001004" .       .     .    .   .05975049
"001004" .       .     .    .   .08750307
"001004" .       .     .    .   .07832427
"001004" .       .     .    .   .05987372
"001004" .       .     .    .   .07293647
"001004" .       .     .    .  -.06448941
"001004" .       .     .    .   .04677755
"001004" .       .     .    .    .0549114
"001004" .       .     .    .   .07871409
"001004" .       .     .    .   .09283585
"001013" .       .     .    .   .17970204
"001045" .       .     .    .    1.350488
"001045" .       .     .    .    .7070013
"001045" .       .     .    .    .4887927
"001050" .       .     .    .   .06553136
"001050" .       .     .    .    .1933473
"001050" .       .     .    .   .17501694
"001050" .       .     .    .   .03847869
"001050" .       .     .    .   .07215932
"001050" .       .     .    . -.023424335
"001050" .       .     .    .   -.2010606
"001050" .       .     .    .  -.01623528
"001050" .       .     .    .  -.03988015
"001050" .       .     .    .   .09173803
"001062" .       .     .    .   .14319336
"001062" .       .     .    .  -.05108133
"001062" .       .     .    .  -.32638645
"001062" .       .     .    .   -.8495129
"001062" .       .     .    .  -.12522542
"001062" .       .     .    .   -.3750373
"001062" .       .     .    .    .3422988
"001062" .       .     .    .  .007141629
"001062" .       .     .    .  -.25041318
"001062" .       .     .    .    .3198241
"001072" .       .     .    .   .07932118
"001072" .       .     .    .    .1196435
"001072" .       .     .    .   .07205224
"001072" .       .     .    . -.032597203
"001072" .       .     .    .   .06203933
"001072" .       .     .    .   .10594509
"001072" .       .     .    .    .0466376
"001072" .       .     .    .   .05674992
"001072" .       .     .    . .0021886004
"001072" .       .     .    .   .11400691
"001075" .       .     .    .   .08971292
"001075" .       .     .    .     .085866
"001075" .       .     .    .   .09750564
"001075" .       .     .    .   .09681176
"001075" .       .     .    .   .09103506
"001075" .       .     .    .   .09538938
"001075" .       .     .    .   .09202098
"001075" .       .     .    .   .09756067
"001075" .       .     .    .   .09784708
"001075" .       .     .    .    .0991263
"001076" .       .     .    .   .12086374
"001076" .       .     .    .   .11649843
"001076" .       .     .    .    .1523097
"001076" 1     675 19966 2014    .1058508
"001076" 0     675 19966 2014    .0993028
"001076" 0 263.029 19966 2014   .09400863
"001076" .       .     .    .   .16929127
"001076" .       .     .    .   .11143813
"001076" .       .     .    .  .018115895
"001078" .       .     .    .     .206635
"001078" .       .     .    .   .19347306
"001078" .       .     .    .   .22315514
"001078" .       .     .    .   .09467244
"001078" .       .     .    .   .07994983
"001078" .       .     .    .   .12286078
"001078" .       .     .    .   .05175772
"001078" .       .     .    .  .011425057
"001078" .       .     .    .   .07646442
"001078" .       .     .    .   .11859882
"001082" .       .     .    .    -.182291
"001082" .       .     .    .  -.15759645
"001094" .       .     .    .   .04712698
"001094" .       .     .    .   .05576386
"001094" .       .     .    .   .10107557
"001094" .       .     .    .   .11471435
"001094" .       .     .    .   .12415234
"001094" .       .     .    .   .13171342
"001094" .       .     .    .    .1141958
"001094" .       .     .    .   .02808424
"001094" .       .     .    .  -3.3176365
"001104" .       .     .    .     .101491
"001104" .       .     .    .   .10120612
"001104" .       .     .    .   .11498088
"001104" .       .     .    .    .1143551
"001104" .       .     .    .    .1214619
"001104" .       .     .    .   .11101334
"001104" .       .     .    .    .1268647
"001104" .       .     .    .   .08114062
"001104" .       .     .    .   .08786211
"001104" .       .     .    .   .09898573
"001117" .       .     .    .  -.02324762
"001117" .       .     .    .  -.01756386
"001117" .       .     .    .   .06841373
"001117" .       .     .    .  .036346275
"001117" .       .     .    .     .048837
"001117" .       .     .    .   .02989661
end
format %td BECAMECEO