topic Re: AGE IN MONTHS in SAS Programming

AGE IN MONTHS

saraphdnz — Fri, 22 Oct 2021 15:12:49 GMT

hi there,

I am trying to calculate age as the number of total months as of a specific date. But I am getting the number of years. Please help me to fix this issue?

DATA  AGE_MONTHS;
SET TEST;
TODAY = MDY(03,31,2021);
DAYS = TODAY - Launch_Date;
AGE=FLOOR((INTCK('month',Launch_Date,TODAY) - (DAY(TODAY) < DAY(Launch_Date))) / 12);
RUN;

regards,

sara

Re: AGE IN MONTHS

AMSAS — Fri, 22 Oct 2021 15:29:41 GMT

You are already using the INTCK Function and specifying "MONTH" as the interval so why divide by 12?

Re: AGE IN MONTHS

ballardw — Sat, 23 Oct 2021 05:32:14 GMT

You may want to consider use of the INTCK method option='C' such as

INTCK('month',Launch_Date,TODAY,'C')

The default of 'D' or discrete may not yield quite what you want.

Consider this example:

data example;
   date1 = '18Mar2021'd;
   date2 = '02Jul2021'd;
   default = intck('month',date1,date2);
   cont    = intck('month',date1,date2,'C');
run;

Decide what you would expect to be the number of months between those two dates (think perhaps of date1 as a date of birth and the other the date of some service). Then run the code and pick the appropriate version.

I used two close together dates intentionally so you can decide before running the code.

Re: AGE IN MONTHS

saraphdnz — Sat, 23 Oct 2021 02:44:39 GMT

THANKS HEAPS.