intck

[mehak]

 calculate the months , weeks, days seperately  since coupon expiry date from current date to 31 march 2014. 

data _class_s;
date1 = '21OCT2017'd;
date2 = '31MAR2014'd;
no_of_months = intck ('MONTH', date1, date2);
no_of_weeks = intck ('WEEK', date1, date2);
no_of_days = intck ('DAY', date1, date2);
format date1 date2 date9.;
proc print data = _class_s noobs;
run;

can any1 please tell me whati have to do to add coupon expiry date in this code .

[Kurt_Bremser · Accepted solution]

As I read your homework, you have to run a do loop from the current date back to March 31, 2014.

[mehak]

sir  can you please tell me how can i take difference between the var called coupon id , current date and 31march

[Kurt_Bremser]

---

@mehak wrote:

sir  can you please tell me how can i take difference between the var called coupon id , current date and 31march

---

Differences are calculated with a subtraction. Date and time differences are calculated with intck, as you already know.