Hello I keep getting an error in my code (not sure what it is) Ive been trying everything but maybe I'm just not seeing it
My code is below followed by the error. Thank you!
proc sql ;
create table pharmacy_consults1 as
select distinct
mbr_id
,ACTV_STRT_DTTM
,case when ACTV_TYP_ID in ('121') and RSLV_OTCOME_TYP_ID in ('369') then 1
else 0 end format=6. as REFERRALS
,CREATDT as ACTVCREATDT
from activities_mbr
where ((ACTV_STRT_DTTM is not null and ACTV_STRT_DTTM between "&beg_dt."d and "&end_dt."d) or
(ACTVCREATDT is not null and ACTVCREATDT between "&beg_dt."d and "&end_dt."d)))
group by mbr_id) ;
quit ;
NOTE: Line generated by the invoked macro "CA_STEP2".
1024 "&end_dt."d) or (ACTVCREATDT is not null and ACTVCREATDT
1024 ! between "&beg_dt."d and "&end_dt."d))) group by mbr_id) ; quit ;
_ _
22 79
200
ERROR 22-322: Syntax error, expecting one of the following: ;, !, !!, &, *, **, +, -, /, <, <=, <>,
=, >, >=, ?, AND, BETWEEN, CONTAINS, EQ, EQT, EXCEPT, GE, GET, GROUP, GT, GTT,
HAVING, IN, INTERSECT, IS, LE, LET, LIKE, LT, LTT, NE, NET, NOT, NOTIN, OR, ORDER,
OUTER, UNION, ^, ^=, |, ||, ~, ~=.
ERROR 79-322: Expecting a (.
It’s an issue with the parenthesis.
Remove all of your filters and add them back one by one until you see where the issue is.
There should not be a closing parenthesis after the group by clause.
And in your where condition you have three opening and four closing brackets.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.