The DHS Program User Forum: Dataset use in Stata » Reshaping Kenya's DHS dataset

Home » Data » Dataset use in Stata » Reshaping Kenya's DHS dataset (Reshaping Kenya's DHS dataset - need to know how to reshape and form unique ID's)

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

Reshaping Kenya's DHS dataset [message #27894]

Wed, 18 October 2023 02:55

Ritapriya Bandyopadhyay is currently offline

Ritapriya Bandyopadhyay
Messages: 19
Registered: October 2023

Member

Hi, I am trying to reshape the Kenya DHS data.
Now, I believe the data is in wide format, so hv104_01-hv104_24 - represent the sex of each household member within a household? How to go forward with the reshaping?

Also, I want to create a unique household ID and a unique individual ID. The problem is, when I create a unique individual ID before reshaping to long - all individuals in the household gets the same unique ID, hence should I do this after reshaping to long?

Would greatly appreciate your help

Best
Ritapriya

Attachment: Capture.PNG
(Size: 64.19KB, Downloaded 404 times)
Attachment: Capture.PNG
(Size: 55.24KB, Downloaded 402 times)

Report message to a moderator

[Message index]

		Reshaping Kenya's DHS dataset By: Ritapriya Bandyopadhyay on Wed, 18 October 2023 02:55
		Re: Reshaping Kenya's DHS dataset By: Bridgette-DHS on Thu, 19 October 2023 08:33
		Re: Reshaping Kenya's DHS dataset By: Ritapriya Bandyopadhyay on Thu, 19 October 2023 09:04
		Re: Reshaping Kenya's DHS dataset By: Bridgette-DHS on Thu, 19 October 2023 10:55
		Re: Reshaping Kenya's DHS dataset By: Ritapriya Bandyopadhyay on Thu, 26 October 2023 01:49
		Re: Reshaping Kenya's DHS dataset By: Bridgette-DHS on Tue, 21 November 2023 09:16

Previous Topic:	GMHS and Weighting
Next Topic:	Tabulating cluster and outcome variable

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sun Jan 11 14:08:25 Coordinated Universal Time 2026