Hi,
I have a dataset that looks at fishing and farming households and ranks them into groups based on some parameters. I am looking to develop a new variable that starts from one digit after the last digit of another variable. For example -
In this data, I have final_rank and rank_within_group. What I want is for rank_within_group to start from the end point of final_rank. So for example, when final_rank == 1, rank_within_group == 35 (given final_rank == 34 is the last example in this dataset). Any ideas how I might do this?
Thank you!
I have a dataset that looks at fishing and farming households and ranks them into groups based on some parameters. I am looking to develop a new variable that starts from one digit after the last digit of another variable. For example -
Code:
* Example generated by -dataex-. For more info, type help dataex clear input double(final_rank rank_within_group) 1 1 2 2 3 3 4 4 5 5 6 6 7 7 8 8 9 9 10 10 11 11 12 12 13 13 14 14 15 15 16 16 17 17 18 18 19 19 20 20 21 21 22 22 23 23 24 24 25 25 26 26 27 27 28 28 29 29 30 30 31 31 32 32 33 33 1 1 2 2 3 3 4 4 5 5 6 6 7 7 8 8 9 9 10 10 11 11 12 12 13 13 14 14 15 15 16 16 17 17 18 18 19 19 20 20 21 21 22 22 23 23 24 24 25 25 26 26 27 27 28 28 29 29 30 30 31 31 32 32 33 33 1 1 2 2 3 3 4 4 5 5 6 6 7 7 8 8 9 9 10 10 11 11 12 12 13 13 14 14 15 15 16 16 17 17 18 18 19 19 20 20 21 21 22 22 23 23 24 24 25 25 26 26 27 27 28 28 29 29 30 30 31 31 32 32 33 33 34 34 end
Thank you!