I had a case statement, (case when t1.Date > '01Jan2016' then "NO" when t.1L = "N" then "NO" when t.1L = "M" then "NO" else "YES" end) As "NewColumn" I wanted to make a prompt so that when the program was run a person could pick what date they wanted to run the report off of instead of it always being '01Jan2016' or having to go in and changing the value of the date. I created a prompt 'eligible' and then put it in the code so that it now read this: case when t1.Date > &eligible then "NO" when t.1L = "N" then "NO" when t.1L = "M" then "NO" else "YES" end) As "NewColumn" Now it gives me the erorr: " ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, *, **, +, -, /, <, <=, <>, =, >, >=, AND, EQ, EQT, GE, GET," It seems as though the macro worked because it says: NOTE: Line generated by the macro variable "ELIGIBLE". 40 01Jan2017 Any help would be greatly appreciated.
... View more