I have a bunch of text files to restructure for analysis in PLINK. Any SAS programmers in Sajha who can help to resolve this. To make this simple I have copied first 4 rows from 3 files and showed in the last 3 rows that the file I want to create. Please let me know if somebody is willing t help on this problem. I can e-mail the files. Thanks!!!!!

Filename: FileReport1.txt

#Source file: FinalReport1.csv

#Column header: SNP_id allele1_Forward allele2_Forward GenCall_score intensity1 intensity2

200006 T C 0.8190 1.253 1.110

200052 T T 0.9526 0.021 0.928

Filename: FileReport42.txt

#Source file: FinalReport42.csv

#Column header: SNP_id allele1_Forward allele2_Forward GenCall_score intensity1 intensity2

200006 T C 0.8190 1.049 1.004

200052 T T 0.9526 0.019 0.928

Filename: FileReport53.txt

#Source file: FinalReport53.csv

#Column header: SNP_id allele1_Forward allele2_Forward GenCall_score intensity1 intensity2

200006 C C 0.8190 0.043 1.637

200052 A T 0.9526 0.690 0.691

Restructured data into a file like below:

SNP_id A1_1 A2_1 A1_42 A2_42 A1_53 A2_53

200006 T C T C C C

200052 T T T T A T