today () - 14)

[WilliamB]

Hello,

I would like to subtract the date of the day 2 weeks.

% let day =% sysfunc (today () - 14);

Can you help me?

Thank you

[sustagens]

data _null_;
_2_wks_ago=intnx('week',today(),-2);
run;

[Kurt_Bremser]

---

@sustagens wrote:

data _null_;
_2_wks_ago=intnx('week',today(),-2);
run;

---

This will not give you the wanted value, run this:

data _null_;
_2_wks_ago=intnx('week',today(),-2);
wanted = today() - 14;
put _all_;
run;

You need to add the 's' modifier to the intnx call.

[sustagens]

Missed that, I agree. Without the 's' it will subtract two weeks from the date, yes, but it will give the starting day of the week which is the Sunday of that week

[Kurt_Bremser · Accepted solution]

As pure macro code:

%let day=%eval(%sysfunc(today()) - 14);

or

%let day=%sysfunc(intnx(week,%sysfunc(today()),-2,s));

[WilliamB]

Thank you very much, how to put it in date9 format.

[sustagens]

%let day=%sysfunc(intnx(week,%sysfunc(today()),-2,s),date9.);
%put &=day;

[Kurt_Bremser]

---

@WilliamB wrote:
Thank you very much, how to put it in date9 format.

---

Apply the date9. format in the %sysfunc.

But what for? For calculations and comparisons, the raw value is much easier to handle. And for display, there are much better formats like e8601da10. (ISO 8601 date format).