UNIX for Dummies Questions & Answers

SNP   BP   CHR  P
snp1  1     3     0.01
snp2  2     2     0.05
.
.

SNP   BP   CHR  P
snp1  1     3     0.06
snp2  2     2     0.3

SNP   BP   CHR  P     P
snp1  1     3     0.01 0.06

ls  -t *.txt > FileList.tmp  # make a file list of all files

cat FileList.tmp | while read line
do grep snp1| awk '{ print $1 $2 }' >temp.txt 
done

awk ' BEGIN {
        printf "SNP\tBP\tCHR\tP\n"
} $1 == "snp1" {
        n = $1 "\t" $2 "\t" $3
        if ( n in R1 )
                RN[n] = RN[n] "\t" $NF
        else
        {
                R1[n] = n
                RN[n] = "\t" $NF
        }
} END {
        for ( k in R1 )
                print R1[k], RN[k]
} ' file*.txt

grep -i "snp1" *.txt | awk 'NR>1{print $NF;next}1' | xargs >new_file