DATA Step, Macro, Functions and more

how to calculate months,years and weeks

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 9
Accepted Solution

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"

Untitled.pngcolumn 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

Posted in reply to sumitbe139

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;

View solution in original post


All Replies
Contributor
Posts: 47

Re: how to calculate months,years and weeks

Posted in reply to sumitbe139

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

Posted in reply to 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
Contributor
Posts: 47

Re: how to calculate months,years and weeks

Posted in reply to sumitbe139
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

Posted in reply to sumitbe139

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.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 164 views
  • 2 likes
  • 2 in conversation