> -----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. **********************************************************************