I have a program that has user input fields to create certain parameters throughout the code, in this case, a lookback period for a date/date range, and formatting is applied several times so that it works in various queries. I am getting an error at the calculation, however. Please help! This is the error: 215 /**********************************************************************************************************************************************/ 216 **macro to calculate lookback for staging based on incident start date; 217 218 data temp; 219 DTL = &date1. - &Days.; _ 22 200 WARNING: Apparent symbolic reference DAYS not resolved. ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, a numeric constant, a datetime constant, a missing value, arrayname, (, +, -, INPUT, NOT, PUT, ^, _NEW_, ~. ERROR 200-322: The symbol is not recognized and will be ignored. 220 format DTL yymmdd10.; 221 run; I've included below the relevant pieces of code. " /*SAS FORMATTED INCIDENT START DATE*/ %let date1 = '06Dec2019'd; /**lookback x days**/ %let Days = 35; /*no lookback for staging, input "0"*/ /**********************************************************************************************************************************************/ **macro to calculate lookback for staging based on incident start date; data temp; DTL = &date1. - &Days.; format DTL yymmdd10.; run; proc sql noprint; select DTL into :DTLa "
... View more