The DHS Program User Forum: Ethiopia » Problem with dates in the Ethiopia datasets

Home » Countries » Ethiopia » Problem with dates in the Ethiopia datasets

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

Re: Problem with dates in the Ethiopia datasets [message #26318 is a reply to message #9183]

Tue, 07 March 2023 13:36

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

Report message to a moderator

[Message index]

		Problem with dates in the Ethiopia datasets By: DHS user on Wed, 20 February 2013 11:19
		Re: Problem with dates in the Ethiopia datasets By: Bridgette-DHS on Wed, 20 February 2013 11:28
		Re: Problem with dates in the Ethiopia datasets By: lillo?S on Fri, 22 January 2016 12:02
		Re: Problem with dates in the Ethiopia datasets By: lillo?S on Fri, 22 January 2016 12:04
		Re: Problem with dates in the Ethiopia datasets By: Bridgette-DHS on Fri, 29 January 2016 12:56
		Re: Problem with dates in the Ethiopia datasets By: st89 on Fri, 19 February 2016 10:12
		Re: Problem with dates in the Ethiopia datasets By: Bridgette-DHS on Fri, 19 February 2016 12:02
		Re: Problem with dates in the Ethiopia datasets By: kcaglaya@tulane.edu on Fri, 17 November 2017 12:39
		Re: Problem with dates in the Ethiopia datasets By: Bridgette-DHS on Mon, 18 December 2017 12:26
		Re: Problem with dates in the Ethiopia datasets By: kcaglaya@tulane.edu on Mon, 18 December 2017 13:21
		Re: Problem with dates in the Ethiopia datasets By: Bridgette-DHS on Mon, 18 December 2017 17:15
		Re: Problem with dates in the Ethiopia datasets By: Bridgette-DHS on Tue, 19 December 2017 14:31
		Re: Problem with dates in the Ethiopia datasets By: kcaglaya@tulane.edu on Tue, 19 December 2017 14:50
		Re: Problem with dates in the Ethiopia datasets By: Bridgette-DHS on Tue, 19 December 2017 16:31
		Re: Problem with dates in the Ethiopia datasets By: kcaglaya@tulane.edu on Tue, 19 December 2017 17:03
		Re: Problem with dates in the Ethiopia datasets By: Ogriv on Tue, 05 February 2019 10:36
		Re: Problem with dates in the Ethiopia datasets By: kcaglaya@tulane.edu on Tue, 05 February 2019 10:48
		Re: Problem with dates in the Ethiopia datasets By: Ogriv on Tue, 05 February 2019 12:14
		Re: Problem with dates in the Ethiopia datasets By: Ogriv on Wed, 06 February 2019 08:05
		Re: Problem with dates in the Ethiopia datasets By: Ogriv on Wed, 06 February 2019 09:01
		Re: Problem with dates in the Ethiopia datasets By: kcaglaya@tulane.edu on Wed, 06 February 2019 09:03
		Re: Problem with dates in the Ethiopia datasets By: Ogriv on Wed, 06 February 2019 09:09
		Re: Problem with dates in the Ethiopia datasets By: Ogriv on Wed, 06 February 2019 09:15
		Re: Problem with dates in the Ethiopia datasets By: kcaglaya@tulane.edu on Wed, 06 February 2019 09:21
		Re: Problem with dates in the Ethiopia datasets By: Ogriv on Wed, 06 February 2019 09:26
		Re: Problem with dates in the Ethiopia datasets By: VictorJanVilla on Tue, 07 March 2023 13:36
		Re: Problem with dates in the Ethiopia datasets By: Bridgette-DHS on Tue, 07 March 2023 16:05
		Re: Problem with dates in the Ethiopia datasets By: Mark on Wed, 01 May 2019 01:56
		Re: Problem with dates in the Ethiopia datasets By: Bridgette-DHS on Mon, 06 May 2019 07:55
		Re: Problem with dates in the Ethiopia datasets By: kbhan89 on Tue, 21 April 2020 16:19
		Re: Problem with dates in the Ethiopia datasets By: Trevor-DHS on Wed, 20 May 2020 10:16

Previous Topic:	Multilevel Regression Analysis
Next Topic:	Trend Analysis

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sat Nov 30 06:12:04 Coordinated Universal Time 2024