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 #16602 is a reply to message #16600]

Tue, 05 February 2019 10:48

kcaglaya@tulane.edu is currently offline

kcaglaya@tulane.edu
Messages: 7
Registered: November 2017

Member

Hi Sandra,

I don't know which software you are using, but here is the Stata code I wrote to convert the dates in 2011 and 2016 Surveys;

*Convert from Ethiopian to Gregorian for 2011 and 2016

foreach y of numlist 2011 2016 {

use "`projectdir'/data/eth_`y'_raw/etkr`y'dt/ETKR`y'FL.dta", clear

*observations with exact birhtday
replace hw16=. if hw16==98 | hw16==99
gen birthday_available=hw16!=.

gen y_gregorian=.
replace y_gregorian=b2+7 if (b1>=9 & hw16>=6) | b1>9
replace y_gregorian=b2+8 if (b1==9 & hw16<6) | b1<9
gen m_gregorian=b1

gen child_birthyear=y_gregorian
gen child_birthmonth=b1
gen child_birthday=hw16

gen child_birthdate_g_days=mdy(child_birthmonth, child_birthday, child_birthyear)
gen child_birthdate_gregorian=child_birthdate_g_days
format child_birthdate_gregorian %td

*convert interview date from Ethiopian to Gregorian Calendar
gen interview_y_gregorian=.
replace interview_y_gregorian=v007+7 if (v006>=9 & v016>=6) | v006>9
replace interview_y_gregorian=v007+8 if (v006==9 & v016<6) | v006<9
gen interview_m_gregorian=v006

gen interview_year=interview_y_gregorian
gen interview_month=v006
gen interview_day=v016

gen interview_date_g_days=mdy(interview_month, interview_day, interview_year)
gen interview_date_gregorian=interview_date_g_days
format interview_date_gregorian %td

tempfile `y'_temp

save "``y'_temp'"

}

Best,

Koray

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: Fri Nov 8 22:14:48 Coordinated Universal Time 2024