Date:         Thu, 15 Apr 2004 13:59:52 -0400
Reply-To:     Steve Raimi <steven.raimi@GM.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Steve Raimi <steven.raimi@GM.COM>
Subject:      Re: Date assignment
Comments: To: Huong Stemm <htns0101@YAHOO.COM>
Content-Type: text/plain; charset=ISO-8859-1

Use week = intck('WEEK', datetotest,'29-Dec-2003'd) + 1;


Steve Raimi

On Thu, 15 Apr 2004 09:38:58 -0700, 0101 htns <htns0101@YAHOO.COM> wrote:

>Hi all,
>
>I need help on finding an efficient way to assign 7 days to a week.
>
>Here’s my expected output:
>
>Date Week
>
>29DEC2003 week 1
>
>30DEC2003 week 1
>
>31DEC2003 week 1
>
>01JAN2004 week 1
>
>02JAN2004 week 1
>
>03JAN2004 week 1
>
>04JAN2004 week 1
>
>05JAN2004 week 2
>
>06JAN2004 week 2
>
>07JAN2004 week 2
>
>08JAN2004 week 2
>
>09JAN2004 week 2
>
>10JAN2004 week 2
>
>11JAN2004 week 2
>
>...
>
>10APR2004 week 16
>
>11APR2004 week 16
>
>12APR2004 week 16
>
>13APR2004 week 16
>
>14APR2004 week 16
>
>15APR2004 week 16
>
>...
>
>Essentially, there are 52 weeks in a year. This year, week one starts from
12/29/2003 and week 52 ends on 12/26/2004 (including 12/26/2004)
>
>Any help would be greatly appreciated.
>
>Huong
>
>
>
>
>
>---------------------------------
>Do you Yahoo!?
>Yahoo! Tax Center - File online by April 15th