I need to create the variable type of household,
V1 V2 V3
11 11 1
11 11 6
12 11 1
12 11 2
12 11 9
12 11 3
13 11 1
13 11 2
13 11 3
15 11 1
15 11 2
15 11 3
16 11 1
17 11 1
17 11 2
18 11 1
18 11 2
18 11 3
18 11 3
21 21 1
21 21 2
21 21 3
21 21 3
21 21 3
V1=House V2=Household V3=Relationship with the head of household
Code V3
1 Head of Household
2 Mate
3 Son
4 Grandson
5 Son in law
6 Sister
7 Parents
8 Mother in law
9 Other
V1 V2 V3
11 11 1
11 11 6
12 11 1
12 11 2
12 11 9
12 11 3
13 11 1
13 11 2
13 11 3
15 11 1
15 11 2
15 11 3
16 11 1
17 11 1
17 11 2
18 11 1
18 11 2
18 11 3
18 11 3
21 21 1
21 21 2
21 21 3
21 21 3
21 21 3
V1=House V2=Household V3=Relationship with the head of household
Code V3
1 Head of Household
2 Mate
3 Son
4 Grandson
5 Son in law
6 Sister
7 Parents
8 Mother in law
9 Other