topic Re: Sunday to Saturday work day in SAS Programming

Sunday to Saturday work day

sivastat08 — Mon, 06 Mar 2017 11:34:07 GMT

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

thanks,

Siva

Re: Sunday to Saturday work day

Reeza — Mon, 06 Mar 2017 11:46:29 GMT

What does that mean?

Re: Sunday to Saturday work day

sivastat08 — Mon, 06 Mar 2017 11:54:43 GMT

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

Re: Sunday to Saturday work day

Reeza — Mon, 06 Mar 2017 12:17:49 GMT

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#p10v3sa3i4kfxfn1sovhi5xzxh8n.htm

Week

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

Re: Sunday to Saturday work day

sivastat08 — Mon, 06 Mar 2017 12:20:34 GMT

Thanks for Quick replay and Document.