| Creating members sleeping per room [message #24637] |
Mon, 13 June 2022 01:55  |
Preksha Mishra
Messages: 5
Registered: June 2022
|
Member |
|
|
Hi,
I am trying to recreate table Table 2.3 of NFHS-4(2015-16) India for number of members sleeping per room. I tried the code provided with the wealth index construction for the year (I ran a code in R based on the following:
if (hhusual=0) hhusual=hhslept.
if (QH45>0) memsleep=trunc(hhusual/QH45).
if (QH45=0) memsleep=hhusual.
if (missing(QH45) or QH45>=99 or memsleep>=98) memsleep=99.
variable labels memsleep 'Number of members per sleeping room'.
value labels memsleep 0 'Less than 1 per room'.
formats memsleep (f2.0).
missing values memsleep (99).
In this case my figures don't match the ones in Table 2.3. Most importantly, I did not get any missing values while the table suggests 0.1% missing values.
Next I tried, considering all household with 0 usual members, while keeping rest the same. Here, although the missing value matched, none of the other figures matched, though they were close.
Is it the case that methodology for recreating the table 2.3 is different from recreating the memsleep variable for PCA. If yes, could you please tell me how to do these matches.
Any help would be much appreciated
|
|
|
|
The DHS Program User Forum
Members
Search
Help
Register
Login
Home
