Announcement

Collapse
No announcement yet.
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Generate a New Variable with Rank Starting from the End of Another Var

    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 -
    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
    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!
Working...
X