hi, so I see SAS generates macro date variables and the one I need to use is TODAY1_DATE9. I have converted my variable date1 from date to string to see if that will work when I do the where clause however it is still not working:
data getDate;
set mydata.sampleset;
date1 = datepart(loaddate);
format date1 date9.;
char_date = put(date1,date9.);
run;
%let mydate = &TODAY1_DATE9.;
proc sql;
create table oldrecs as
select * from getDate
where char_date = &TODAY1_DATE9.;
;quit;
Log:
29 proc sql;
30 create table oldrecs as
31 select * from getDate
32 where char_date = &TODAY1_DATE9.;
NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.
NOTE: Line generated by the macro variable "TODAY1_DATE9".
32 27MAR2023
_______
22
76
ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, *, **, +, -, /, <, <=, <>, =, >, >=, AND, EQ, EQT, GE, GET,
GROUP, GT, GTT, HAVING, LE, LET, LT, LTT, NE, NET, OR, ORDER, ^=, |, ||, ~=.
ERROR 76-322: Syntax error, statement will be ignored.
33 ;quit;
Any idea on how to resolve this by using the date macro variables?
... View more