Date:         Wed, 25 Feb 2009 13:11:57 -0800
Reply-To:     sdlentertd@GMAIL.COM
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         sdlentertd@GMAIL.COM
Organization: http://groups.google.com
Subject:      Re: Help - who is due for a refill
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset=ISO-8859-1

On Feb 25, 1:31 pm, barry.a.schw...@BOEING.COM ("Schwarz, Barry A")
wrote:
> Assuming the data is in a SAS data set, date of fill is a datetime
> variable, and days supplied is numeric:
>
>         Use today()to get today's date
>         Use datepart() to isolate the date of refill
>         Compute the date the last pill dose will be taken
>         Check if this date is in the time frame of interest
>
> Consider whether the patient should wait till he runs out before
> refilling or maybe try to refill 3-4 days prior.
>
>
>
> -----Original Message-----
> From: sdlente...@GMAIL.COM
> Sent: Wednesday, February 25, 2009 11:45 AM
> To: SA...@LISTSERV.UGA.EDU
> Subject: Help - who is due for a refill
>
> I have this data
> Member     Date of Fill                            Days Supplied
> a123      20JAN2009:00:00:00.000                  30
> v345      12FEB2009:00:00:00.000                  25
> b125      5FEB2009:00:00:00.000                   30
>
> I need to find who is due for a refill within the next two weeks
> between two dates (Feb 27 and March 14)
> Want to see
>
> Member     next date of fill
> v345             March 9
> b125            march 6
>
> that was one version... also what if I have an additional column # of
> Refills... so if it's 0 then ignore (no refills) if it's 1 and the
> date is within those two weeks then show it, if it's 1 and the date is
> prioir or after to those two weeks then don't show it.... etc...
>
> is my thinking correct:
> first i would need to find out when the next refil date should be and
> then somehow calculate if if falls within those two weeks.
> thank you- Hide quoted text -
>
> - Show quoted text -

Great,,,, how about a little help computing the ones that are due
within the next two weeks?