[Babase] Problems with pregnancies
Catherine Markham
amarkham at princeton.edu
Fri Jun 23 09:22:32 EDT 2006
Hi Karl,
Thanks - both look like straightforward corrections. Just to clarify,
though, SIS9 does have a CID entered in the Resume column of PREGS. It
is just that that cycle was missing a tdate, right?
Catherine
Karl O. Pinc wrote:
> Hi,
>
> I'm messing about with Cathrine's latest data updates.
> (I don't have them in production yet.)
>
> I see that the conceive date and the resume date HEI1 pregnancy
> have intervening cycpoints.
>
> Likewise SIS9 has no resume and this is throwing off REPSTATS.
>
>
> select repstats.sname, repstats.date, repstats.state as rstate,
> repstats.dins as rdins, repstats.dr as rdrs, repstats.pid,
> cycstats.state as cstate, cycstats.dins as cdins, cycstats.dr as cdr
> from repstats, cycstats where repstats.sname = cycstats.sname and
> repstats.date = cycstats.date and repstats.state != 'C' order by
> repstats.sname, repstats.date;
>
> select pid, parity, conceive, resume, conceive.date as zdate,
> resume.date as rdate from pregs left outer join cycpoints as conceive
> on (pregs.conceive = conceive.cpid) left outer join cycpoints as resume
> on (resume.cpid = pregs.resume), cycles where cycles.sname = 'SIS' and
> conceive.cid = cycles.cid order by parity;
>
> Aside from this, I think CYCSTATS is ready to go so I'll go ahead
> and copy the new data into production.
>
> Karl <kop at meme.com>
> Free Software: "You don't pay back, you pay forward."
> -- Robert A. Heinlein
>
> _______________________________________________
> Babase mailing list
> Babase at www.eco.princeton.edu
> http://www.eco.princeton.edu/mailman/listinfo/babase
More information about the Babase
mailing list