topic Re: Month value with decial -Date function in SAS Programming

Month value with decial -Date function

Sathish_jammy — Mon, 16 Jul 2018 06:55:58 GMT

Hi community,

I'm looking a decimal value for the month column. For Year value i got the exact one. I have a trouble with the dd_m (month) column.

While using INTCK func i got a month value but without a decimal.

Please suggest me to solve it.

data eee;
input dateonset mmddyy10.;
cards;
02/19/2004
01/20/2003
05/10/2003
05/21/2003
12/24/2002
05/20/2003
;


data dur1;
set eee;
tday = today();
dur_d = tday - dateonset;
dd_m = intck('month',dateonset,tday);
/**dd_m = dur_d / 12;****(Wrong value)***/  
dd_y = dur_d / 365.25;
format dd_y 4.1 dd_m 4.1 tday dateonset mmddyy10.;
run;
proc print;
run;

Re: Month value with decial -Date function

DJongman — Mon, 16 Jul 2018 07:23:56 GMT

As you state that year value is correct:

dd_m2 = (dur_d / 365.25)*12;

Re: Month value with decial -Date function

Ksharp — Mon, 16 Jul 2018 12:16:47 GMT

dd_m=yrdif(start,end,'act/act')*12;

Re: Month value with decial -Date function

ballardw — Mon, 16 Jul 2018 14:23:42 GMT

Since months vary from 28 to 31 days the decimal portion is highly suspect in interpretation.

If you really need finer increments I would suggest days.