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.
... View more