[Babase] REPSTATS and the unborn
Karl O. Pinc
babase@www.eco.princeton.edu
Sun, 2 May 2004 16:28:49 -0500
On 2004.05.01 16:52 Karl O. Pinc wrote:
>
> On 2004.05.01 15:34 Jeanne Altmann wrote:
> It's not that you have the wrong stat, you have no row at all and
> so no stat. This seems reasonable to me. If you did have a row
> it would have the wrong number for 'days remaining in state'.
> With no row, using SQL, you get no results for 'incomplete'
> pregnancies. This _sounds_ ok to me.
>
> I'm going to try this with some test data to be sure what I think
> is happening is happening.
Yes, this is what's happening. In general, the cycle statstics
tables don't get data until the cycle is complete. This rule
is immediately broken, because the female's last cycle,
menopause, goes on forever up to the statdate (death).
Because the computer has no clue which females are in
menopause, they all get their last cycle extended to their
statdate which means that most of them will have incorrect
data for their last cycle as the cycles data is entered
much less frequently than the statdate is updated.
We could 'fix' this by adding menopause data, but there's still
other cases where the cycle data the computer generates is just
plain wrong so I don't think this is a good fix, although it might
be in conjunction with something else that will correct the
computer's interpertation when there's gaps in cycles.
I'm kind of thinking I don't want to think about it now....
Karl <kop@meme.com>
Free Software: "You don't pay back, you pay forward."
-- Robert A. Heinlein