groupType2.awk

{
if (($2 >= 1) && ($2 <= 16) || ($2 >= 61) && ($2 <= 76) ||  ($2 >= 121) && ($2 <= 136)) groupType="Middle";
if (($2 >= 17) && ($2 <= 25) || ($2 >= 77) && ($2 <= 85) ||  ($2 >= 137) && ($2 <= 145)) groupType="Aged";
if (($2 >= 26) && ($2 <= 47) || ($2 >= 86) && ($2 <= 107) ||  ($2 >= 146) && ($2 <= 167)) groupType="NR";
if (($2 >= 48) && ($2 <= 60) || ($2 >= 108) && ($2 <= 120) ||  ($2 >= 168) && ($2 <= 180)) groupType="R";
print ($0)";"groupType;
}