Date:         Fri, 23 May 2008 08:23:39 -0500
Reply-To:     Citam <citam.sasl@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Citam <citam.sasl@GMAIL.COM>
Subject:      Re: Merging on either the ID or AltID
In-Reply-To:  <00c701c8bc4d$d15f5a50$832fa8c0@HP82083701405>
Content-Type: text/plain; charset=ISO-8859-1

On 5/22/08, Mary <mlhoward@avalon.net> wrote:
> OK, new question!
>
> I have one data set that has one ID in it.  Example, ID and 3 variables (Allele results Allele1 Allele2 Allele3)
>
> 001-01 AA CC AC
> 002-01 AC AA AC
> 003-01 AA AC AC
> 004-01 AA AA AA
>
> I have another data set that has both an ID and sometimes a second Alternate ID in it (ID, ALTID, Allele4) I'm putting XXX-XX to show the place but in my data they are just missing.
>
> 001-01 XXX-XX GT
> 002-01 XXX-XX TT
> 003-00 003-01  GT

I see you have a solution, so I will just ask about the structure of
your data.  Is this pedigree data?  It appears as if you might be
using offspring data for the parent.  Several packages can do the
"imputation", if this is the case.  Off the top of my head, I would
start with Merlin or SimWalk, or maybe GeneCounting for haplotypes.
Otherwise, I might avoid such suggestive IDs.