Sunday to Saturday work day

[sivastat08]

I would like to create my work day as (Sunday to Saturday) range data. could you please help in getting this?

thanks,

Siva

[Reeza]

What does that mean?

[sivastat08]

i have a one year data, i want weekly split (5thMar2017(Sunday)) -(11thMar2017(Saturday)

for example if i take today (5thMar2017) that should come under "05Mar-11Mar" in seperate column in SAS

[Reeza · Accepted solution]

Use INTNX with WEEK interval. 

Week_start = intnx('week', date, 0, 'b');

week_end = Intnx('week', date, 0, 'e');

or the week function

week_num = week(date, 'u');

Links to documentation

Intnx

http://support.sas.com/documentation/cdl/en/lefunctionsref/69762/HTML/default/viewer.htm#p10v3sa3i4k...

Week

http://support.sas.com/documentation/cdl/en/lefunctionsref/69762/HTML/default/viewer.htm#n1ka2ulrvrj...

[sivastat08]

Thanks for Quick replay and Document.