Bracket code Very Stubborn

omega1983 — Fri, 03 May 2013 14:36:13 GMT

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','')));

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.

Re: Bracket code Very Stubborn

PGStats — Fri, 03 May 2013 14:41:31 GMT

Your parentheses are not balanced, hence the syntax error.

Re: Bracket code Very Stubborn

ballardw — Fri, 03 May 2013 15:56:39 GMT

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.

topic Bracket code Very Stubborn in SAS Procedures

Bracket code Very Stubborn

Re: Bracket code Very Stubborn

Re: Bracket code Very Stubborn