date check

me55 — Tue, 26 Jun 2018 18:11:42 GMT

okay, so i need to, as a part of a larger process, check if the date in a field (MONTH) has last months date in it. if it does it needs to run a series of queries and if it does not, then run other queries. i am just missing how to figure this out. i assume to do it, it needs to be run from a macro so something like...

%macro datecheck;

%local qry mnthck

%let qry=(proc sql; select max(MONTH) as MNTH from TABLE; quit;);

%let today=%sysfunc(today());

%let lmnth=%sysfunc(intnx(month,&today,-1));

%if &lmnth=&qry %then

%do;

list of queries to run...

%end;

%mend datecheck;

run;

any help? obviously that does not work but i am also not far off from getting the right answer. i am just missing the part of getting the query results.

Re: date check

Kurt_Bremser — Tue, 26 Jun 2018 18:27:14 GMT

proc sql noprint;
select max(month) into :mnth from table;
quit;

%macro datecheck;
%if %sysfunc(intnx(month,&mnth,0,b)) = %sysfunc(intnx(month,%sysfunc(today()),-1,b))
%then %do; /* last month */
/* some queries */
%end;
%else %do; /* other month */
/* some other queries */
%end;
%mend;
%datecheck

topic Re: date check in SAS Programming

date check

Re: date check