Checking for Missing Head of Houshold within a household
Hello, I have a data set on household survey where the household size, member of the household number, Age, Date of Birth, Relationship to the Head of the household and their Gender. Sample shown below
Key: In Relationship 1=Head of Household(HHH), 2=Spouse to HHH, 3=Child to HHH.
In HHSize 2=there are only two members in the household, 7=there are 7 members with that household
In MNO 01= 1st position as Head of Household, 02= 2nd position & Spouse to HHH, 03=3rd position, etc..
In SEX 1= Male and 2= Female
Questions:
1. What command can I use to check for Missing Head within a Household?
2. What command should I use to verify if the number of occurrence of House Size (HHSIZE) tally with number of occurrence of the Member of Household (MNO)
| HHSIZE | MNO | SEX | RELATIONSHIP | DOB | AGEY |
| 2 | 02 | 2 | 2 | 11-03-1978 | 40 |
| 2 | 01 | 1 | 1 | 22-02-1968 | 50 |
| 7 | 03 | 1 | 3 | 14-05-2008 | 10 |
| 7 | 02 | 2 | 2 | 28-03-1978 | 40 |
| 7 | 01 | 1 | 1 | 11-05-1968 | 50 |
| 7 | 06 | 1 | 3 | 16-02-2010 | 8 |
| 7 | 07 | 1 | 3 | 14-02-2006 | 12 |
| 7 | 04 | 1 | 3 | 10-05-2009 | 9 |
| 7 | 05 | 1 | 3 | 14-05-2008 | 10 |
Key: In Relationship 1=Head of Household(HHH), 2=Spouse to HHH, 3=Child to HHH.
In HHSize 2=there are only two members in the household, 7=there are 7 members with that household
In MNO 01= 1st position as Head of Household, 02= 2nd position & Spouse to HHH, 03=3rd position, etc..
In SEX 1= Male and 2= Female
Questions:
1. What command can I use to check for Missing Head within a Household?
2. What command should I use to verify if the number of occurrence of House Size (HHSIZE) tally with number of occurrence of the Member of Household (MNO)
Comment