Date:         Fri, 25 Aug 2000 10:50:30 +0100
Reply-To:     Nigel.Pain@SCOTLAND.GOV.UK
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Nigel Pain <Nigel.Pain@SCOTLAND.GOV.UK>
Subject:      Re: SAS Date Question?
Content-Type: text/plain; charset="iso-8859-1"

> -----Original Message-----
> From: William W. Viergever [mailto:wwvierg@IBM.NET]
> Sent: 25 August 2000 02:03
> Subject: Re: SAS Date Question?

<clip>
> But, using the 1st day of the month may not be what they want/need.
>
> E.g., in certan health plans eligibility is as of the 5th
> (some are the 26th - i.e., it varies) of the month, hence
> using 5 (or 26 or whatever) as the DD value for a "standard"
> MMDDYYYY date would be more appropriate, for example, when
> calculating age for age/sex PMPM calcs.
</clip>

But surely if they are not storing the day of the month, then it is
irrelevant. Any calculations that they do will only be to the level of month
so who cares whether the day is stored as 1st, 5th or whatever. This is a
case where the limitations of INTCK and INTNX (counting period boundaries,
not overall time) actually benefit them because using MONTH as the period
will not take into account the stored day of month. We have a system like
this where data is collect monthly and a variable holds the month (and year)
of the collection as a SAS date and is formatted using MONYY.

***************************************************
Nigel Pain
Scottish Executive Development Department
Business Support Unit
Victoria Quay
EDINBURGH
EH6 6QQ
UK
Tel +44 131 244 7237
Fax +44 131 244 7281
Mailto:nigel.pain@scotland.gov.uk
Website: http:\www.scotland.gov.uk

>
>
> At 03:56 PM 08/24/2000, Lund, Pete wrote:
> >Brian-
> >   I would say you should definitely convert to a SAS date
> (using the first
> >day of the month as a standard).
>
>
> Hi Pete:
>
> I'm gonna do one of those nit-picky things like "_N_ may NOT
> actually be a valid OBS counter" and/or "OBS may NOT be the
> actual # of observations afterall" -sorry ....
>
> --------------------------------------------------------------
> --------------
> William W. Viergever                      Voice  : (916) 483-8398
> Viergever & Associates                    Fax    : (916) 486-1488
> A SAS Institute Quality Partner (USA)     E-mail : wwvierg@ibm.net
> Sacramento, CA 95825
>
> "Only put off until tomorrow what you are willing to die
> having left undone."
> - Pablo Picasso
>
> "God gives every bird his worm, but he does not throw it into
> the nest."
> - Swedish proverb
> --------------------------------------------------------------
> --------------
>

**********************************************************************
This email and any files transmitted with it are intended solely for
the use of the individual or entity to whom they are addressed.
**********************************************************************