11-25-2016 01:59 PM
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;
11-26-2016 08:50 PM - edited 11-26-2016 08:52 PM
Hi:
Assuming that the variable you are selecting on is a date variable (numeric) and not a character string, you are using &daydate incorrectly. With my #1 example, I can duplicate your error message. With my #2 example, I correctly use "&daydate"d to select the row with that date.
cynthia
11-26-2016 09:26 PM
Please don't post the same question twice.
Cross reference to your other post