topic Re: INTNX function - find saturday on the same week in SAS Programming

INTNX function - find saturday on the same week

AlexeyS — Thu, 13 Jan 2022 11:00:32 GMT

Hi,

For each date, i want to find the saturday date on the same week. But if the date is Sunday then the function have to return the next Saturday.

I use the following code :

saturday = intnx('week.7', date, 1);

This works as long as it is not about the Saturday itself. In this case, it returns the next Saturday. Please help.

How the function should work :

date	saturday
12/01/2022	15/01/2022
15/01/2022	15/01/2022
16/01/2022	22/01/2022

Thank you,

Alexey

Re: INTNX function - find saturday on the same week

FreelanceReinh — Thu, 13 Jan 2022 11:23:42 GMT

Hi @AlexeyS,

Try this:

saturday=intnx('week', date, 1)-1;

Edit:

Or, slightly shorter:

saturday=date+7-weekday(date);

Re: INTNX function - find saturday on the same week

PeterClemmensen — Thu, 13 Jan 2022 11:12:35 GMT

Try this

data have;
input date ddmmyy10.;
format date ddmmyy10.;
datalines;
12/01/2022 
15/01/2022 
16/01/2022 
;

data want;
   set have;
   saturday = intnx('week', date, 0, 'e');
   format saturday ddmmyy10.;
run;