RE: st: Search for dates within range

["Hillgrove, Tessa (SA)" <THillgrove@arcbs.redcross.org.au>]

Thanks Austin 

-----Original Message-----
From: Austin Nichols [mailto:austinnichols@gmail.com] 
Sent: Wednesday, 17 May 2006 12:34 PM
To: statalist@hsphsun2.harvard.edu
Subject: Re: st: Search for dates within range

It's easy if you put dates in the right format... see -help dates- and -help
date functions-

 gen date=date(dstr,"dmy")
 format date %d
 gen inwindow=date>=mdy(4,1,2003) & date<mdy(6,1,2003)  egen
anyinw=max(inwi), by(id)  li, noo

  +----------------------------------------------------------------+
  | id         dstr           type        date   inwindow   anyinw |
  |----------------------------------------------------------------|
  |  1   01-01-2003     Successful   01jan2003          0        1 |
  |  1   01-05-2003     Successful   01may2003          1        1 |
  |  2   01-03-2002       Deferred   01mar2002          0        0 |
  |  2   31-12-2003   Unsuccessful   31dec2003          0        0 |
  +----------------------------------------------------------------+

On 5/16/06, Hillgrove, Tessa (SA) <THillgrove@arcbs.redcross.org.au> wrote:
> My dataset is in the following format
> ID      Attend Date     Type
> 1       01-01-2003      Successful
> 1       01-05-2003      Successful
> 2       01-03-2002      Deferred
> 2       31-12-2003      Unsuccessful
>
> I have two "problems" with my dataset : (1) I have more subjects than 
> I need and (2) and a wider range of attendance dates than I need.
> I am trying to identify subjects that had an appointment on any dates 
> within a two month range.
> I will drop all respondents who do not.
> Of the respondents that did have an appointment, I will need to only 
> consider attendance within a specific range (and drop the remainder).
> Any ideas of how to do this?

*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/



E-mail Disclaimer:
Any personal information in this e-mail must be handled in accordance with
the provisions of the Privacy Act 1988 [Cth].  The information contained in
the e-mail may be confidential and if the person receiving the e-mail is not
the intended recipient they should immediately advise ARCBS by e-mail
response to the ARCBS sender and then deal with the e-mail as directed by
ARCBS. The views expressed in the e-mail are those of the individual sender
unless otherwise stated to be the views of ARCBS. No warranties are provided
that the e-mail is computer virus or other defect free.
*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/