how to run data for past N days

septemberbulb — Thu, 08 Mar 2018 14:36:27 GMT

Hi,

Could anyone help me with this issue? Now I have the coding to run the data based on previous day, what I have is as below:

%let APPCATIONDATE = %eval(%sysfunc(today())-1);

How to change it to past N days, for example I want the past 3 days data or 5 days data?

Thank you very much.

Re: how to run data for past N days

RW9 — Thu, 08 Mar 2018 14:58:30 GMT

%let numdays=3;

data dataforlastdays;
  set maindata;
  where applicationdate >= today() - &numdays.;
run;