Data management question

[NonSleeper]

The data looks like this:

data temp;

input Group ID Var;

datalines;

1     11     111

1     22     222

1     33     333

2     11     111

2     33     333

2     22     222

3     22     222

3     11     111

3     33     333

;

run;

The set-up is: For each Group, there is a different ordering of ID with corresponding Var. That can be thought of as a result of a permutation process.

Now I want to apply the order of ID in the first group to subsequent groups and don't change the order of Var. The new data should look like:

1     11     111

1     22     222

1     33     333

2     11     111

2     22     333

2     33     222

3     11     222

3     22     111

3     33     333

If possible, please give some solution other than sql or iml as I'm not familiar with them.

[Murray_Court · Accepted solution]

This should work:

data temp;
input Group ID Var;
datalines;
1     11     111
1     22     222
1     33     333
2     11     111
2     33     333
2     22     222
3     22     222
3     11     111
3     33     333
;

run;

proc sort data=temp(keep=group id) out=temp2;
by group ID;
run;

data want;
set temp2;
set temp(keep=Var);
run;