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;
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;
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;
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.