## how to calculate months,years and weeks

Solved
Occasional Contributor
Posts: 9

# how to calculate months,years and weeks

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.

Accepted Solutions
Solution
‎02-19-2018 10:25 AM
Contributor
Posts: 47

## Re: how to calculate months,years and weeks

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;

All Replies
Contributor
Posts: 47

## Re: how to calculate months,years and weeks

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

Occasional Contributor
Posts: 9

## Re: how to calculate months,years and weeks

Hi,
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
Contributor
Posts: 47

## Re: how to calculate months,years and weeks

I will come up with a working code example in 3 minutes.
Solution
‎02-19-2018 10:25 AM
Contributor
Posts: 47

## Re: how to calculate months,years and weeks

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;

☑ This topic is solved.