Help using Base SAS procedures

Bracket code Very Stubborn

Reply
Contributor
Posts: 59

Bracket code Very Stubborn


Here is a snippet of code I used in a report that ran smoothly:

((b.REC_CHNG_CD IN ('A','C') and

  (a.LN_BA > 0 and

      &elapse >=0 ) and

        (a.iv_id not like 'Z%' or

         a.iv_id not like 'A%') and

         b.hz_ins_co_cd in ('NEWLN','MAINT','')));

I have another report that is very similar although some of the fields are different.  It seems pretty straight forward but I am getting

((d.REC_CHNG_CD IN ('A','C') and

        (a.LN_BA >0 and

             d.LN_HAZARD_TABLE_FG = 'N'  and

    (a.ix_id not in('Cx2','d01','f10','Z55') or

         a.iv_id not like 'F%') and

      (a.PR_TYPE_CD not in('C','3') and

             b.ins_co_cd in ('NEWLN','MAINT','')));

                                                      _

                                                       22

                                                       76

ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, ), *, **, +, -, /, <, <=, <>, =, >, >=, ?, AND, BETWEEN, CONTAINS, EQ,

              EQT, GE, GET, GT, GTT, IN, IS, LE, LET, LIKE, LT, LTT, NE, NET, NOT, NOTIN, OR, ^, ^=, |, ||, ~, ~=. 

ERROR 76-322: Syntax error, statement will be ignored.

   

Respected Advisor
Posts: 4,606

Re: Bracket code Very Stubborn

Your parentheses are not balanced, hence the syntax error.

PG

PG
Grand Advisor
Posts: 10,015

Re: Bracket code Very Stubborn

The enhanced editor key combination of Ctrl ( when the cursor is placed on a paranthesis, bracket or brace will find the matching one. If the cursor doesn't move then it is unbalanced.

Ask a Question
Discussion stats
  • 2 replies
  • 109 views
  • 0 likes
  • 3 in conversation