Data management question

NonSleeper — Thu, 22 Aug 2013 06:36:55 GMT

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.

Re: Data management question

Murray_Court — Thu, 22 Aug 2013 07:36:48 GMT

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;

topic Re: Data management question in SAS Programming

Data management question

Re: Data management question