The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Countries » Nepal » CMC codes
CMC codes [message #60] Mon, 18 February 2013 17:53 Go to next message
DHS user is currently offline  DHS user
Messages: 92
Registered: February 2013
Senior Member
I am working with the DHS surveys in Nepal and have a question regarding the interview date (v008) for each of the surveys. When using your recommended formulas to convert these CMC dates to year and month formats, the years do not appear to correspond to the survey year. For example, I get years 1952 and 1953 for the 1996 survey wave.

Can you please advise as to how to obtain the correct year for this variable?

Re: CMC codes [message #155 is a reply to message #60] Tue, 19 March 2013 10:20 Go to previous messageGo to next message
Kerry is currently offline  Kerry
Messages: 9
Registered: March 2013
Member
The Nepal DHS datasets use the Nepali lunar calendar to format the CMC, which makes moot the standard conversion formula. I believe the Ethiopia surveys have a similar issue. It would be helpful for me as well if someone could share the Nepal-specific conversions.

Having the CMC formatted this way is of no consequence as long as you're not interested in an absolute date (e.g. survey year) but in a relative length of time, where you'd subtract one CMC from another.
Re: CMC codes [message #160 is a reply to message #155] Tue, 19 March 2013 18:25 Go to previous messageGo to next message
Trevor-DHS is currently offline  Trevor-DHS
Messages: 626
Registered: January 2013
Senior Member
The issue for Nepal is that the local calendar years were used in the calculation of CMCs instead of the Gregorian calendar that is used in the west. For example, the current year in Nepal is 2069 and it started on April 13, 2012. The standard CMC calculation is done, but using the Nepali dates, so April 2012 (CMC 1348 if using the Gregorian calendar) is CMC 2029 based on the Nepali dates. You can convert the CMCs to the Gregorian calendar by subtracting the difference (681). This is approximate as the Nepali month starts in the middle of the Gregorian month, but should be good enough for most purposes. This should work for each of the surveys, except for the 1996 survey. For the 1996 survey the years were recorded using 2 digit years and the Nepali year 2052 was recorded as just 52. For this survey to convert to Gregorian dates, add 519 to the CMC.

As Kerry points out for most analysis the fact that the CMC is based on the local calendar years has no effect on the analysis unless you are interested in absolute dates.
Re: CMC codes [message #216 is a reply to message #160] Thu, 28 March 2013 09:18 Go to previous messageGo to next message
Kerry is currently offline  Kerry
Messages: 9
Registered: March 2013
Member
Very helpful. Thanks!
Re: CMC codes [message #856 is a reply to message #216] Tue, 22 October 2013 13:42 Go to previous messageGo to next message
l.bliznashka is currently offline  l.bliznashka
Messages: 1
Registered: October 2013
Location: Washington, DC, USA
Member
I'm also working with the 2011 Nepal DHS (Children dataset), and trying to convert Nepali dates to Gregorian ones (birthday and interview years). For my analysis I need the absolute dates: date, month, and year. So, while your discussion is quite helpful, it's unfortunately not precise enough for my purposes.

Any advice on how to get the absolute years, months and dates from Nepali to Gregoarian format? Thanks!
Re: CMC codes [message #964 is a reply to message #856] Thu, 05 December 2013 23:52 Go to previous messageGo to next message
Trevor-DHS is currently offline  Trevor-DHS
Messages: 626
Registered: January 2013
Senior Member
We do not have code for converting nepal dates at the level of day, month and year to Gregorian dates in day, month and year form, but there are examples of the calculations needed available online. For example, there is code written in PHP at http://sourceforge.net/projects/nepalidateconve/ for converting nepali dates. You could use the code here and rewrite the equivalent calculations in the code for which ever software you are using for analysis. I realize that this doesn't fully solve your problem, but hopefully it provides enough information to be able to write the code necessary.
Re: CMC codes [message #8183 is a reply to message #964] Mon, 07 September 2015 14:58 Go to previous messageGo to next message
Rojan is currently offline  Rojan
Messages: 4
Registered: September 2015
Location: Kathmandu
Member
If we need exact English date of Nepali date then we need to convert it. I use to convert Nepali date into English date in MS Excel using conversion factor that I have prepared. If you still need to convert date and you are not getting solution, please write me. I can provide you excel file to convert Nepali date into English. you can convert many date at one time.
Re: CMC codes [message #15739 is a reply to message #8183] Mon, 10 September 2018 02:59 Go to previous messageGo to next message
timarthias is currently offline  timarthias
Messages: 2
Registered: September 2018
Location: Indonesia
Member
Hi Rojan,

I am working with Nepali 2018 datasets using Bikram system (including date, month and year) and need to convert them into Gregorian calendar. Would you happen to have the MS Excel conversion file for 2018? Or if you have ideas how to convert the dates using Stata. Thank you very much.
Re: CMC codes [message #15740 is a reply to message #15739] Mon, 10 September 2018 03:33 Go to previous messageGo to next message
Rojan is currently offline  Rojan
Messages: 4
Registered: September 2015
Location: Kathmandu
Member
Please send me your email address, I will send you the excel file.

Re: CMC codes [message #15741 is a reply to message #15740] Mon, 10 September 2018 05:24 Go to previous messageGo to next message
timarthias is currently offline  timarthias
Messages: 2
Registered: September 2018
Location: Indonesia
Member
It's timarthias@gmail.com
Thank you very much!


T
Re: CMC codes [message #15744 is a reply to message #15741] Mon, 10 September 2018 10:11 Go to previous messageGo to next message
Trevor-DHS is currently offline  Trevor-DHS
Messages: 626
Registered: January 2013
Senior Member
Hi Rojan,

Any chance that you can post the Excel spreadsheet here. It may be useful for other data users too.

Thanks.
Re: CMC codes [message #15927 is a reply to message #15740] Sat, 06 October 2018 20:43 Go to previous messageGo to next message
kmarchesi is currently offline  kmarchesi
Messages: 2
Registered: October 2018
Member
Hi Rojan,

If I send you my email, could I too get the excel sheet to convert dates?
Re: CMC codes [message #15928 is a reply to message #15927] Sun, 07 October 2018 00:13 Go to previous messageGo to next message
Rojan is currently offline  Rojan
Messages: 4
Registered: September 2015
Location: Kathmandu
Member
Yes. Please send me your email.

R
Re: CMC codes [message #15931 is a reply to message #15928] Sun, 07 October 2018 10:39 Go to previous message
kmarchesi is currently offline  kmarchesi
Messages: 2
Registered: October 2018
Member
Hi Rojan

My email is kmarchesi@clarku.edu. Thank you so much.

Best
K
Previous Topic: Identifying migrants & merging with PR file
Next Topic: Child anthropometry in Nepal 2016 DHS
Goto Forum:
  


Current Time: Sun Dec 9 15:17:00 Eastern Standard Time 2018