SAS Functions

Reply
Occasional Contributor
Posts: 5

SAS Functions

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

Super User
Posts: 19,167

Re: SAS Functions

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;

Ask a Question
Discussion stats
  • 1 reply
  • 238 views
  • 0 likes
  • 2 in conversation