topic Re: Convert dates from between Hijri (Islamic) and gregorian in SAS Programming

Convert dates from between Hijri (Islamic) and gregorian

zana — Tue, 21 Oct 2014 17:19:31 GMT

ِ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

Re: Convert dates from between Hijri (Islamic) and gregorian

stefan_r — Thu, 23 Oct 2014 10:05:48 GMT

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

Re: Convert dates from between Hijri (Islamic) and gregorian

zana — Thu, 23 Oct 2014 12:13:26 GMT

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

Re: Convert dates from between Hijri (Islamic) and gregorian

OS2Rules — Thu, 23 Oct 2014 13:01:23 GMT

Hi:

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

Re: Convert dates from between Hijri (Islamic) and gregorian

art297 — Thu, 23 Oct 2014 13:54:38 GMT

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

Re: Convert dates from between Hijri (Islamic) and gregorian

Ksharp — Thu, 23 Oct 2014 15:38:42 GMT

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

Re: Convert dates from between Hijri (Islamic) and gregorian

Reeza — Thu, 23 Oct 2014 19:21:05 GMT

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;

Re: Convert dates from between Hijri (Islamic) and gregorian

zana — Thu, 23 Oct 2014 19:54:15 GMT

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

Re: Convert dates from between Hijri (Islamic) and gregorian

Reeza — Thu, 23 Oct 2014 20:14:42 GMT

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.

Re: Convert dates from between Hijri (Islamic) and gregorian

zana — Thu, 23 Oct 2014 20:57:27 GMT

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.

Re: Convert dates from between Hijri (Islamic) and gregorian

Reeza — Thu, 23 Oct 2014 22:15:25 GMT

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;

Re: Convert dates from between Hijri (Islamic) and gregorian

art297 — Thu, 23 Oct 2014 22:22:52 GMT

: Matt won't be able to check our macro's code until sometime next week, but the following should come close:

%macro islamic_to_jd(year,month,day);

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

floor((3+(11*&year.))/30)+1948439.5)-1-2436935.5

%mend islamic_to_jd;

data have;

informat islamic_date1 islamic_date2 $10.;

input islamic_date1 islamic_date2;

format sd1 sd2 date9.;

sd1=%islamic_to_jd(scan(islamic_date1,1,'-'),scan(islamic_date1,2,'-'),

scan(islamic_date1,3,'-'));

sd2=%islamic_to_jd(scan(islamic_date2,1,'-'),scan(islamic_date2,2,'-'),

scan(islamic_date2,3,'-'));

days_between=sd2-sd1;

cards;

1393-02-31 1393-07-30

1393-02-31 1435-12-28

1435-12-29 1436-01-17

;

Re: Convert dates from between Hijri (Islamic) and gregorian

zana — Fri, 24 Oct 2014 09:36:36 GMT

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

Re: Convert dates from between Hijri (Islamic) and gregorian

zana — Fri, 24 Oct 2014 09:49:37 GMT

Hardly thanks. But this code was wrong.

For Iranian date duration between 1393-02-31 and 1393-07-30 is 154 days not 146 days.

Best regards

Re: Convert dates from between Hijri (Islamic) and gregorian

jakarman — Fri, 24 Oct 2014 11:07:55 GMT

zanam When I read that Islamic calendar - Wikipedia, the free encyclopedia the Islamic calendar may differ from country to country and may be by who is whatching the moon theres is not one but many of those.

In that case it is more a standard that everybody has his one for (other words, no standards). A conversion only makes sense when there is a exact definition at both sides. What is your calendar definition?

Re: Convert dates from between Hijri (Islamic) and gregorian

Reeza — Fri, 24 Oct 2014 11:26:50 GMT

@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?

Re: Convert dates from between Hijri (Islamic) and gregorian

jakarman — Fri, 24 Oct 2014 12:42:03 GMT

What I was thinking on was:

- the Tabular Islamic calendar - Wikipedia, the free encyclopedia. being more mathematical. But it is discrepedancy within all those different streams

- The day is just a numerical sequence. Every day another, next, number. Wether calculated in formulas (rounding/precion) using eg a FCMP routine with formats (in/out) should be able to cover that.

The intervalds dataset to be used for dedicated intervals. It is just translating that number to some text vice versa for formats. The week interval should be able to be used but others needing a different approach..

I missed the 9.1.3 limitation. You could upgrade to a newer version. As long you are at that one fcmp is not possible.

The most basic approach for formats / informats will be defining a long list of values to the associated SAS day-number vice versa, it could be generated for a defined period. inputting yyyy-mm-dd islamtic for let us say 200 years is 73000 records.
is that limited period a problem?

Re: Convert dates from between Hijri (Islamic) and gregorian

zana — Fri, 24 Oct 2014 13:02:31 GMT

Thanks for your post.

Yes, unfortunately it is different between Islamic countries. For Iran, it determined as Persian date (Iranian calendars - Wikipedia, the free encyclopedia).

Zana

Re: Convert dates from between Hijri (Islamic) and gregorian

zana — Fri, 24 Oct 2014 13:39:15 GMT

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

Re: Convert dates from between Hijri (Islamic) and gregorian

Reeza — Fri, 24 Oct 2014 16:23:04 GMT

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

Iranian calendars - Wikipedia, the free encyclopedia