有以下数据格式如表1,V1~V5分别为5个变量,一行为一个个案,id为个案编号,我想实现的处理是:按id整合,同一个id,其V1-V5的数值合并,形成表2的形式
表1
id | v1 | v2 | v3 | v4 | v5 |
1 | 0 | 0 | 0 | 0 | 0 |
1 | 1 | 0 | 0 | 1 | 1 |
1 | 0 | 1 | 0 | 0 | 0 |
1 | 1 | 0 | 1 | 0 | 1 |
2 | 1 | 0 | 0 | 0 | 0 |
2 | 0 | 0 | 1 | 0 | 0 |
2 | 0 | 1 | 0 | 1 | 0 |
2 | 0 | 0 | 0 | 0 | 0 |
2 | 0 | 1 | 0 | 0 | 0 |
2 | 0 | 0 | 0 | 0 | 1 |
3 | 1 | 0 | 0 | 1 | 0 |
3 | 0 | 1 | 0 | 0 | 0 |
表2
id | v1 | v2 | v3 | v4 | v5 |
1 | 2 | 1 | 1 | 1 | 2 |
2 | 1 | 2 | 1 | 1 | 1 |
请问用SPSS如何操作呢?