Syntax error

Rsadiq — Sat, 28 Oct 2017 03:36:29 GMT

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 (.

Re: Syntax error

Reeza — Sat, 28 Oct 2017 04:11:39 GMT

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.

Re: Syntax error

PGStats — Sat, 28 Oct 2017 05:24:22 GMT

There should not be a closing parenthesis after the group by clause.

Re: Syntax error

Kurt_Bremser — Sat, 28 Oct 2017 05:55:23 GMT

And in your where condition you have three opening and four closing brackets.

Re: Syntax error

jklaverstijn — Sat, 28 Oct 2017 10:25:45 GMT

Have a look at https://www.youtube.com/watch?v=6wcdTKAoOEg.

- Jan.

topic Re: Syntax error in SAS Enterprise Guide

Syntax error

Re: Syntax error

Re: Syntax error

Re: Syntax error

Re: Syntax error