This can also be done with Proc SQL:
proc sql;
CREATE TABLE test7 AS
select T.*, group
from test6 as T left join groups as G
on T.Sex=G.Sex
order by id, Month; quit;