Dear All,

I want to know how we check whether in each HH there is at least one member with income (r6). Identify household where they are members who all no income

Below is an example of my dataset.

copy starting from the next line ------ ----------------
Code:
* Example generated by -dataex-. To install: ssc install    dataex
clear
input float obs_no byte(r1 r2) int r6
1 1  1  8
2 2  2 12
3 1  3 12
4 1  3 12
1 1  1  6
2 2  2 12
3 2  4  5
4 2  4 12
5 2  4 12
6 2  4 12
7 1 11 12
8 1 11 12
9 1 11 12
1 1  1  6
2 2  2  6
1 1  1  9
1 2  1 12
1 2  1  4
2 2  6 12
1 2  1  5
2 2  6 12
3 2  4 12
1 1  2  7
2 2  1 12
3 1  3 12
4 2  4 12
5 1  3 12
1 1  1  8
1 2  1  9
2 2  4 12
3 1  3 12
4 1  3 12
1 1  1  3
2 2  2  2
3 2 14 12
1 1  1 11
2 2  2 11
3 1  3 12
4 2  4 12
1 2  1  1
2 1  2  2
3 2  4 12
1 1  1  5
2 2  2  1
1 1  2  6
2 2  1  6
3 2  4 12
4 1  3 12
1 2  1  6
2 1  2  9
3 2  4 12
4 2  4 12
1 1  1  3
2 2  2 12
3 1  3 12
4 1  3 12
5 2  4 12
6 2 18 12
7 1 11 12
8 1 11 12
1 1  1 12
2 2  4 12
3 1  3 12
4 1 11  8
5 2 12 12
6 2 12 12
7 2 12 12
8 1 22 12
9 1 22 12
10 1 22 12
11 1 17 12
1 1  1  6
2 2  2  1
3 2  4 12
4 2  4 12
5 2  4 12
1 1  1  6
2 2  2 12
3 1  3 12
4 1  3 12
5 2  4 12
1 1  2  6
2 2  1  1
3 1  3  1
4 2  4  1
1 2  1 10
2 1  5 12
3 2  6 12
4 1  3 12
5 1  7 12
1 1  1 12
2 2  2 12
3 2  4 12
4 2  4 12
5 2  4 12
1 2  1  7
2 1  3  8
1 1  1  5
2 2  2 12
3 1  3 12
end
label values r1 r1
label def r1 1 "Male", modify
label def r1 2 "Female", modify
label values r2 r2
label def r2 1 "Head", modify
label def r2 2 "Spouse", modify
label def r2 3 "Son", modify
label def r2 4 "Daughter", modify
label def r2 5 "Father", modify
label def r2 6 "Mother", modify
label def r2 7 "Brother", modify
label def r2 11 "Grand-son", modify
label def r2 12 "Grand-daughter", modify
label def r2 14 "Mother-in-law", modify
label def r2 17 "Son-in-law", modify
label def r2 18 "Daughter-in-law", modify
label def r2 22 "Nephew", modify
label values r6 r6
label def r6 1 "<3000", modify
label def r6 2 "3001-5000", modify
label def r6 3 "5001-7500", modify
label def r6 4 "7501-10,000", modify
label def r6 5 "10,001-15,000", modify
label def r6 6 "15,001- 20,000", modify
label def r6 7 "20,001-25,000", modify
label def r6 8 "25,001 – 30,000", modify
label def r6 9 "30,001-40,000", modify
label def r6 10 "40,001-50,00", modify
label def r6 11 ">50,000", modify
label def r6 12 "No income", modify
copy up to and including the previous line - ----------------