Date: Thu, 23 May 2002 02:05:34 -0700
Reply-To: MK <myquery5@YAHOO.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: MK <myquery5@YAHOO.COM>
Organization: http://groups.google.com/
Subject: Re: GenerateWeek No. for the month given the date
Content-Type: text/plain; charset=ISO-8859-1
Hi All,
Thank you all very much for replying.
Howard following are the clarifications reqd by you.
1. We take 1nd January 2001 as starting Date, which is Monday.
This is the 1st Day of the month & year too.
2. The week is calculated as Monday to Sunday
3. As in case of partial weeks,lets take an example of April last week
and May 1st week.
30th April 2002 is on Tuesday and it falls in the 5th week (last week)
of Month April. So, 1st May 2002 is on wednesday of the same week. But
1st May 2002 is considered as falling in 1st week of Month May
Thanks for the reply.
Regards
Mrinal
Howard_Schreier@ITA.DOC.GOV wrote in message news:<200205221541.g4MFfQ329106@listserv.cc.uga.edu>...
> Please clarify.
>
> On which day does a week begin? Plausible answers include:
>
> 1. A specific day (most commonly Sunday or Monday).
>
> 2. The day on which the first day of the month falls.
>
> 3. The day on which the first day of the year occurs.
>
> How do you designate partial weeks at the beginning and/or end of the month?
> When a week straddles two months, are the two parts treated as two separate
> partial weeks, or as one seven-day week; if the latter, to which month does
> it belong?
>
> On Tue, 21 May 2002 22:11:53 -0700, MK <myquery5@YAHOO.COM> wrote:
>
> >Hi,
> >
> >I am a novice SAS programmer and I need help in following.
> >I need to calculate the week No. as in 1st week or 2nd week etc. given
> >the date of the year in mm/dd/yy or dd/mm/yy or any other format.
> >For eg.
> >If the starting date is 1st January 2001 and it is a Monday then given
> >the date say 03/12/2002 (mm/dd/yy format), I need to know the Week No.
> >of the month (ie. 1st week or 2nd week or 3rd week or 4th week of
> >march) for the given date.
> >Can you please help me in this?
> >
> >Thanks & Regards
> >MK
| 
