how to calculate months,years and weeks

[sumitbe139]

Hi all,

I am new to base sas programming.

i am  calculating  months,years and weeks in a sas data set that have a column of some dates, say "ABC"

column ABC in data set

 and i have calculate  "months,years and weeks" from current date.

pls suggest.

[ErikLund_Jensen]

Hi - Have a look at the INTNX function. It calculates different types of time intervals between two dates.

[sumitbe139]

Hi,
Thanks for your response
I have done it

But I am stuck at how to assign a date1 to a column which as several dates in it pls see the image for reference.

Y=intck("month",date1,date2)
Date2 is today date

Pls suggest

[ErikLund_Jensen]

I will come up with a working code example in 3 minutes.

[ErikLund_Jensen · Accepted solution]

data have (drop=i);
format abc date9.;
   do i = 1 to 11;
      abc = '19feb2014'd + i;
      output;
 end;
run;

data want; set have;
   monthdif = intck('month',abc, date());
   weekdif = intck('week',abc, date());
   yeardif = intck('year',abc, date());

run;
run;