This is killing me, if someone can help I'd be exceedingly grateful.
I have this program snippet. In the last proc sql I am getting an error with the date. Why won't it take my date variable????
Please help? Error message followed by code.
NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.
NOTE: Line generated by the macro variable "DAYDATE1".
18 24NOV2016
_______
22
76
ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, *, **, +, -, /, <, <=, <>, =, >, >=, AND, EQ, EQT, GE, GET,
GT, GTT, LE, LET, LT, LTT, NE, NET, OR, ^=, |, ||, ~=.
ERROR 76-322: Syntax error, statement will be ignored.
data dates;
daydate1=intnx('day',today(),-1,'B');
FORMAT daydate1 date9.;
run;
proc sql;
select daydate1 into :daydate1 FROM dates;
quit;
proc sql;
connect to sqlsvr as sqlsvr (dsn=sqlserverp authdomain=sqlauthp);
create table work.submit as
select * from connection to sqlsvr
(select ID, store_number, min(rpt_dt) as Submit_Dt
from Appstable
group by ID, store_number
order by ID asc);
quit;
proc sql;
create table subday as select input(store_number,4.) as store, count(ID) as Submits
from submit where submit_dt = &daydate1
group by store_number;
quit;
