Hello
I have data for historical breast cancer mortality rates for countries and I'd like to extract the maximum values for each country mapped to the name of each country (newvar_Country and newvar_max, and the corresponding year of the observed maximum)
I've tried a number of approaches but with no success - if anyone has any suggestions I'd be very grateful
thank you!
catherine
Year Armenia Australia Austria Belgium newvar_Country newvar_max
1950 15.49 Armenia max value for Armenia
1951 15.09 Austria Max value for Austria
1952 15.92 Belgium Max value for Belgium
1953 16.06
1954 15.08 15.77
1955 15.55 11.92 15
1956 15.1 11.18 16.31
1957 14.88 11.34 16.7
1958 14.58 11.71 15.85
1959 15.02 12.26 16.04
1960 14.14 12.41 16.6
1961 15.46 12.16 16.11
1962 14.12 12.65 17.38
1963 15.6 12.96 16.38
1964 15.08 13.36 16.83
1965 14.53 14.61 17.24
1966 14.9 14.21 16.39
1967 15.04 13.64 17.39
1968 14.86 13.36 17.97