Dear all,
I need to create a variable which identifies, for each individual, the following statuses: Childless individual (x = 0); Parents in couple, living with children (x = 1); Single parent, non-resident with children (x = 2); and Single parent, co-resident with children (x = 3).

Can someone please help me? Thank you very much! I think I need some kind of loop but I can't find the solution on my own. I have the following variables in a panel dataset:

wave: year of the survey
pid: personal identifier
hhid: household identifier
headid: head of the household identifier
link: link to the head of the household (e.g., 0= reference person, 1= husband/wife, 2= brother/sister)
pid_parent1: parent1 personal identifier (parent affiliation with children’s pid)
pid_parent2: parent2 personal identifier (parent affiliation with children’s pid)
hhtype: household type (e.g., 0= single, childless, 1= single, with child, 2= in couple, childless)


My problem is that the variable “hhtype” doesn't allow me to identify non-resident household members.

Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input int wave str16 pid float hhid str16 headid byte link str16(pid_parent1 pid_parent2) str10 hhtype
2000 "8A47EDF23C255104" 30074674 "8A47EDF23C255104"  1 "9CE6E2CD8D9E0967" "1F56F1A97B14F2D0" "12"
2001 "8A47EDF23C255104" 30073988 "8A47EDF23C255104"  1 "9CE6E2CD8D9E0967" "1F56F1A97B14F2D0" "12"
   . "8A47EFC1D78B2B46"        . ""                  . " "                " "                ""    
   . "8A47EFC1D78B2B46"        . ""                  . " "                " "                ""    
2000 "8HUYJ27AE2740D42" 30411832 "DFB9AC98F5E3FA7A"  3 "DFB9AC98F5E3FA7A" "2812904AD0AC7AAE" "12"
2001 "8HUYJ27AE2740D42" 30410376 "DFB9AC98F5E3FA7A"  3 "DFB9AC98F5E3FA7A" "2812904AD0AC7AAE" "12"
   . "8HUYJ28FFEC10247"        . ""                  . "2FDA53ADA71EF4E0" " "                ""    
   . "8HUYJ28FFEC10247"        . ""                  . "2FDA53ADA71EF4E0" " "                ""    
2000 "8HUYJ32BE8D6104C" 20395584 "74087C059D291E86"  3 "037C1D94D73DD51A" "74087C059D291E86" "13"
2001 "8HUYJ32BE8D6104C" 20399144 "74087C059D291E86"  3 "037C1D94D73DD51A" "74087C059D291E86" "13"
   . "8HUYJ350890281F2"        . ""                  . "644A77491532D805" "318B370004E2BE73" ""    
   . "8HUYJ350890281F2"        . ""                  . "644A77491532D805" "318B370004E2BE73" ""    
2000 "8HUYJ4A99DE56F36" 20702236 "8HUYJ4A99DE56F36"  1 "3D958D9B9B2C0CE5" "C8ADB0A0AD138BA0" "22"
2001 "8HUYJ4A99DE56F36" 30414460 "8HUYJ4A99DE56F36"  1 "3D958D9B9B2C0CE5" "C8ADB0A0AD138BA0" "12"
2000 "8HUYJ5A1E276A1BB" 30070316 "8HUYJ5A1E276A1BB"  1 " "                " "                "12"
2001 "8HUYJ5A1E276A1BB" 20077826 "8HUYJ5A1E276A1BB"  1 " "                " "                "22"
2000 "8HUYJ600771F2205" 20692674 "8HUYJ600771F2205"  1 "DF1BB0137D277C6C" "CBF20E0A533ACFCF" "25"
2001 "8HUYJ600771F2205" 20700692 "8HUYJ600771F2205"  1 "DF1BB0137D277C6C" "CBF20E0A533ACFCF" "25"
   . "8HUYJ895345AFAF8"        . ""                  . "2F6DC1B6B344C5FE" "509B7597B177EC06" ""    
   . "8HUYJ895345AFAF8"        . ""                  . "2F6DC1B6B344C5FE" "509B7597B177EC06" ""    
2000 "8HUYJ8EBABD97712" 30160574 "85A2744174D3D16B"  3 "85A2744174D3D16B" "032B3F0DBD7488A4" "12"
2001 "8HUYJ8EBABD97712" 30159324 "85A2744174D3D16B"  3 "85A2744174D3D16B" "032B3F0DBD7488A4" "12"
2000 "8HUYJ9669EBC739C" 30110714 "8977AD4E8BEA8257"  2 "F0ABF1DE6A43794D" "0C1E850B77C07F0F" "12"
2001 "8HUYJ9669EBC739C" 30109768 "8977AD4E8BEA8257"  2 "F0ABF1DE6A43794D" "0C1E850B77C07F0F" "12"
   . "8HUYJA13A9954D68"        . ""                  . "F38B2C2EA6316F4C" "99FDAB3744A98129" ""    
   . "8HUYJA13A9954D68"        . ""                  . "F38B2C2EA6316F4C" "99FDAB3744A98129" ""    
2000 "8HUYJABBBE507D78" 31180656 "8HUYJABBBE507D78"  1 "5DADE26D41C24ADC" "97D1AE74E14591BD" "12"
2001 "8HUYJABBBE507D78" 31174480 "8HUYJABBBE507D78"  1 "5DADE26D41C24ADC" "97D1AE74E14591BD" "12"
   . "8HUYJB030E64971B"        . ""                  . " "                " "                ""    
   . "8HUYJB030E64971B"        . ""                  . " "                " "                ""    
   . "8HUYJBC805AFE178"        . ""                  . "6011F6042D2A231F" "195BECE24EE0E67D" ""    
   . "8HUYJBC805AFE178"        . ""                  . "6011F6042D2A231F" "195BECE24EE0E67D" ""    
   . "8HUYJE0EC5D0B528"        . ""                  . "25063F8A479EF0F5" "6E0CF06E330EB7EC" ""    
   . "8HUYJE0EC5D0B528"        . ""                  . "25063F8A479EF0F5" "6E0CF06E330EB7EC" ""    
2000 "8HUYJF611F4CFEF4" 30098148 "8HUYJF611F4CFEF4"  1 " "                " "                "12"
2001 "8HUYJF611F4CFEF4" 30097304 "8HUYJF611F4CFEF4"  1 " "                " "                "12"
2000 "980U01D75F92AE49" 31332120 "AE500B70D5B901E7"  3 "AE500B70D5B901E7" " "                "12"
2001 "980U01D75F92AE49" 21144020 "4486B8DE2C42ADE0" 22 "AE500B70D5B901E7" " "                "25"
2000 "980U0226F7496F34" 30454348 "4FCC110A02B081CB"  3 "4FCC110A02B081CB" "ED0AB4A570FF045A" "12"
2001 "980U0226F7496F34" 30452874 "4FCC110A02B081CB"  3 "4FCC110A02B081CB" "ED0AB4A570FF045A" "12"
2000 "980U0367A4D9AF03" 21092720 "DCCBCD168C0CB2A6"  2 " "                " "                "22"
2001 "980U0367A4D9AF03" 21104028 "DCCBCD168C0CB2A6"  2 " "                " "                "22"
   . "980U094C0ED14755"        . ""                  . "ECE50D8380ED729D" "D662C363DCCB26D4" ""    
   . "980U094C0ED14755"        . ""                  . "ECE50D8380ED729D" "D662C363DCCB26D4" ""    
2000 "980U0C3DE6264EEC" 30306404 "1E8F1921BC8D794D"  3 "1E8F1921BC8D794D" "FBE1D5052B8948CD" "12"
2001 "980U0C3DE6264EEC" 30305140 "1E8F1921BC8D794D"  3 "1E8F1921BC8D794D" "FBE1D5052B8948CD" "12"
2000 "980U0EDE3CE1A33E" 21297586 "980U0EDE3CE1A33E"  1 "A11DA74A33AA2179" "1D55F2085F1AB972" "25"
2001 "980U0EDE3CE1A33E" 21312752 "980U0EDE3CE1A33E"  1 "A11DA74A33AA2179" "1D55F2085F1AB972" "25"
   . "980U0FEC70C0FA60"        . ""                  . " "                " "                ""    
   . "980U0FEC70C0FA60"        . ""                  . " "                " "                ""    
2000 "980U1162BEC3D0F7" 21063796 "9C0FD84F920FB27D"  3 "F366417BF80AA5C0" "9C0FD84F920FB27D" "13"
end
label values n3lien n3lien
label def n3lien 1 "REFERENCE", modify
label def n3lien 2 "husband,wife", modify
label def n3lien 3 "son,daughter", modify
label def n3lien 22 "other,unrelated age 16+", modify