[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