Statalist The Stata Listserver


[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

Re: st: Search for dates within range


From   "Austin Nichols" <austinnichols@gmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: Search for dates within range
Date   Tue, 16 May 2006 23:04:23 -0400

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/



© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index