My apologies. I completely ommitted the ID by error. The revised
data is as follows:
ID Admdate Sepdate Flag1 Flag2
1 30-JUN-1999 07-JUL-1999 1.00 .00
1 14-FEB-2000 19-FEB-2000 2.00 .00
1 16-MAR-2001 20-MAR-2001 3.00 .00
1 16-MAR-2001 03-APR-2001 3.00 1.00
2 28-AUG-2000 30-AUG-2000 1.00 .00
3 30-SEP-1999 12-OCT-1999 1.00 .00
3 30-SEP-1999 19-OCT-1999 1.00 1.00
3 30-SEP-1999 24-OCT-1999 1.00 1.00
4 29-APR-2000 06-MAY-2000 1.00 .00
4 06-JUN-2000 08-JUN-2000 2.00 .00
4 04-SEP-2000 13-SEP-2000 3.00 .00
4 04-SEP-2000 04-OCT-2000 3.00 1.00
> > I am using looking at clients the number of and hospital admissions
> > they may have had. Many of the clients have numerous hospital
> > admissions that may be either:
> >  An admission on it s own
> >  Overlapping admissions
> >  Concurrent admissions
> >  Admissions within admissions.
> > I have rolled up the admissions so that any that are overlapping,
> > concurrent or admissions within admissions are now identified and now
> > look like this:
> I am used to looking at data where one line represents
> one fact that I am able to count.
> If necessary, we have to invent new definitions so that
> one fact can fit into exactly one category - "hospital admissions"
> is a tricky thing here, too.
> Our administrators had to be taught, about 15 years ago,
> that they *did* need to create explicit definitions, in order
> to produce an unambiguous count -- one which wouldn't be
> at the mercy of some computer-programmer's default
> If you are going to use a computer to generate explicit
> counts, you want explicit categories.
> > Admdate Sepdate Flag1 Flag2
> > 30-JUN-1999 07-JUL-1999 1.00 .00
> > 14-FEB-2000 19-FEB-2000 2.00 .00
> > 16-MAR-2001 20-MAR-2001 3.00 .00
> > 16-MAR-2001 03-APR-2001 3.00 1.00
> > 28-AUG-2000 30-AUG-2000 1.00 .00
> > 30-SEP-1999 12-OCT-1999 1.00 .00
> > 30-SEP-1999 19-OCT-1999 1.00 1.00
> > 30-SEP-1999 24-OCT-1999 1.00 1.00
> > 29-APR-2000 06-MAY-2000 1.00 .00
> > 06-JUN-2000 08-JUN-2000 2.00 .00
> > 04-SEP-2000 13-SEP-2000 3.00 .00
> > 04-SEP-2000 04-OCT-2000 3.00 1.00
> > In Flag 1, I have added a mobidity sequence with the number repeated
> > if the admission date is the same. Flag2 is whre I have tried to flag
> > the final record for the admission period so that I can capture the
> > whole period of time in one record.
> Does each line, above, represent (already) some
> sort of aggregation?
> I expect to see a line that has a Patient ID number,
> and an "event". Further information might exist
> when the record is collected, but it is of a nature that
> it also can be confirmed by comparing what is
> generated from earlier data --
> Admission. (noting perhaps, if 'already admitted'?)
> Separation. (noting perhaps, if 'still active for
> some admission'?)
> > What I can t seem to do (with my limited skills of syntax) select the
> > appropriate record that encompasses the time period (4th record) and
> > also select any that are admissions on their own (the 1st and
> > 2ndrecords)
> I can't tell what the above record is supposed to
> represent, but on the quickest look, the full set does not
> seem to be limited to one person. But the context, above,
> emphasizes that there are multiple entries for each one.
> That makes the full set rather unintelligible, since each line
> does not identify *which* Person by means of an ID number.
> That's all I can make of it.