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

]]>

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.]]>

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.]]>

Any advice on how to get the absolute years, months and dates from Nepali to Gregoarian format? Thanks!]]>

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. ]]>

]]>

Thank you very much!

T

]]>

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

Thanks.]]>

If I send you my email, could I too get the excel sheet to convert dates?

]]>

R]]>

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

Best

K]]>

Would you mind also sending me the excel sheet for date conversion? My email is sloos@stanford.edu

Thanks!

sabine]]>

Please send me the excel sheet for date conversion in my email umeth.th@gmail.com

Thanks!]]>

I would like to request the excel sheet for date conversion as well. My email address is: fuller14@uw.edu

Thanks!

John]]>

For converting dates, there are a couple of things you can do:

1) Convert century month codes (e.g. v008). This is not exact as the Nepali months start in the middle of the Western months, but approximately you can subtract 681 months from the Century month code to be equivalent to the Western calendar's century month code.

2) Convert century day codes (e.g. v008a). To convert the century day codes in the dataset to Western version, add 15809. For example, Shrawan 18, 2073 (century day code 26775) is the same as August 2, 2016 which would be century day code 42584, and 42584-26775=15809.

You can then check the day, month, or year of any value in Excel by using the following formulae:

If cell A1 is 42584 then

=day(A1) would give 2

=month(A1) would give 8

=year(A1) would give 2016

If you want to produce day, month and year variables in Stata, you can do the following:

* Adjust to Stata date - add 15809 to adjust for the calendars, and subtract 21916 as Stata counts days from 1/1/1960

gen v008a_stata=v008a+15809-21916

* Get day, month and year from Stata date

gen v008a_d=day(v008a_stata)

gen v008a_m=month(v008a_stata)

gen v008a_y=year(v008a_stata)

You can then re-create the century month code if you want to from these as cmc=(v008a_y - 1900) * 12 + v008_m.]]>