I've information about ID's current and previous city of residence. I want to create a new variable (displaced: Yes/No) showing where the ID has relocated or not. Is it possible to calculate this?
I tried the following, but its not gicing the expected results:
Code:
. levelsof before , local(Avals) 1 2 3 4 5 6 7 8 9 10 96 . . levelsof now , local(Bvals) 1 2 3 4 5 6 7 8 9 10 . local before now : list uniq
Code:
* Example generated by -dataex-. To install: ssc install dataex clear input byte(before now) float id 2 2 1 10 10 2 6 6 3 9 9 4 6 6 5 9 9 6 1 1 7 4 4 8 6 4 9 4 3 10 9 9 11 5 5 12 5 4 13 4 4 14 2 2 15 2 1 16 4 2 17 2 2 18 9 9 19 8 8 20 9 9 21 4 7 22 2 2 23 10 10 24 3 3 25 4 1 26 2 2 27 5 5 28 2 8 29 5 6 30 7 7 31 9 9 32 9 9 33 7 7 34 5 5 35 8 10 36 2 2 37 1 1 38 10 10 39 9 9 40 2 2 41 8 8 42 10 8 43 2 2 44 7 8 45 3 3 46 8 8 47 7 7 48 4 3 49 10 10 50 2 1 51 3 2 52 5 5 53 7 7 54 4 4 55 5 5 56 4 4 57 4 10 58 9 9 59 4 4 60 2 2 61 3 3 62 3 3 63 9 9 64 5 5 65 7 7 66 4 3 67 10 4 68 7 7 69 3 10 70 2 2 71 6 6 72 10 10 73 8 8 74 4 8 75 2 3 76 10 2 77 9 2 78 10 9 79 5 5 80 96 8 81 8 8 82 2 2 83 8 8 84 8 8 85 10 2 86 6 6 87 9 9 88 1 1 89 3 3 90 6 6 91 9 9 92 4 4 93 2 2 94 9 9 95 2 1 96 10 10 97 4 3 98 10 2 99 9 9 100 end label values before WB17 label def WB17 1 "BUTHA-BUTHE", modify label def WB17 2 "LERIBE", modify label def WB17 3 "BEREA", modify label def WB17 4 "MASERU", modify label def WB17 5 "MAFETENG", modify label def WB17 6 "MOHALES HOEK", modify label def WB17 7 "QUTHING", modify label def WB17 8 "QACHAS NEK", modify label def WB17 9 "MOKHOTLONG", modify label def WB17 10 "THABA-TSEKA", modify label def WB17 96 "OUTSIDE OF LESOTHO", modify label values now HH7A label def HH7A 1 "BOTHA-BOTHE", modify label def HH7A 2 "LERIBE", modify label def HH7A 3 "BEREA", modify label def HH7A 4 "MASERU", modify label def HH7A 5 "MAFETENG", modify label def HH7A 6 "MOHALES HOEK", modify label def HH7A 7 "QUTHING", modify label def HH7A 8 "QACHAS NEK", modify label def HH7A 9 "MOKHOTLONG", modify label def HH7A 10 "THABA-TSEKA", modify
0 Response to Creating a new variable comparing two others
Post a Comment