I would discourage using
%let DateFrom = ‘01nov2022’;
for macrovar datefrom. Instead consider dropping the quotes, as in
%let DateFrom = 01nov2022 ;
Then you can use a filter such as
where date >= "&datefrom"d
Date literals like '01nov2022'd and "01nov2022"d have identical underlying date values. But using single quotes with a macrovariable inside the quotes (as in '&datefrom'd) would prevent the macro processor from resolving &datefrom to 01nov2022, while double quotes (as in "&datefrom"d) will support resolution of the macrovar DATEFROM.
... View more
