Desktop productivity for business analysts and programmers

error syntax

Reply
Occasional Contributor
Posts: 19

error syntax

    Hello I am getting a syntax error that is not making sense to me, if anyone could help

 

ARNING: Apparent symbolic reference POL_NBR not resolved.
ERROR 22-322: Syntax error, expecting one of the following: a quoted string, a numeric constant, a datetime constant,
              a missing value, (, -, SELECT. 

 

 

WHERE UPCASE(C.POL_NBR) IN (&pol_nbr.)
               and ADR.ST_CD in (&statlst.)
               and (datepart(AC.CREAT_DTTM) >= input("&bak14.",mmddyy10.))
               and P.ENRL_DT~=.
               and P.PGM_CATGY_TYP_ID in ("04")
               and P.PGM_TYP_ID not in ("52","04")            
               and P.MBR_PGM_STS_RSN_TYP_ID = "81"
               and P.MBR_PGM_STS_TYP_ID = '05'
          ORDER BY M.MBR_ID
     ;
quit;

Super User
Posts: 11,105

Re: error syntax

Showing the entire code is better.

 

The warning says that at the time the macro processor attempts to evaluate this line:

UPCASE(C.POL_NBR) IN (&pol_nbr.)

no value has been assigned to the macro variable &pol_nbr.

 

The error follows because this comparison

where UPCASE(C.POL_NBR) IN ()

is invalid without at least one value inside the () after in.

Occasional Contributor
Posts: 13

Re: error syntax

Hi! &pol_nbr. - is this a single value or not? If it is not - check for quotation and punctuation. Show us the code, please
Ask a Question
Discussion stats
  • 2 replies
  • 99 views
  • 0 likes
  • 3 in conversation