请问如何删除孩子全部为空的家庭(就是tb1y_a_c1到tb1y_a_c5的数值均为-8或-9,tb1y_c*是孩子的编号)。条件为若家庭fid16两个pid编码一样,或者只有一个pid的fid,他们的tb1y_a_c*=-8或-9,即删除。标黄行即为需要删除的家庭。谢谢!
[CODE]
* Example generated by -dataex-. To install: ssc install dataex
clear
input str7 fid16 long pid int tb1y_a_p double pid_s int(tb1y_a_s tb1y_a_c1 tb1y_a_c2 tb1y_a_c3 tb1y_a_c4 tb1y_a_c5)
"103788" 211952103 1985 103788501 1987 2014 -8 -8 -8 -8
"103924" 103924503 1982 220098103 1982 2011 -8 -8 -8 -8
"103924" 220098103 1982 103924503 1982 2011 -8 -8 -8 -8
"103952" 220195103 1984 103952551 1988 -8 -8 -8 -8 -8
"105492" 310912103 1981 105492501 -9 2014 -8 -8 -8 -8
"106335" 312144106 1982 312144101 1982 2005 -8 -8 -8 -8
"106335" 312144431 1958 312144432 1956 1982 -8 -8 -8 -8
"106335" 312144432 1956 312144431 1958 1982 -8 -8 -8 -8
"107684" 360172101 1986 360172431 1980 2008 2014 -8 -8 -8
"107824" 350127103 1982 350127104 1987 2007 -8 -8 -8 -8
"108476" 108476551 1986 370212103 1987 2014 -8 -8 -8 -8
"108476" 370212103 1987 108476551 1986 2014 -8 -8 -8 -8
"108598" 370320102 1966 108598501 1966 -8 -8 -8 -8 -8
"109121" 410735106 1982 410735104 1983 2008 2012 -8 -8 -8
"109137" 410046102 1959 410046431 1958 1985 -8 -8 -8 -8
"109137" 410046431 1958 410046102 1959 1985 -8 -8 -8 -8
"109849" 109849551 1991 411631103 1993 -8 -8 -8 -8 -8
"109849" 411631103 1993 109849551 1991 -8 -8 -8 -8 -8
"110003" 110003101 1971 110003102 1975 1997 -8 -8 -8 -8
"110006" 110006101 1960 110006102 1962 1990 -8 -8 -8 -8
"110006" 110006103 1990 -8 -8 -8 -8 -8 -8 -8
end