Data groups;
inputsex $ group ;
datalines;
M 1
F 2
;
run;
Now do a one-to-one merge:
proc sort data=test3;by sex;
proc sort data=groups;by sex;
datatest4;
merge test3 groups; bysex; run;
See the data is sorted by sex.