Data management question

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 75
Accepted Solution

Data management question

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.


Accepted Solutions
Solution
‎08-22-2013 03:36 AM
Contributor
Posts: 45

Re: Data management question

Posted in reply to NonSleeper

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;

View solution in original post


All Replies
Solution
‎08-22-2013 03:36 AM
Contributor
Posts: 45

Re: Data management question

Posted in reply to NonSleeper

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;

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 155 views
  • 0 likes
  • 2 in conversation