Thanks for the advices in advance. Is there a proc that reorders observations according to a specified order? The situation I encountered is as follows:
I was given a dataset in the format of the below, with scenario results for four groups across the columns. In rows are simulated scenarios. So essentially results are by group by scenario.
Scenario Set
Group 1
Group 2
Group 3
Group 4
A
124
100
79
79
B
100
85
109
82
C
128
115
100
102
D
94
73
100
100
E
79
124
76
97
F
100
123
104
121
G
128
100
87
126
H
111
100
100
83
I
100
122
86
100
J
111
100
117
91
However, each group is evaluated by a different system and each system has reordered the results (from A, B... C...) according to some algorithm, so the first result for Group 1 is actually not from the same simulation scenario as Group 2. Provided to me also with the results is a reordering mapping that looks like:
Scenario Set
Group 1
Group 2
Group 3
Group 4
A
1
9
2
8
B
2
2
1
5
C
3
10
3
6
D
4
6
4
4
E
5
5
10
3
F
6
4
8
9
G
7
7
7
10
H
8
3
6
7
I
9
1
9
2
J
10
8
5
1
Which means that, for the first scenario set A, obs 1 from Group 1 (124), obs 9 from Group 2 (122), obs 2 from Group 3 (109) and obs 8 from Group 4 (83) should be reordered as such to form an actual coherent group (where Scenario Set A would be 124, 122, 109 and 83).
Assuming that the data will be provided to me this way, with the scenario results set and a scenarios reordering map, is there any SAS proc that allows reordering according to a pre-speficied order as shown in the map? Thanks.
... View more