topic Re: error syntax in SAS Enterprise Guide

error syntax

Rsadiq1 — Mon, 19 Jun 2017 15:34:28 GMT

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;

Re: error syntax

ballardw — Mon, 19 Jun 2017 16:36:48 GMT

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.

Re: error syntax

kanivan51 — Tue, 20 Jun 2017 04:56:21 GMT

Hi! &pol_nbr. - is this a single value or not? If it is not - check for quotation and punctuation. Show us the code, please