<HTML>
<style> BODY { font-family:Arial, Helvetica, sans-serif;font-size:12px; }</style><br>
<span style="font-weight: bold;">On Wed 18/11/09 10:44 AM , "Karl O. Pinc" kop@meme.com sent:<br>
</span><blockquote style="border-left: 2px solid rgb(245, 245, 245); margin-left: 5px; margin-right: 0px; padding-left: 5px; padding-right: 0px;">On 11/18/2009 09:34:37 AM, Susan Alberts wrote:<br>
<span style="color: rgb(102, 102, 102);">> This problem is historic, it has always been true in the database, </span><br>
<span style="color: rgb(102, 102, 102);">> all</span><br>
<span style="color: rgb(102, 102, 102);">> </span><br>
<span style="color: rgb(102, 102, 102);">> of these are males that date from the original version of babase. It </span><br>
<span style="color: rgb(102, 102, 102);">> has been on our list for a long time, but we are just now getting to </span><br>
<span style="color: rgb(102, 102, 102);">> it now that other more urgent data entry issues are being addressed.</span><br>
<br>
So the answer is to fix the CENSUS rows to use the modern Status<br>
values with rows that are in existence (or not) as current protocol<br>
dictates. Which probably means deleting a lot of rows.<br>
<br>
I don't think that more recent immigrant males are in MEMBERS<br>
at all in between their "birth" and when they first appear,<br>
right?<br>
<br>
Niki writes:<br>
No, it looks like they show up in members as being interpolated in group 9 from birth up through the day before they appear in the census. See ZAK as an example. So it sounds like Karl's plan of deleting all the weird census data prior to the date of entry to a study group is a good start - if we then change the entry on the entry date to a regular census entry, it should interpolate the male as group 9 prior to that, right? At least as long as that is listed as their matgroup. And then I guess we can worry about the other old codes that occur after the entry date when the real census data is ready for upload.<span style="color: rgb(102, 102, 102);"><br>
<br>
</span>
<span style="color: rgb(102, 102, 102);">> Susan</span><br>
<span style="color: rgb(102, 102, 102);">> </span><br>
<span style="color: rgb(102, 102, 102);">> </span><br>
<span style="color: rgb(102, 102, 102);">> On Nov 18, 2009, at 10:31 AM, Jeanne Altmann wrote:</span><br>
<span style="color: rgb(102, 102, 102);">> </span><br>
<span style="color: rgb(102, 102, 102);">> > Wow, that feels like a lot of animals. Do you see a pattern in this </span><br>
<span style="color: rgb(102, 102, 102);">> </span><br>
<span style="color: rgb(102, 102, 102);">> > problem? My guess is that what you plan is right, but it is Karl &/ </span><br>
<span style="color: rgb(102, 102, 102);">> > or Niki who will know—and then please see if a change is needed in </span><br>
<span style="color: rgb(102, 102, 102);">> > the documentation. I think Niki is at a prenatal appointment this </span><br>
<span style="color: rgb(102, 102, 102);">> > morning, so we shouldn’t assume she is w/baby yet but you may not </span><br>
<span style="color: rgb(102, 102, 102);">> > get a response right away from her).</span><br>
<span style="color: rgb(102, 102, 102);">> > jeanne</span><br>
<span style="color: rgb(102, 102, 102);">> ></span><br>
<span style="color: rgb(102, 102, 102);">> > From: <a href="mailto:babase-bounces@eeblistserv.princeton.edu">babase-bounces@eeblistserv.princeton.edu</a></span><br>
<span style="color: rgb(102, 102, 102);">> [<a href="mailto:babase-bounces@eeblistserv.princeton.edu">babase-bounces@eeblistserv.princeton.edu</a> </span><br>
<span style="color: rgb(102, 102, 102);">> > ] On Behalf Of Lacey Maryott Roerish</span><br>
<span style="color: rgb(102, 102, 102);">> > Sent: Wednesday, November 18, 2009 10:20 AM</span><br>
<span style="color: rgb(102, 102, 102);">> > To: The Baboon Database Project</span><br>
<span style="color: rgb(102, 102, 102);">> > Subject: [Babase] Changing Immigrant Male Census Data</span><br>
<span style="color: rgb(102, 102, 102);">> ></span><br>
<span style="color: rgb(102, 102, 102);">> > Good morning,</span><br>
<span style="color: rgb(102, 102, 102);">> ></span><br>
<span style="color: rgb(102, 102, 102);">> > This message is primarily for Karl/Niki (if Niki is still sans </span><br>
<span style="color: rgb(102, 102, 102);">> > baby). I have a list of 25 immigrant males who have a matgrp of 9, </span><br>
<span style="color: rgb(102, 102, 102);">> </span><br>
<span style="color: rgb(102, 102, 102);">> > but who, instead of being in group 9 from birth until their entry </span><br>
<span style="color: rgb(102, 102, 102);">> > date, are actually shown to be in their 'entry group' at birth. I </span><br>
<span style="color: rgb(102, 102, 102);">> > have, for all of these males, the list of actual dates when they </span><br>
<span style="color: rgb(102, 102, 102);">> > should enter our population.</span><br>
<span style="color: rgb(102, 102, 102);">> > What I am not sure of is, if I simply change the date prior to </span><br>
<span style="color: rgb(102, 102, 102);">> > their entry date to group 9... will it interpolate back to 9 for </span><br>
<span style="color: rgb(102, 102, 102);">> the</span><br>
<span style="color: rgb(102, 102, 102);">> </span><br>
<span style="color: rgb(102, 102, 102);">> > rest of their young lives.... do I have to make incremental </span><br>
<span style="color: rgb(102, 102, 102);">> changes,</span><br>
<span style="color: rgb(102, 102, 102);">> </span><br>
<span style="color: rgb(102, 102, 102);">> > do I just change their group at birth date and group at the day </span><br>
<span style="color: rgb(102, 102, 102);">> > before entry?</span><br>
<span style="color: rgb(102, 102, 102);">> > I have tried reading through the documentation but it isn't </span><br>
<span style="color: rgb(102, 102, 102);">> > obvious to me what the best method is to get babase to understand </span><br>
<span style="color: rgb(102, 102, 102);">> > that these males are really in grp 9 until their entry dates.</span><br>
<span style="color: rgb(102, 102, 102);">> ></span><br>
<span style="color: rgb(102, 102, 102);">> > Any input?</span><br>
<span style="color: rgb(102, 102, 102);">> ></span><br>
<span style="color: rgb(102, 102, 102);">> > Thanks</span><br>
<span style="color: rgb(102, 102, 102);">> > Lacey</span><br>
<span style="color: rgb(102, 102, 102);">> ></span><br>
<span style="color: rgb(102, 102, 102);">> > -- </span><br>
<span style="color: rgb(102, 102, 102);">> > - -</span><br>
<span style="color: rgb(102, 102, 102);">> > Lacey K. Maryott Roerish</span><br>
<span style="color: rgb(102, 102, 102);">> > Alberts Lab</span><br>
<span style="color: rgb(102, 102, 102);">> > Department of Biology</span><br>
<span style="color: rgb(102, 102, 102);">> > Duke University</span><br>
<span style="color: rgb(102, 102, 102);">> > ph: 919-660-7306</span><br>
<span style="color: rgb(102, 102, 102);">> > fax: 919-660-7293</span><br>
<span style="color: rgb(102, 102, 102);">> > <a href="mailto:Lacey.Maryott@duke.edu">Lacey.Maryott@duke.edu</a></span><br>
<span style="color: rgb(102, 102, 102);">> > _______________________________________________</span><br>
<span style="color: rgb(102, 102, 102);">> > Babase mailing list</span><br>
<span style="color: rgb(102, 102, 102);">> > Babase@<a target="_blank" href="<a href="http://www.eco.princeton.edu">http://www.eco.princeton.edu</a>">www.eco.princeton.edu</a></span><br>
<span style="color: rgb(102, 102, 102);">> > <a target="_blank" href="http://www.eco.princeton.edu/mailman/listinfo/babase"><span style="color: red;">http://www.eco.princeton.edu/mailman/listinfo/babase</span></a></span><br>
<span style="color: rgb(102, 102, 102);">> </span><br>
<span style="color: rgb(102, 102, 102);">> ------------------------------------------------------------</span><br>
<span style="color: rgb(102, 102, 102);">> Susan Alberts, Dept of Biology, Duke University, Box 90338, Durham NC </span><br>
<span style="color: rgb(102, 102, 102);">> </span><br>
<span style="color: rgb(102, 102, 102);">> 27708. Phone 919-660-7272, FAX 919-660-7293</span><br>
<span style="color: rgb(102, 102, 102);">> </span><br>
<span style="color: rgb(102, 102, 102);">> </span><br>
<span style="color: rgb(102, 102, 102);">> </span><br>
<span style="color: rgb(102, 102, 102);">> </span><br>
<span style="color: rgb(102, 102, 102);">> _______________________________________________</span><br>
<span style="color: rgb(102, 102, 102);">> Babase mailing list</span><br>
<span style="color: rgb(102, 102, 102);">> Babase@<a target="_blank" href="<a href="http://www.eco.princeton.edu">http://www.eco.princeton.edu</a>">www.eco.princeton.edu</a></span><br>
<span style="color: rgb(102, 102, 102);">> <a target="_blank" href="http://www.eco.princeton.edu/mailman/listinfo/babase"><span style="color: red;">http://www.eco.princeton.edu/mailman/listinfo/babase</span></a></span><br>
<span style="color: rgb(102, 102, 102);">> </span><br>
<span style="color: rgb(102, 102, 102);">> </span><br>
<br>
<br>
<br>
<br>
Karl <<a href="mailto:kop@meme.com">kop@meme.com</a>><br>
Free Software: "You don't pay back, you pay forward."<br>
-- Robert A. Heinlein<br>
<br>
<br>
_______________________________________________<br>
Babase mailing list<br>
Babase@<a target="_blank" href="<a href="http://www.eco.princeton.edu">http://www.eco.princeton.edu</a>">www.eco.princeton.edu</a><br>
<a target="_blank" href="http://www.eco.princeton.edu/mailman/listinfo/babase"><span style="color: red;">http://www.eco.princeton.edu/mailman/listinfo/babase</span></a><br>
<br>
</blockquote></HTML>