topic Re: calculate days in month in SAS Programming

calculate days in month

kathisas — Mon, 13 Mar 2017 15:51:53 GMT

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

Re: calculate days in month

Shmuel — Mon, 13 Mar 2017 16:26:15 GMT

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.

Re: calculate days in month

Astounding — Mon, 13 Mar 2017 16:40:59 GMT

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?

Re: calculate days in month

AravindanKarunakaran — Wed, 03 Jan 2018 10:40:09 GMT

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

Re: calculate days in month

Cerium23 — Fri, 19 Jul 2019 21:39:15 GMT

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