topic Re: SAS Functions in SAS Programming

SAS Functions

abhi19 — Mon, 11 May 2015 21:10:04 GMT

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

Re: SAS Functions

Reeza — Mon, 11 May 2015 21:26:20 GMT

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;