Hi,

I am trying to figure it out how to set up Stata to pick the first log of real value added per worker per country in the following dataset. For instance, if a certain country starts showing log of real value added per worker in Food Processing in 1963, how to generate a variable that separates this? or if a country starts having that variable (log of real value added per worker in Chemicals in year 1970)? Is there a short-curt top pick the first log of real value added per worker in any sector (isiccomb1) by country?


[/CODE]
* Example generated by -dataex-. To install: ssc install dataex
clear
input int(country year) long isiccomb1 float logrealvalueaddedperworker long(Employment Establishments) double ValueAdded long FemaleEmployees float valueaddedperworker
4 1973 1 . 4321 . . . .
4 1974 1 . 4845 . . . .
4 1975 1 . 5103 . . . .
4 1976 1 . 4540 . . . .
4 1977 1 . 6309 . . . .
4 1978 1 . 6413 . . . .
4 1979 1 . 6006 . . . .
4 1980 1 . 5672 . . . .
4 1981 1 . 8481 62 . . .
4 1982 1 . 6866 69 . . .
4 1983 1 . 5080 22 . 376 .
4 1984 1 . 5187 22 . 419 .
4 1985 1 . 5446 26 . 742 .
4 1986 1 . 5556 30 . 736 .
4 1987 1 . 6177 48 . 865 .
4 1988 1 . 5950 48 . 1299 .
4 1990 1 . . . . 565 .
4 1991 1 . . . . 590 .
4 2002 1 . 1398 57 . 270 .
4 2003 1 . 1986 68 . 384 .
4 2004 1 . 2170 60 . 720 .
4 2005 1 . 4376 152 . 561 .
4 2006 1 . 5278 199 . 901 .
4 2007 1 . 5300 206 . 1237 .
4 2008 1 . 5431 212 . 899 .
4 2009 1 . 5400 199 . 870 .
4 2010 1 . 4893 195 . 912 .
4 2011 1 . 4901 197 . 1008 .
4 2012 1 . 4790 192 . . .
4 2013 1 . 4368 189 . . .
4 2014 1 . . . . . .
4 2015 1 . . . . . .
4 2016 1 . . . . . .
4 2017 1 . . . . . .
4 2018 1 . . . . . .
4 1973 3 . 0 . . . .
4 1974 3 . 0 . . . .
4 1975 3 . 0 . . . .
4 1976 3 . 0 . . . .
4 1977 3 . 0 . . . .
4 1978 3 . 0 . . . .
4 1979 3 . 0 . . . .
4 1980 3 . 0 . . . .
4 1981 3 . 0 0 . . .
4 1982 3 . 0 0 . . .
4 1983 3 . 0 0 . 0 .
4 1984 3 . 0 0 . 0 .
4 1985 3 . 0 0 . 0 .
4 1986 3 . 0 0 . 0 .
4 1987 3 . 0 0 . 0 .
4 1988 3 . 0 0 . 0 .
4 1990 3 . . . . 0 .
4 1991 3 . . . . 0 .
4 2002 3 . . . . . .
4 2003 3 . . . . . .
4 2004 3 . . . . . .
4 2005 3 . . . . . .
4 2006 3 . . . . . .
4 2007 3 . . . . . .
4 2008 3 . . . . . .
4 2009 3 . . . . . .
4 2010 3 . . . . . .
4 2011 3 . . . . . .
4 2012 3 . . . . . .
4 2013 3 . . . . . .
4 2014 3 . . . . . .
4 2015 3 . . . . . .
4 2016 3 . . . . . .
4 2017 3 . . . . . .
4 2018 3 . . . . . .
4 1973 6 . 12555 . . . .
4 1974 6 . 14243 . . . .
4 1975 6 . 17202 . . . .
4 1976 6 . 20520 . . . .
4 1977 6 . 20540 . . . .
4 1978 6 . 22889 . . . .
4 1979 6 . 23733 . . . .
4 1980 6 . 20438 . . . .
4 1981 6 . 15068 56 . . .
4 1982 6 . 13387 63 . . .
4 1983 6 . 10067 73 . 303 .
4 1984 6 . 10208 75 . 290 .
4 1985 6 . 10468 78 . 516 .
4 1986 6 . 11716 59 . 1422 .
4 1987 6 . 12060 71 . 1382 .
4 1988 6 . 11497 72 . 1358 .
4 1990 6 . . . . 1825 .
4 1991 6 . . . . 674 .
4 2002 6 . 830 11 . 710 .
4 2003 6 . 2371 22 . 1800 .
4 2004 6 . 1870 8 . 1709 .
4 2005 6 . 4474 31 . 3900 .
4 2006 6 . 5808 49 . 5000 .
4 2007 6 . 6700 57 . 5908 .
4 2008 6 . 6917 64 . 6010 .
4 2009 6 . 6902 66 . 6030 .
4 2010 6 . 6820 66 . 6048 .
4 2011 6 . 6853 68 . 6120 .
4 2012 6 . 6749 68 . . .
4 2013 6 . 6222 66 . . .
end
label values isiccomb1 isiccomb1
label def isiccomb1 1 "15", modify
label def isiccomb1 3 "16", modify
label def isiccomb1 6 "17", modify
[/CODE]
------------------ copy up to and including the previous line ------------------

Listed 100 out of 104180 observations
Use the count() option to list more