I am looking to select claim numbers that were opened last week between Monday and Sunday or I can do Sunday and Saturday too if the default 1st day of the week in SAS is Sunday. How can I effectively do that with SAS functions so that I can automate it? Any Ideas?
Intnx - align to start/end of week, this week or previous - may need tweaking depending on your requirements
Find start/end date of intervals
date_start = intnx('week', today(), -1, 's')-1;
date_end = date_start + 7;
if date_start < date < date_end;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.