The command below is getting me the output I need.
awk -F"," ' {
if ($6 = 475) print "@@"$3 " " "0000" $10 "0" $1 "00000000" $8}' ${DIR1}${TMPFILE1} | sed -e 's/@@1//g' > ${DIR2}${TPRFILE}

Output:
900018732 00004961160200805160000000073719

Now I need to incorporate this sed command to reformat the date to mmddyy:
sed 's/^\(..\)\(..\)\(..\)\(..\)$/\3\4\2/'

Any ideas...