Convert dates from between Hijri (Islamic) and gregorian

[zana]

ِDear all,

I am struggling to find a way to convert date in a file data. Does anyone have a code that converts a Islamic date to Gregorian???

Any help is greatly appreciated.

Zana

[stefan_r]

I am trying to do the same and found a custom function ISLAMIC_TO_SD here:
http://www.sascommunity.org/wiki/Sometimes_One_Needs_an_Option_with_Unusual_Dates
(Click here to download the SAS code for creating Hebrew and Islamic calendar interval datasets)

However, I tested it with today's date (2014-10-23) and the Islamic date is off by one day (1435-12-28 instead of 1435-12-29).

I wonder if the author of that function could help...

[zana]

Thank you so much.

But i can't run each of them. Please say me how can i run these cod for convert an Islamic (e.g., 1380-10-28) to gregorian date!

Best regards

Zana

[OS2Rules]

Hi:

I noticed that the paper referred to was from Art - perhaps he can help you?

[art297]

wrote that part of the code and I've sent him a note referring to this thread.

[Ksharp]

Don't forget me too. I don't know how Islamic date look like. But When Art and me changed traditional Chinese date into gregorian date , we need a data contains all these traditional Chinese date which we download it from a HongKong observatory website by filename + url . Maybe you do all these followed Art and me .

Good Luck.

Xia Keshan

[zana]

Iranian date is an Islamic. I need a program for calculating a duration for Iranian date.

When I tried by SAS to find that how many days there are between today (1393/07/30) and 5 months ago (1393/02/31), found that i'm powerless. I think that by convert date to gregorian this problem maybe solved.

Do you have any idea for me?

Thanks

[Reeza]

I'm not sure how your Iranian calendar is formatted/structured but you could also try subtracting them directly to see if that duration would be correct directly.

Otherwise try the steps below:

1. Extract your Iranian dates into their components - Year, Month, Date - making sure they are all numeric variables.

2. Run the attached code in the .txt file in SAS

3. Convert your dates to Gregorian using the islamic_to_sd(year,month,day) function as in my sample code above

4. Subtract your dates to get the duration.

[zana]

Dear Reeza,

Thanks all for your time and post. My apologies, I'm a novice in SAS. I try to run the following code (in SAS 9.1.3), but did not work.

proc fcmp outlib=work.func.dates;

function islamic_leap(year);

    return(mod((year*11)+14,30)<11);

  endsub;

  function islamic_to_jd(year,month,day);

    return((day+ceil(29.5*(month-1))+(year-1)*354+

     floor((3+(11*year))/30)+1948439.5)-1);

  endsub;

data test;

    date_want=islamic_to_sd(1435,12,28);

    format date_want date9.;

run;

ERROR 68-185: The function ISLAMIC_TO_SD is unknown, or cannot be accessed.

[Reeza]

What do you mean you can't run it?

Run up to the proc format, not the macro sendit portion and then use the

islamic_to_sd function to convert the dates:

data test;

    date_want=islamic_to_sd(1435,12,28);

    format date_want date9.;

run;

[Reeza]

Oh, yeah proc fcmp isn't until 9.2 at least.

Convert to SAS date based on the following then, assuming you do the conversion to day, month, year as indicated:

You can still take the difference of the dates to get duration.

data test;

year=1435;

day=28;

month=12;

sas_date=((day+ceil(29.5*(month-1))+(year-1)*354+

     floor((3+(11*year))/30)+1948439.5)-1)-2436934.5;

format sas_date date9.;

run;

[zana]

Thank you so much. Please let me i add more suitable information. For example (please note) in Iranian date today is 1393-08-02 (year, month, day) that it is equal October 24, 2014.

So, my expected code is:

Iranian_Date     Gregorian_Date

1392-10-11        01JAN2014

1393-01-01        21MAR2014

1393-02-31        21MAY2014

1393-06-30        21SEP2014

1393-08-02        24OCT2014

Zana

[Reeza]

@jaap is partially correct it will be hard to make an exact conversion based on a formula.  Do you have a specific date range in your data? Then you could download an online calendar and do a lookup conversion.

Also, given your dates how are you expecting to calculate duration, second row minus first row?

[zana]

Dear Reeza, I have a data set with more than 10,000 records from 1365-01-01 to 1393-07-02 [28 years* 365 (days/year)].

I want to calculate that as second column minus first column.

Zana

[Reeza]

Is the 4/5th column of dates in wikipedia a correct mapping for your needs?

Iranian calendars - Wikipedia, the free encyclopedia