topic Re: how to calculate months,years and weeks in SAS Programming

how to calculate months,years and weeks

sumitbe139 — Sun, 18 Feb 2018 18:02:18 GMT

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.

Re: how to calculate months,years and weeks

ErikLund_Jensen — Sun, 18 Feb 2018 18:18:24 GMT

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

Re: how to calculate months,years and weeks

sumitbe139 — Sun, 18 Feb 2018 18:27:19 GMT

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

Re: how to calculate months,years and weeks

ErikLund_Jensen — Sun, 18 Feb 2018 18:30:21 GMT

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

Re: how to calculate months,years and weeks

ErikLund_Jensen — Sun, 18 Feb 2018 18:37:25 GMT

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;