topic Re: How filter rows with dates in SAS Programming

How filter rows with dates

emersonaguiar — Wed, 20 Feb 2019 13:10:37 GMT

Hello,

I need to aumotatize a process and for this I need to use the date of the system to filter information.

DATA dates;
INPUT name $ 1-4 @6 bday date11.;
CARDS;
John 1 Jan 2019
Mary 11 Jul 2019
Kate 12 Nov 2019
Mark 8 Jun 2019
;
RUN;

PROC PRINT DATA=dates;
FORMAT bday date9. ;
RUN;

I catch the date of the system using the function INTNX and I could use the date like a parameter.

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

But, when I will compare, I can't have a good result

DATA dates;
set dates;

where bday > &day;
run;

The mensseges are:

ERROR: Syntax error while parsing WHERE clause.
ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, *, **, +, -, /, <, <=, <>, =, >, >=, AND, EQ, GE, GT, LE, LT,
NE, OR, ^=, |, ||, ~=.

ERROR 76-322: Syntax error, statement will be ignored.

Re: How filter rows with dates

gamotte — Wed, 20 Feb 2019 12:57:57 GMT

hello,

Is &M1. the same macrovariable as &day. ?

Try

where bday >"&M1."d;

Do you have to use macros ? can't you just write

where bday > intnx("month", today(),2);

Re: How filter rows with dates

andreas_lds — Wed, 20 Feb 2019 12:58:09 GMT

With

options mprint;

active, you would see what the macro pre-processor generated. Most-likely not a sas-date.

From what you have posted i can't tell anything more. Posting complete log is recommended.

Re: How filter rows with dates

emersonaguiar — Wed, 20 Feb 2019 13:09:44 GMT

Yes, &M1. is the same macrovariable as &day.

I used yours sugestion and work! Tks for support me!