Hello Everyone I am trying to assign a date to a macro variable and using that macro variable to subset a data from a dataset. It's throwing me an error. Here is the code: /*Assigning the macro variable the 27th Jan 2018 date*/
%let date_comp= %SYSFUNC(INTNX(DAY,%SYSFUNC(TODAY()),-3),date9.);
%put &date_comp.;
27JAN2018
DATA want(where=( Ship_Date >=&date_comp.));
set have;
run;
The want data is throwing me an error. This is the error. data want (where=(ship_date >=&date_comp.));
NOTE: Line generated by the macro variable "DATE_COMP".
1 27JAN2018
-------
22
76
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.
3721 set have;
3722 run;
NOTE: The SAS System stopped processing this step because of errors.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
ERROR: Syntax error while parsing WHERE clause. Please help me with this. Thanks Chandan Mishra
... View more