数据结构如下:
列V1 和V2 总是同时有数据, 列V3和V4也是总是同时有数据。
想在SAS中实现如下功能:
从第一块红色数据开始, V1 和V2同时有数据时,group_id 自动生成1
然后到了第二块蓝色数据, V3和V4同时有数据时,group_id 自动生成2
以此类推, 3, 4, 5 ....
请问如何自动生成这样的列数据?
id | Name | Sale | V1 | V2 | V3 | V4 | group_id |
1 | a | 1.65 | 0 | 1 | 1 | ||
2 | a | 1.66 | 0 | 1 | 1 | ||
3 | a | 1.66 | 0 | 1 | 1 | ||
4 | a | 1.66 | 1 | 0 | 1 | ||
5 | a | 1.65 | 1 | 0 | 1 | ||
6 | a | 1.65 | 1 | 0 | 1 | ||
7 | a | 1.65 | 1 | 0 | 1 | ||
8 | a | 1.53 | |||||
9 | a | 1.5 | 1 | 0 | 2 | ||
10 | a | 1.64 | 1 | 0 | 2 | ||
11 | a | 1.66 | 0 | 1 | 2 | ||
12 | a | 1.66 | 0 | 1 | 2 | ||
13 | a | 1.66 | 0 | 1 | 3 | ||
14 | a | 1.28 | 0 | 1 | 3 | ||
15 | a | 1.28 | 1 | 0 | 3 | ||
16 | a | 1.27 | 1 | 0 | 3 | ||
17 | a | 1.27 | 1 | 0 | 3 | ||
18 | a | 1.26 | |||||
19 | a | 1.25 | |||||
20 | a | 1.25 | |||||
21 | a | 1.26 | |||||
22 | a | 1.25 | 1 | 0 | 4 | ||
23 | a | 1.26 | 1 | 0 | 4 | ||
24 | a | 1.26 | 1 | 0 | 4 | ||
25 | a | 1.26 | 0 | 1 | 4 | ||
26 | a | 1.26 | 0 | 1 | 4 | ||
27 | a | 1 | |||||
28 | a | 2 | |||||
29 | a | 1.27 | 0 | 1 | 5 | ||
30 | a | 1.25 | 0 | 1 | 5 | ||
31 | a | 1.25 | 1 | 0 | 5 | ||
32 | a | 1.25 | 1 | 0 | 5 |