05-11-2015 05:10 PM
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?
05-11-2015 05:26 PM
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;