topic SAS Date and Macro variable in SAS Programming

SAS Date and Macro variable

TedCarol — Fri, 25 Nov 2016 18:59:27 GMT

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;

Re: SAS Date and Macro variable

Cynthia_sas — Sun, 27 Nov 2016 01:52:16 GMT

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

Re: SAS Date and Macro variable

Patrick — Sun, 27 Nov 2016 02:26:42 GMT

@TedCarol

Please don't post the same question twice.

Cross reference to your other post

https://communities.sas.com/t5/General-SAS-Programming/error-with-date9-field-set-equal-to-macro-variable-in-where/m-p/314360#U314360