Dear all,

Thank you so much for all your help!
In the data below, I want to compare the value added per worker for a set of three industries (tech_intensity) using the US (country1==840) as a reference country. For instance, I want obtain the ratio of value added per worker( r_valworker) in industry (tech_intensity==1) for country (Bolivia==68) over the ratio of value added per worker (r_valworker) in industry (tech_intensity==1) for country US (country1==840). How can I get this variable for all set of countries using these industries' classification as reference and hence obtain three variables for the types of industries? Ideally, I would like to get these variables using the US as a country of reference (for the denominators). Thank you so much again!

Code:
 * Example generated by -dataex-. To install: ssc install dataex
clear
input int(country1 year) float tech_intensity double(Establishments Employment Wages OutputINDSTAT4 ValueAdded GrossFixed) float(r_valworker r_output_worker lval_per_worker share_emp_high share_emp_low)
4 1973 3                  .               51.8                  .                  . . . .         . . .015424144  .8860162
4 1973 2                  .                331                  .                  . . . .         . . .015424144  .8860162
4 1973 1                  . 2975.5714285714284                  .                  . . . .         . . .015424144  .8860162
4 1974 2                  .              332.4                  .                  . . . .         . .   .1526138  .7700793
4 1974 1                  . 3311.1428571428573                  .                  . . . .         . .   .1526138  .7700793
4 1974 3                  .              656.2                  .                  . . . .         . .   .1526138  .7700793
4 1975 2                  .              430.6                  .                  . . . .         . .    .158998  .7563943
4 1975 3                  .              809.2                  .                  . . . .         . .    .158998  .7563943
4 1975 1                  . 3849.5714285714284                  .                  . . . .         . .    .158998  .7563943
4 1976 2                  .              383.6                  .                  . . . .         . .  .16229185  .7682115
4 1976 1                  .  4240.285714285715                  .                  . . . .         . .  .16229185  .7682115
4 1976 3                  .              895.8                  .                  . . . .         . .  .16229185  .7682115
4 1977 1                  .  4536.571428571428                  .                  . . . .         . .   .1601448   .770586
4 1977 3                  .              942.8                  .                  . . . .         . .   .1601448   .770586
4 1977 2                  .              407.8                  .                  . . . .         . .   .1601448   .770586
4 1978 1                  .  4949.857142857143                  .                  . . . .         . .  .15292776   .768342
4 1978 3                  .              985.2                  .                  . . . .         . .  .15292776   .768342
4 1978 2                  .              507.2                  .                  . . . .         . .  .15292776   .768342
4 1979 3                  .              875.4                  .                  . . . .         . .  .13531454  .7813079
4 1979 1                  .  5054.571428571428                  .                  . . . .         . .  .13531454  .7813079
4 1979 2                  .              539.4                  .                  . . . .         . .  .13531454  .7813079
4 1980 2                  .                515                  .                  . . . .         . .  .14345832  .7692531
4 1980 1                  .  4538.571428571428                  .                  . . . .         . .  .14345832  .7692531
4 1980 3                  .              846.4                  .                  . . . .         . .  .14345832  .7692531
4 1981 3                  1                571                  .                  . . . .         . .  .10808428  .8097262
4 1981 2                8.2              434.2                  .                  . . . .         . .  .10808428  .8097262
4 1981 1 23.571428571428573  4277.714285714285                  .                  . . . .         . .  .10808428  .8097262
4 1982 3                  1              535.6                  .                  . . . .         . .  .11449337  .7896537
4 1982 2                7.4              448.4                  .                  . . . .         . .  .11449337  .7896537
4 1982 1 25.285714285714285               3694                  .                  . . . .         . .  .11449337  .7896537
4 1983 3                1.8              930.2                  .                  . . . .         . .  .21483813  .7188766
4 1983 1 24.285714285714285 3112.5714285714284                  .                  . . . .         . .  .21483813  .7188766
4 1983 2                  8                287                  .                  . . . .         . .  .21483813  .7188766
4 1984 2                  8              270.8                  .                  . . . .         . .  .20192805  .7342654
4 1984 3                1.8                857                  .                  . . . .         . .  .20192805  .7342654
4 1984 1 28.285714285714285  3116.285714285714                  .                  . . . .         . .  .20192805  .7342654
4 1985 1                 32 3275.5714285714284                  .                  . . . .         . .   .2065464   .732205
4 1985 3                1.8                924                  .                  . . . .         . .   .2065464   .732205
4 1985 2                8.8                274                  .                  . . . .         . .   .2065464   .732205
4 1986 1 39.285714285714285  4101.285714285715                  .                  . . . .         . .   .1600479  .7849823
4 1986 2                9.4              287.2                  .                  . . . .         . .   .1600479  .7849823
4 1986 3                2.2              836.2                  .                  . . . .         . .   .1600479  .7849823
4 1987 3                2.2              936.8                  .                  . . . .         . .   .1578889  .7862904
4 1987 1 44.285714285714285  4665.285714285715                  .                  . . . .         . .   .1578889  .7862904
4 1987 2               13.6              331.2                  .                  . . . .         . .   .1578889  .7862904
4 1988 3                2.4              990.4                  .                  . . . .         . .   .1737091  .7649385
4 1988 1 48.142857142857146  4361.285714285715                  .                  . . . .         . .   .1737091  .7649385
4 1988 2               14.8              349.8                  .                  . . . .         . .   .1737091  .7649385
4 1990 2                  .                  .                  .                  . . . .         . .          .         .
4 1990 3                  .                  .                  .                  . . . .         . .          .         .
4 1990 1                  .                  .                  .                  . . . .         . .          .         .
4 1991 3                  .                  .                  .                  . . . .         . .          .         .
4 1991 2                  .                  .                  .                  . . . .         . .          .         .
4 1991 1                  .                  .                  .                  . . . .         . .          .         .
4 1998 2                  .                  .                  .                  . . . .         . .          .         .
4 1998 3                  .                  .                  .                  . . . .         . .          .         .
4 1998 1                  .                  .                  .                  . . . .         . .          .         .
4 1999 3                  .                  .                  .                  . . . .         . .          .         .
4 1999 1                  .                  .                  .                  . . . .         . .          .         .
4 1999 2                  .                  .                  .                  . . . .         . .          .         .
4 2001 1                  .                  .                  .                  . . . .         . .          .         .
4 2001 2                  .                  .                  .                  . . . .         . .          .         .
4 2001 3                  .                  .                  .                  . . . .         . .          .         .
4 2002 1              28.75             907.75             944394         2671288.25 . . .  1642.744 .  .28250483  .3043843
4 2002 2               50.5               1232 1188568.3333333333           615059.5 . . . 597.68066 .  .28250483  .3043843
4 2002 3                5.5              842.5           905367.5              48240 . . . 26.487877 .  .28250483  .3043843
4 2003 1               33.5             1440.5         1454829.75            1927701 . . .  870.9985 .    .352271 .33841035
4 2003 2 52.666666666666664 1316.6666666666667 1231267.6666666667 1346656.3333333333 . . .  775.0224 .    .352271 .33841035
4 2003 3                 10             1499.5            1396271          1291969.5 . . .  876.4713 .    .352271 .33841035
4 2004 2 59.333333333333336 1446.6666666666667            1451344            2744957 . . . 1279.0132 .  .39170825  .3096508
4 2004 3               19.5             1897.5            1903635          2612586.5 . . . 1367.1324 .  .39170825  .3096508
4 2004 1               32.5               1500          1435877.5            4101760 . . . 1908.3418 .  .39170825  .3096508
4 2005 3                 65               2427          2369591.5           13365095 . . . 2914.0854 .   .3279951  .3963106
4 2005 1              68.25             2932.5         3023117.75        12556925.75 . . .  2521.687 .   .3279951  .3963106
4 2005 2 54.666666666666664               2040            2043644 15732356.333333334 . . . 4576.0645 .   .3279951  .3963106
4 2006 2  73.33333333333333               3050 3427117.6666666665 18293986.333333332 . . . 3503.0034 .   .3696422  .3481529
4 2006 3               85.5               3995          4321052.5           13940819 . . .  1822.082 .   .3696422  .3481529
4 2006 1              87.75            3762.75            3945432        14526693.75 . . .  2161.713 .   .3696422  .3481529
4 2007 2                 80               2490 3677740.3333333335           19694961 . . . 4658.5093 .   .3895239  .3752598
4 2007 3               97.5             4123.5            4753811           15091464 . . .  1886.143 .   .3895239  .3752598
4 2007 1              93.25             3972.5         4579799.25        16877821.25 . . . 2355.5303 .   .3895239  .3752598
4 2008 2                 79 3324.3333333333335 3982411.6666666665           20106290 . . .  3194.276 .   .3842091  .3377979
4 2008 1                 96             4039.5         4888196.75         16179228.5 . . . 2050.6348 .   .3842091  .3377979
4 2008 3                105             4594.5            5595744           22534501 . . .  3087.225 .   .3842091  .3377979
4 2009 1              91.25            4022.25         5083234.25         16283159.5 . . . 2346.4924 .    .384414  .3370483
4 2009 2                 81               3324            4431416 20853783.666666668 . . .  3622.996 .    .384414  .3370483
4 2009 3              101.5             4587.5          5791346.5         23306507.5 . . . 3562.5386 .    .384414  .3370483
4 2010 3                104             5192.5          7377542.5         25914665.5 . . .  3501.906 .   .4206014  .3123629
4 2010 1              90.75            3856.25          5478988.5         18891894.5 . . . 2730.8606 .   .4206014  .3123629
4 2010 2  78.33333333333333 3296.6666666666665  5135056.333333333 24767973.666666668 . . . 4130.6343 .   .4206014  .3123629
4 2011 3                102               5197          7604208.5           26116110 . . . 3247.0576 .  .42005575  .3128393
4 2011 1                 92             3870.5         5663292.75         20503237.5 . . .  2590.373 .  .42005575  .3128393
4 2011 2  78.33333333333333 3304.6666666666665            4835347 25112480.666666668 . . . 3987.5266 .  .42005575  .3128393
4 2012 2  76.66666666666667               3080  4246413.666666667           23288179 . . .  3829.427 .   .4237512  .3182113
4 2012 3                100               5058          6972510.5           23956529 . . .  3048.956 .   .4237512  .3182113
4 2012 1               89.5            3798.25         5232574.25         20110405.5 . . .  2418.603 .   .4237512  .3182113
4 2013 2  73.66666666666667 3096.3333333333335 4025702.6666666665 20724421.666666668 . . . 3402.9866 .   .4341611  .2997185
4 2013 3                 98             5051.5            6569455           22849533 . . .  2840.688 .   .4341611  .2997185
4 2013 1              89.75            3487.25            4533881         17272357.5 . . . 2296.0713 .   .4341611  .2997185
4 2014 1                  .                  .                  .           11528111 . . .         . .          .         .
end