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.
%let numdays=3; data dataforlastdays; set maindata; where applicationdate >= today() - &numdays.; run;
Dive into keynotes, announcements and breakthroughs on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.
Browse our catalog!