各位大侠。我现在有如下数据:
X HY
1 1
2 1
····
10 1
11 2
12 2
····
19 2
20 3
·····
29 3
30 4
31 4
·····
1100 105
1101 105
1102 105
我想要转换成如下格式:
X HY HY01 HY02 HY03 ·········HY105
1 1 1 0 0 0
2 1 1 0 0 ············ 0
····
10 1 1 0 0 ·········· 0
11 2 0 1 0 ··········· 0
12 2 0 1 0 ···········0
····
19 2 0 1 0 ···············0
20 3 0 0 1 ··············0
·····
29 3 0 0 1 ············0
30 4 ··········
31 4··········
·····
1100 105 ·······
1101 105 ·······
1102 105··················1
也就是说,HY最大值为n的话,就想要产生n列数据并且每列的命名依次为HY01到HY0n,只有当HY的值与HY0n中的n相等时,才要求HY0n=1,并且同行中的其他列全部要等于0。感觉要用到很复杂的宏语言。所以,跪求高手指点。