Hi, I have a variable which has been coded differently in two datasets. (old one for year 2000 and new one for year 2005 )

Old codes are { 2 4 5 7 8 9 10 11 12 13 14 15 16 18 19 20 21 22 23 24 25 26 27 3 28 29 31 6 32 17 33 30 }

New codes are { 28 18 10 24 6 2 1 29 32 23 27 14 17 13 21 3 8 11 33 16 9 19 35 12 4 26 7 30 31 15 34 25}

So, for example, the variable (lets call it state) was taking a value 2 earlier but in the new dataset that value corresponds to 28...... similarly 4 earlier and 18 now and so on


both the datasets have been appended with a variable called year taking value 2000 for old dataset and 2005 for new dataset.


How do I write a loop to convert the old codes for variable state to new one for the year 2000 so that the variable state can be made compatible across years ?