The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Countries » Ethiopia » Problem with dates in the Ethiopia datasets
Re: Problem with dates in the Ethiopia datasets [message #26318 is a reply to message #9183] Tue, 07 March 2023 13:36 Go to previous messageGo to previous message
VictorJanVilla is currently offline  VictorJanVilla
Messages: 1
Registered: March 2023
Location: Nairobi
Member
Hi,

Sorry to bring up this issue again.

I'm currently working on all the available Ethiopia DHS data on Stata. Reading the conversation I saw a few possible solutions to convert the Ethiopian date to gregorian.

I am mainly interested in the year and month of the interview since I am merging these datasets with external climatic data and thus, I would like to obtain the most precise date possible.

Trying the following commands shared by Bridgette-DHS:

gen vg008=v008+92
gen vg007=int((vg008-1)/12)
gen vg006=(vg008-12)*v007 //// I included parenthesis in here
replace vg007=vg007+1900

This strategy works for the year but not for the months(since it does not give months' values). I saw that other users have simply assigned the same month to the CMC, which I think is not the right approach.

I also checked with 2000 and 2005 rounds that include gregorian dates and the gen "vg006=(vg008-12)*v007" do not respect the distribution of the months in gregorian format.

Did anyone solve this problem?

Thank you very much in advance!

Best,

Victor
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
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: Multilevel Regression Analysis
Next Topic: Trend Analysis
Goto Forum:
  


Current Time: Thu May 23 11:14:52 Coordinated Universal Time 2024