The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » Nutrition and Anthropometry » Merging z score data and child record of Egypt DHS 1995/1992
Merging z score data and child record of Egypt DHS 1995/1992 [message #14168] Wed, 28 February 2018 16:49 Go to next message
yanping@hsph.harvard.edu is currently offline  yanping@hsph.harvard.edu
Messages: 6
Registered: February 2018
Location: Boston
Member
Dear DHS members and users,

I am trying to merge the WHO z score data with the child record data of DHS Egypt.

For Egypt DHS 1995: I am trying to merge the data of eghw33fl and EGKR33FL. As indicated in the word file named "merge", I should merge two two files by "V001, V002, B16 (child's line number in the household) in the Children Recode file". However, in the children's record file (EGKR33FL), there is no variable of B16, neither other variables labeling for child's line number in the household.

The same problem happens to EDHS 1992, but there is no problem for EDHS 2000,2003 and 2005.

Anybody has some ideas regarding child's line number in the household in KR files?

Thank you very much,
Yanping
Re: Merging z score data and child record of Egypt DHS 1995/1992 [message #14178 is a reply to message #14168] Thu, 01 March 2018 12:58 Go to previous messageGo to next message
Reduced-For(u)m
Messages: 292
Registered: March 2013
Senior Member

I think you can download the file with the WHO anthropometric scores already merged through the iPUMS DHS site, which is a very handy jew way to access and download DHS data. It appears to have all of the merged WHO variables for all of the Egypt surveys, but I haven't actually downloaded it myself through them.
Re: Merging z score data and child record of Egypt DHS 1995/1992 [message #14185 is a reply to message #14178] Fri, 02 March 2018 11:59 Go to previous messageGo to next message
yanping@hsph.harvard.edu is currently offline  yanping@hsph.harvard.edu
Messages: 6
Registered: February 2018
Location: Boston
Member
Thanks a lot for your reply. What's the meaning of iPUMS DHS site? is it a website?
Yanping
Re: Merging z score data and child record of Egypt DHS 1995/1992 [message #14186 is a reply to message #14185] Fri, 02 March 2018 12:07 Go to previous messageGo to next message
Reduced-For(u)m
Messages: 292
Registered: March 2013
Senior Member


https://www.idhsdata.org/idhs/

Re: Merging z score data and child record of Egypt DHS 1995/1992 [message #14187 is a reply to message #14186] Fri, 02 March 2018 12:21 Go to previous messageGo to next message
yanping@hsph.harvard.edu is currently offline  yanping@hsph.harvard.edu
Messages: 6
Registered: February 2018
Location: Boston
Member
Got it with many thanks, sorry for it, that's just where I got the data.

In the data download website, the already merged data (children data and z score data) is available for EDHS 2008 and EDHS2014, while the separate data could be merged by V001, V002 and B16 for EDHS 2005/2003/2000.

Only EDHS 1992 and EDHS 1995 have neither merged data nor B16 for merging.

I am trying to calculate the z score by myself with the WHO anthro standardized data.

Thanks again,
Yanping
Re: Merging z score data and child record of Egypt DHS 1995/1992 [message #14188 is a reply to message #14187] Fri, 02 March 2018 12:24 Go to previous messageGo to next message
yanping@hsph.harvard.edu is currently offline  yanping@hsph.harvard.edu
Messages: 6
Registered: February 2018
Location: Boston
Member
Sorry for the too quickly reply, shall I delete the message? I am working on the iPUMS now. Happy weekend, Yanping
Re: Merging z score data and child record of Egypt DHS 1995/1992 [message #14189 is a reply to message #14186] Fri, 02 March 2018 13:23 Go to previous message
yanping@hsph.harvard.edu is currently offline  yanping@hsph.harvard.edu
Messages: 6
Registered: February 2018
Location: Boston
Member
I just want to say thanks and the link works very good and very quickly: https://www.idhsdata.org/idhs/

Very appreciate,
Yanping

If possible, please delete my previous post.
Previous Topic: DHS Household Weights - Arrondisment Scale
Next Topic: anthropocentric data of egypt men
Goto Forum:
  


Current Time: Thu Mar 28 13:32:54 Coordinated Universal Time 2024