calculate days in month

[kathisas]

hey 🙂

pleas help me.

I have to calculate an observation time between two dates and sas calculates the days of the periode. How can I get sas to calculate it in months?

thank you for your help

[Shmuel]

Assuming you have sas numeric dates then you can use:

   period = intck('month',date2,date1);

If your data containd datetime variables you should use datepart() function

to convert datetime into sas date.

[Astounding · Accepted solution]

A simple approach would transform the number of days into number of months:

n_months = (date2 - date1) / 30.5;

Do you have different rules in mind for computing number of months?

[AravindanKarunakaran]

dur_month = dur_day/30.4375;

365.25 days per year.

365 days in normal year

366 days in Leap year

0.25 days * 4 year becomes extra day in Leap year

so, 365.25/12 = 30.4375 days per month

---

@kathisas wrote:

hey 🙂

pleas help me.

I have to calculate an observation time between two dates and sas calculates the days of the periode. How can I get sas to calculate it in months?

thank you for your help

---

[Cerium23]

How do you calculate days to months in SAS? I actually have days like 1575757. I need to convert this. Help.