topic Re: questions about converting time into month in SAS Programming

questions about converting time into month

superbug — Tue, 14 Jan 2020 15:11:40 GMT

I want to convert time between to time points into month. if using (date2 - date1)/30, that doesn't take into account of months that have 31 days. what's the quick way of taking to account of month that have 30 and 31 days?

thank you!

Re: questions about converting time into month

novinosrin — Tue, 14 Jan 2020 15:19:20 GMT

I am guessing what you prolly need is to use INTCK function to get the count of monthly intervals between 2 dates

intck('month',date1,date2,'c');

/*or*/

intck('month',date1,date2);

A small test to understand


%let date1='29dec2019'd;
%let date2='05jan2020'd;

data test;
 month_discrete=intck('month',&date1,&date2);
 month_continuous=intck('month',&date1,&date2,'c');
run;

Re: questions about converting time into month

superbug — Tue, 14 Jan 2020 15:46:07 GMT

@novinosrin

you are always so helpful! Give you a BIG thumb up!

Yes, that worked!

Re: questions about converting time into month

mkeintz — Wed, 15 Jan 2020 02:00:16 GMT

Then mark this topic as solved. It makes it easier for everybody to know in advance which topics are solved and which are not.