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:
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)