topic Re: today () - 14) in SAS Programming

today () - 14)

WilliamB — Wed, 06 Nov 2019 08:50:51 GMT

Hello,

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

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

Can you help me?

Thank you

Re: today () - 14)

sustagens — Wed, 06 Nov 2019 08:51:46 GMT

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

Re: today () - 14)

Kurt_Bremser — Wed, 06 Nov 2019 08:57:17 GMT

As pure macro code:

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

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

Re: today () - 14)

Kurt_Bremser — Wed, 06 Nov 2019 09:03:17 GMT

@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.

Re: today () - 14)

sustagens — Wed, 06 Nov 2019 09:17:21 GMT

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

Re: today () - 14)

WilliamB — Wed, 06 Nov 2019 09:18:52 GMT

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

Re: today () - 14)

sustagens — Wed, 06 Nov 2019 09:24:47 GMT

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

Re: today () - 14)

Kurt_Bremser — Wed, 06 Nov 2019 09:24:58 GMT

@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).