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