The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Dataset access » Restructuring Healthcare data
Re: Restructuring Healthcare data [message #8118 is a reply to message #8112] Tue, 25 August 2015 12:26 Go to previous messageGo to previous message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3214
Registered: February 2013
Senior Member
Following is a response from Senior DHS Stata Specialist, Tom Pullum:

I can understand why you are having difficulty. I see that this information was not coded onto the PR file in an efficient way. Every record in the household has all the information about the visits of all the members. It would have been better to code the information about, say, the person on line 3, just onto line 3. I think the best way to deal with this is to separate the information you need out, organize it by line number, and then merge back with the PR file.

The attached program will do this. It is a text file; you will probably want to put it into the Stata do file editor. You will need to change the paths. You will want to add more variables; I have shown where to do this.

The program puts the health information about each person onto that person's record. The file will only include the specific people who have had a visit. Let me know if you have questions.
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Access to calendar data
Next Topic: Records missing in child survey for specific clusters
Goto Forum:
  


Current Time: Fri Dec 27 02:37:47 Coordinated Universal Time 2024