06-19-2017 11:34 AM
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.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
06-19-2017 12:36 PM
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.