awk 'FILENAME=="A"{word[i++]=$1}{freq[$1,FILENAME]=$2}END { for(j=0;j { w=word[j]; printf "%s %g %g %g\n", w,freq[w,"A"],freq[w,"B"],0+freq[w,"B"]/(freq[w,"A"]+freq[w,"B"]) }} ' A B
