I have a data-set which was captured for different houshold within a community it has 40,923 members and has 8,407 various households. Tha data contains Household Size (HHSIZE) and member number (MNO) each member of a houshold has a identify hhnsrrno
hhnsrrno. The HHSIZE needs to be consistent with number of individuals within a household but there are cases where the HHSIZE does not tally with number of individuals within the household. Please I will like to understand the command used to list only HHSIZE that do not tally with number of individulas within the household. Below is an extract of an output of such a command, I want to know what command was used to arrive at that out put. Note that the MNO (01 - 23) is a single househols with 23 members, the next count 01 - 13 is the next houshold with 13 members e.t.c. So what command was used to?
+------------------------------------------------+
| hhnsrrno mno hhsize |
|------------------------------------------------|
5091. | NC/NG/BOS/KUYI/1/036 01 6 |
5092. | NC/NG/BOS/KUYI/1/036 02 6 |
5093. | NC/NG/BOS/KUYI/1/036 03 6 |
5094. | NC/NG/BOS/KUYI/1/036 04 6 |
5095. | NC/NG/BOS/KUYI/1/036 05 6 |
|------------------------------------------------|
5096. | NC/NG/BOS/KUYI/1/036 06 6 |
5097. | NC/NG/BOS/KUYI/1/036 07 23 |
5098. | NC/NG/BOS/KUYI/1/036 08 23 |
5099. | NC/NG/BOS/KUYI/1/036 09 23 |
5100. | NC/NG/BOS/KUYI/1/036 10 23 |
|------------------------------------------------|
5101. | NC/NG/BOS/KUYI/1/036 11 23 |
5102. | NC/NG/BOS/KUYI/1/036 12 23 |
5103. | NC/NG/BOS/KUYI/1/036 13 23 |
5104. | NC/NG/BOS/KUYI/1/036 14 23 |
5105. | NC/NG/BOS/KUYI/1/036 15 23 |
|------------------------------------------------|
5106. | NC/NG/BOS/KUYI/1/036 16 23 |
5107. | NC/NG/BOS/KUYI/1/036 17 23 |
5108. | NC/NG/BOS/KUYI/1/036 18 23 |
5109. | NC/NG/BOS/KUYI/1/036 19 23 |
5110. | NC/NG/BOS/KUYI/1/036 20 23 |
|------------------------------------------------|
5111. | NC/NG/BOS/KUYI/1/036 21 23 |
5112. | NC/NG/BOS/KUYI/1/036 22 23 |
5113. | NC/NG/BOS/KUYI/1/036 23 23 |
5333. | NC/NG/BOS/NAKPANKUCHI/1/006 01 7 |
5334. | NC/NG/BOS/NAKPANKUCHI/1/006 02 13 |
|------------------------------------------------|
5335. | NC/NG/BOS/NAKPANKUCHI/1/006 03 13 |
5336. | NC/NG/BOS/NAKPANKUCHI/1/006 04 13 |
5337. | NC/NG/BOS/NAKPANKUCHI/1/006 05 13 |
5338. | NC/NG/BOS/NAKPANKUCHI/1/006 06 13 |
5339. | NC/NG/BOS/NAKPANKUCHI/1/006 07 13 |
|------------------------------------------------|
5340. | NC/NG/BOS/NAKPANKUCHI/1/006 08 13 |
5341. | NC/NG/BOS/NAKPANKUCHI/1/006 09 13 |
5342. | NC/NG/BOS/NAKPANKUCHI/1/006 10 13 |
5343. | NC/NG/BOS/NAKPANKUCHI/1/006 11 13 |
5344. | NC/NG/BOS/NAKPANKUCHI/1/006 12 13 |
|------------------------------------------------|
5345. | NC/NG/BOS/NAKPANKUCHI/1/006 13 13 |
9145. | NC/NG/GRA/DIKO/2/017 01 5 |
9146. | NC/NG/GRA/DIKO/2/017 02 5 |
9147. | NC/NG/GRA/DIKO/2/017 03 4 |
9148. | NC/NG/GRA/DIKO/2/017 04 4 |
|------------------------------------------------|
9149. | NC/NG/GRA/DIKO/2/017 05 5 |
9192. | NC/NG/GRA/DIKO/2/030 01 4 |
9193. | NC/NG/GRA/DIKO/2/030 02 6 |
9194. | NC/NG/GRA/DIKO/2/030 03 6 |
9195. | NC/NG/GRA/DIKO/2/030 04 6 |
|------------------------------------------------|
9196. | NC/NG/GRA/DIKO/2/030 05 6 |
9197. | NC/NG/GRA/DIKO/2/030 06 6 |
16647. | NC/NG/LVN/JIMA-YAFU/1/025 01 4 |
16648. | NC/NG/LVN/JIMA-YAFU/1/025 02 4 |
16649. | NC/NG/LVN/JIMA-YAFU/1/025 03 4 |
|------------------------------------------------|
16650. | NC/NG/LVN/JIMA-YAFU/1/025 04 4 |
16651. | NC/NG/LVN/JIMA-YAFU/1/025 05 5 |
24826. | NC/NG/MKW/LABEFU/1/023 01 4 |
24827. | NC/NG/MKW/LABEFU/1/023 02 6 |
24828. | NC/NG/MKW/LABEFU/1/023 03 4 |
|------------------------------------------------|