The DHS Program User Forum: Nutrition and Anthropometry » Merging z score data and child record of Egypt DHS 1995/1992

Home » Topics » Nutrition and Anthropometry » Merging z score data and child record of Egypt DHS 1995/1992

Show: Today's Messages :: Show Polls :: Message Navigator

Merging z score data and child record of Egypt DHS 1995/1992 [message #14168]

Wed, 28 February 2018 16:49

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

Report message to a moderator

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

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.

Report message to a moderator

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

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

Report message to a moderator

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

Reduced-For(u)m
Messages: 292
Registered: March 2013

Senior Member

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

Report message to a moderator

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

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

Report message to a moderator

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

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

Report message to a moderator

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

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.

Report message to a moderator

Previous Topic:	DHS Household Weights - Arrondisment Scale
Next Topic:	anthropocentric data of egypt men

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sat Dec 21 13:35:01 Coordinated Universal Time 2024