topic Re: truncating a month interval in SAS Programming

truncating a month interval

Batman — Fri, 02 Feb 2024 00:07:40 GMT

I'm aware that INTCK counts the number of intervals between two periods, but I'd like to get a truncated version of the actual count (i.e. 12 rather than 12.3 or 12.7).

I think this code does it but I'm wonder if there is function that would do the same rather than multiple lines of code

data _null_;
format s_dt l_dt alt_end date9.;
s_dt = mdy(12,31,2008);
l_dt = mdy(1,1,2010);
months = intck('month',s_dt,l_dt);
alt_end = intnx('month',s_dt,months,'same');
if l_dt lt alt_end then trunc_month=months-1;
else trunc_month=months;
putlog _all_;
run;

Re: truncating a month interval

Patrick — Fri, 02 Feb 2024 01:30:08 GMT

I believe you're looking for the intck() continuous method.

data test;
  format s_dt l_dt alt_end date9.;
  s_dt = mdy(12,16,2008);
  l_dt = mdy(1,15,2010);
  months_1 = intck('month',s_dt,l_dt);
  months_2 = intck('month',s_dt,l_dt,'c');
  alt_end  = intnx('month',s_dt,months_2,'same');
  output;
  s_dt = mdy(12,15,2008);
  l_dt = mdy(1,15,2010);
  months_1 = intck('month',s_dt,l_dt);
  months_2 = intck('month',s_dt,l_dt,'c');
  alt_end  = intnx('month',s_dt,months_2,'same');
  output;
run;

proc print data=test;
run;