SAS Functions

[abhi19]

Hello,

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?

Thanks

[Reeza]

Functions:

Today()

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;