Thank you so much for your answering. I read it and find my understanding before was not wrong. However, when I do it again I find I make a stupid mistake. I ignore there are so many colunms in the excel and just read the first few columns. Thanks again.
And I wonder if you can help me for anther question. I am using another uncommon software called AML.The input file needs SNPs information. And there are two codes.
- 0=missing, 1 = common homozygote, 2 = heterozygote, 3 = rare homozygote.
- ACGT format (N = missing).
I only know the first as follows:
patientid,status,snp1,snp2,snp3
p1,0,2,2,2
p2,0,2,2,3
p3,0,2,2,1
Can you give me some suggest for the second format?