Hi, I cannot for the life of me understand why my macro is acting this way. Context: I am creating a macro to conditionally generate reports depending on the macro variable lReportNum. Below is a snippet of my code. %if &lReptNum. in (1,2,3,4) %then %do; [proc report.. more sas code...] %end; For some strange reason, when opening a new SAS session and '%include'ing my macro to run it, I always get the following result from the first run: SYMBOLGEN: Macro variable LREPTNUM resolves to 1 MLOGIC(PMREPORT_YOY): %IF condition &lReptNum. in (1,2,3,4) is FALSE I don't understand why my condition is giving me FALSE. Here's the strange part: when I %include my macro again and run it a second time, I get the following result: SYMBOLGEN: Macro variable LREPTNUM resolves to 1 MLOGIC(PMREPORT_YOY): %IF condition &lReptNum. in (1,3,5,7) is TRUE Note that this results only if I %include my macro a second time. I am not sure why this is happening. Any insight or help would be appreciated.
... View more