Replacing value in a variable from other variable using conditional expression

[rahul kumar singh]

Here
I want to replace the missing values in mem_name2 by the mem_name1 of the head (relation=="head") of the household if and only if relation is either son, daughter or wife.
Please help me to write a code for that
Thanks

* Example generated by -dataex-. For more info, type help dataex
clear
input int chs_id byte mem_no str32(mem_name1 mem_name2 mem_name3) str18 relation str31 head_name str24 father_husband_name
1  1 "tulsidas"     "shankar"   "washimkar" "head"            "tulsidas shankar washimkar"   "shankar bhagwan washimka"
1  2 "savita"       "tulsidas"  "washimkar" "wife"            "tulsidas shankar washimkar"   "shankar bhagwan washimka"
1  3 "pramod"       "tulsidas"  "washimkar" "son"             "tulsidas shankar washimkar"   "shankar bhagwan washimka"
1  4 "abhishek"     "tulsidas"  "washimkar" "son"             "tulsidas shankar washimkar"   "shankar bhagwan washimka"
1  5 "punam"        "tulsidas"  "washimkar" "daughter"        "tulsidas shankar washimkar"   "shankar bhagwan washimka"
2  1 "onkar"        "anand"     "giri"      "head"            "onkargir anandgir giri"       "anandgir mohan giri"     
2  2 "jijabai"      "onkar"     "giri"      "wife"            "onkargir anandgir giri"       "anandgir mohan giri"     
2  3 "santosh"      "onkar"     "giri"      "son"             "onkargir anandgir giri"       "anandgir mohan giri"     
2  4 "lata"         "santosh"   "giri"      "daughter-in-law" "onkargir anandgir giri"       "anandgir mohan giri"     
2  5 "akshay"       "santosh"   "giri"      "grand son"       "onkargir anandgir giri"       "anandgir mohan giri"     
2  6 "vaibhav"      "santosh"   "giri"      "grand son"       "onkargir anandgir giri"       "anandgir mohan giri"     
2  7 "vaishnavi"    "santosh"   "giri"      "grand daughter"  "onkargir anandgir giri"       "anandgir mohan giri"     
3  1 "ramesh"       "pundlik"   "nagolkar"  "head"            "ramesh pundlik nagolkar"      "pundlik saduji nagolkar" 
3  2 "shashikala"   "ramesh"    "nagolkar"  "wife"            "ramesh pundlik nagolkar"      "pundlik saduji nagolkar" 
3  3 "dinesh"       "ramesh"    "nagolkar"  "son"             "ramesh pundlik nagolkar"      "pundlik saduji nagolkar" 
3  4 "shrikrishna"  "ramesh"    "nagolkar"  "son"             "ramesh pundlik nagolkar"      "pundlik saduji nagolkar" 
4  1 "vinod"        "vittal"    "agarkar"   "head"            "vinod vittal agarkar"         "vittal ganpat"           
4  2 "padma"        ""          "agarkar"   "wife"            "vinod vittal agarkar"         "vittal ganpat"           
4  3 "vittal"       ""          "agarkar"   "father"          "vinod vittal agarkar"         "vittal ganpat"           
4  4 "mainabai"     ""          "agarkar"   "mother"          "vinod vittal agarkar"         "vittal ganpat"           
4  5 "reena"        ""          "agarkar"   "daughter"        "vinod vittal agarkar"         "vittal ganpat"           
4  6 "jivan"        ""          "agarkar"   "son"             "vinod vittal agarkar"         "vittal ganpat"           
5  1 "mahadev"      "bhagwan"   "wahar"     "head"            "mahadev bhagwan wahar"        "bhagwan ganuji wahar"    
5  2 "urmila"       ""          "wahar"     "wife"            "mahadev bhagwan wahar"        "bhagwan ganuji wahar"    
5  3 "shankar"      ""          "wahar"     "son"             "mahadev bhagwan wahar"        "bhagwan ganuji wahar"    
5  4 "dinesh"       ""          "wahar"     "son"             "mahadev bhagwan wahar"        "bhagwan ganuji wahar"    
5  5 "sujata"       ""          "wahar"     "daughter"        "mahadev bhagwan wahar"        "bhagwan ganuji wahar"    
6  1 "gajanan"      "kisan"     "lahorkar"  "head"            "gajanan kisan lahorkar"       "kisan dashrath lahorkar" 
6  2 "ushatai"      ""          "lahorkar"  "wife"            "gajanan kisan lahorkar"       "kisan dashrath lahorkar" 
6  3 "vrushalee"    ""          "lahorkar"  "daughter"        "gajanan kisan lahorkar"       "kisan dashrath lahorkar" 
6  4 "gourav"       ""          "lahorkar"  "son"             "gajanan kisan lahorkar"       "kisan dashrath lahorkar" 
7  1 "vijay"        "pandurang" "gajbhiye"  "head"            "vijay pandurang gajbhiye"     "pandurang sadashiv gajbh"
7  2 "pandurang"    ""          "gajbhiye"  "father"          "vijay pandurang gajbhiye"     "pandurang sadashiv gajbh"
7  3 "raiwatabai"   ""          "gajbhiye"  "mother"          "vijay pandurang gajbhiye"     "pandurang sadashiv gajbh"
8  1 "pandurang"    "nilkanth"  "paighan"   "head"            "pandhari nilkanth paighan"    "nilkanth jairam paighan" 
8  2 "tulsabai"     ""          "paighan"   "wife"            "pandhari nilkanth paighan"    "nilkanth jairam paighan" 
9  1 "shrikant"     "dadarao"   "deshmukh"  "head"            "shrikant dadarao deshmukh"    "dadarao turerao deshmukh"
9  2 "varsha"       ""          "deshmukh"  "wife"            "shrikant dadarao deshmukh"    "dadarao turerao deshmukh"
9  3 "renuka"       ""          "deshmukh"  "daughter"        "shrikant dadarao deshmukh"    "dadarao turerao deshmukh"
9  4 "vaishnavi"    ""          "deshmukh"  "daughter"        "shrikant dadarao deshmukh"    "dadarao turerao deshmukh"
9  5 "shyam"        ""          "deshmukh"  "brother"         "shrikant dadarao deshmukh"    "dadarao turerao deshmukh"
9  6 "swati"        ""          "deshmukh"  "brother's wife"  "shrikant dadarao deshmukh"    "dadarao turerao deshmukh"
9  7 "nalini"       ""          "deshmukh"  "mother"          "shrikant dadarao deshmukh"    "dadarao turerao deshmukh"
10  1 "sanjay"       "sukhdev"   "nagolkar"  "head"            "sanjay sukhdev nagolkar"      "sukhdev"                 
10  2 "chhaya"       ""          "nagolkar"  "wife"            "sanjay sukhdev nagolkar"      "sukhdev"                 
10  3 "sukhdev"      ""          "nagolkar"  "father"          "sanjay sukhdev nagolkar"      "sukhdev"                 
10  4 "parvatabai"   ""          "nagolkar"  "mother"          "sanjay sukhdev nagolkar"      "sukhdev"                 
10  5 "jay"          ""          "nagolkar"  "son"             "sanjay sukhdev nagolkar"      "sukhdev"                 
10  6 "gopalkrishna" ""          "nagolkar"  "son"             "sanjay sukhdev nagolkar"      "sukhdev"                 
10  7 "bebi"         ""          "nagolkar"  "sister"          "sanjay sukhdev nagolkar"      "sukhdev"                 
11  1 "madhav"       "apparao"   "deshmukh"  "head"            "madhav apparao deshmukh"      "apparao rustam deshmukh" 
11  2 "shalini"      ""          "deshmukh"  "wife"            "madhav apparao deshmukh"      "apparao rustam deshmukh" 
11  3 "priti"        ""          "deshmukh"  "daughter"        "madhav apparao deshmukh"      "apparao rustam deshmukh" 
11  4 "swati"        ""          "deshmukh"  "daughter"        "madhav apparao deshmukh"      "apparao rustam deshmukh" 
11  5 "gayatri"      ""          "deshmukh"  "daughter"        "madhav apparao deshmukh"      "apparao rustam deshmukh" 
12  1 "ashok"        "jayram"    "tandulkar" "head"            "ashok jayram tandulkar"       "jayram baliram tandulkar"
12  2 "geeta"        ""          "tandulkar" "wife"            "ashok jayram tandulkar"       "jayram baliram tandulkar"
12  3 "yogesh"       ""          "tandulkar" "son"             "ashok jayram tandulkar"       "jayram baliram tandulkar"
12  4 "avinash"      ""          "tandulkar" "son"             "ashok jayram tandulkar"       "jayram baliram tandulkar"
13  1 "dnyaneshwar"  "vitthal"   "nagolkar"  "head"            "dhyaneshwar vitthal nagolkar" "vitthal nagolkar"        
13  2 "tarabai"      ""          "nagolkar"  "wife"            "dhyaneshwar vitthal nagolkar" "vitthal nagolkar"        
13  3 "vanita"       ""          "nagolkar"  "wife"            "dhyaneshwar vitthal nagolkar" "vitthal nagolkar"        
13  4 "nilima"       ""          "nagolkar"  "daughter"        "dhyaneshwar vitthal nagolkar" "vitthal nagolkar"        
13  5 "pooja"        ""          "nagolkar"  "daughter"        "dhyaneshwar vitthal nagolkar" "vitthal nagolkar"        
13  6 "rohan"        ""          "nagolkar"  "son"             "dhyaneshwar vitthal nagolkar" "vitthal nagolkar"        
14  1 "narendra"     "onkar"     "kalekar"   "head"            "narendra kalekar"             "onkar lobhji"            
14  2 "asha"         ""          "kalekar"   "wife"            "narendra kalekar"             "onkar lobhji"            
14  3 "mayuri"       ""          "kalekar"   "daughter"        "narendra kalekar"             "onkar lobhji"            
14  4 "shiva"        ""          "kalekar"   "son"             "narendra kalekar"             "onkar lobhji"            
14  5 "narmada"      ""          "kalekar"   "mother"          "narendra kalekar"             "onkar lobhji"            
15  1 "wasudev"      "namdev"    "dhore"     "head"            "wasudev namdev dhore"         "namdev"                  
15  2 "rukhmini"     ""          "dhore"     "wife"            "wasudev namdev dhore"         "namdev"                  
15  3 "hiraman"      ""          "dhore"     "son"             "wasudev namdev dhore"         "namdev"                  
15  4 "vandana"      ""          "dhore"     "daughter-in-law" "wasudev namdev dhore"         "namdev"                  
15  5 "punam"        ""          "dhore"     "grand daughter"  "wasudev namdev dhore"         "namdev"                  
15  6 "vaishnavi"    ""          "dhore"     "grand daughter"  "wasudev namdev dhore"         "namdev"                  
15  7 "bhagyashri"   ""          "dhore"     "grand daughter"  "wasudev namdev dhore"         "namdev"                  
15  8 "nayana"       ""          "dhore"     "grand daughter"  "wasudev namdev dhore"         "namdev"                  
15  9 "hemraj"       ""          "dhore"     "son"             "wasudev namdev dhore"         "namdev"                  
15 10 "padma"        ""          "dhore"     "daughter-in-law" "wasudev namdev dhore"         "namdev"                  
15 11 "mamta"        ""          "dhore"     "grand daughter"  "wasudev namdev dhore"         "namdev"                  
15 12 "nikita"       ""          "dhore"     "grand daughter"  "wasudev namdev dhore"         "namdev"                  
15 13 "pranay"       ""          "dhore"     "grand son"       "wasudev namdev dhore"         "namdev"                  
15 14 "ramarao"      ""          "dhore"     "brother"         "wasudev namdev dhore"         "namdev"                  
16  1 "karim"        "abdul"     "shekh"     "head"            "sk karim sk abdul"            "sk abdul sk hedar"       
16  2 "sahidabai"    ""          "shekh"     "wife"            "sk karim sk abdul"            "sk abdul sk hedar"       
16  3 "saleem"       ""          "shekh"     "son"             "sk karim sk abdul"            "sk abdul sk hedar"       
16  4 "farhana"      ""          "shekh"     "daughter-in-law" "sk karim sk abdul"            "sk abdul sk hedar"       
16  5 "najim"        ""          "shekh"     "grand son"       "sk karim sk abdul"            "sk abdul sk hedar"       
16  6 "munna"        ""          "shekh"     "grand son"       "sk karim sk abdul"            "sk abdul sk hedar"       
16  7 "kaleem"       ""          "shekh"     "son"             "sk karim sk abdul"            "sk abdul sk hedar"       
16  8 "shahenaj"     ""          "shekh"     "daughter-in-law" "sk karim sk abdul"            "sk abdul sk hedar"       
16  9 "sheyabaj"     ""          "shekh"     "grand son"       "sk karim sk abdul"            "sk abdul sk hedar"       
16 10 "maksud"       ""          "shekh"     "son"             "sk karim sk abdul"            "sk abdul sk hedar"       
16 11 "summaiya"     ""          "shekh"     "daughter-in-law" "sk karim sk abdul"            "sk abdul sk hedar"       
17  1 "devendra"     "mohan"     "gosawi"    "head"            "devendraban mohanban gosawi"  "mohanban devban gosawi"  
17  2 "yogita"       ""          "gosawi"    "wife"            "devendraban mohanban gosawi"  "mohanban devban gosawi"  
17  3 "radha"        ""          "gosawi"    "daughter"        "devendraban mohanban gosawi"  "mohanban devban gosawi"  
17  4 "anand"        ""          "gosawi"    "son"             "devendraban mohanban gosawi"  "mohanban devban gosawi"  
17  5 "mohanban"     ""          "gosawi"    "father"          "devendraban mohanban gosawi"  "mohanban devban gosawi"  
end

[Clyde Schechter]

frame put chs_id mem_name1 if relation == "head", into(heads)
frame heads: isid chs_id, sort    // VERIFY ONLY ONE HEAD IN ANY HOUSEHOLD

frlink m:1 chs_id, frame(heads)
replace mem_name2 = frval(heads, mem_name1) if missing(mem_name2) ///
    & inlist(relation, "son", "daughter", "wife")
    
drop heads
frame drop heads

Note: The problem is only well-posed on the condition that there is only one head in any household. This condition is verified in the second line of the code. If the program gives an error message and halts after that line, then there is some household (perhaps more than one) with multiple heads and the proposed resolution of mem_name2 is not defined. Do not proceed with the rest of the code if that happens.

[rahul kumar singh]

Thanks Clyde,
It works