topic Re: Getting a the date three months ago in SAS Procedures

Getting the date three months ago

Grant — Fri, 11 Mar 2016 18:26:15 GMT

Hi, this is my first post, and I am wondering how I can use the date three months ago in a sql query. I want to use the date in a WHERE clause. The main problem I have is that today() does not play well with intnx.

Thanks for your help!

data _null_;
threeMonthsAgo = intnx('month', today(), -3, e);
call symput('end_date', threeMonthsAgo);
run;

proc sql;
select * from mydatabase where the_date < &end_date;
end;

Re: Getting a the date three months ago

ballardw — Fri, 11 Mar 2016 18:08:56 GMT

You need to check your log the issue is that e needs to be in quotes as a directive to INTNX. Without quotes it is interpreted to be a variable and since there is no variable e it has no value and generates an error.

Re: Getting a the date three months ago

Grant — Fri, 11 Mar 2016 18:19:17 GMT

Thank you for your help.

Here is the new code with your improvements plus formatting:

data _null_;
threeMonthsAgo = put(intnx('month', today(), -3, 'e'), yymmdd10.);
call symput('end_date', threeMonthsAgo);
run;

%put &end_date;