SAS新手。有问题请教。先谢过各位大神!
问题如下。
判断每一个日期,如果是每年前6个月和上一年的后6个月则生成同一个标志。
同时判断每一个日期,如果是属于同一年的则生成同一个标志。
数据如下所示。
想了很久,实在是不会,又急着要用,烦请各位大神指教,感激不尽!
| id | date | Wretnd |
| 000001 | 2006-06-16 | -0.19021 |
| 000001 | 2006-06-23 | 0.025316 |
| 000001 | 2006-06-30 | 0.037037 |
| 000001 | 2006-07-07 | 0.019841 |
| 000001 | 2006-07-21 | -0.06615 |
| 000001 | 2006-07-28 | -0.03333 |
| 000001 | 2006-08-04 | -0.04167 |
| 000001 | 2006-08-11 | 0.022489 |
| 000001 | 2006-08-18 | 0.016129 |
| 000001 | 2006-08-25 | 0.008658 |
| 000001 | 2006-09-01 | 0.010014 |
| 000001 | 2006-09-08 | 0.024079 |
| 000001 | 2006-09-15 | 0.055325 |
| 000001 | 2006-09-22 | -0.01835 |
| 000001 | 2006-09-29 | 0.089453 |
| 000001 | 2006-10-13 | 0.106618 |
| 000001 | 2006-10-20 | 0.00443 |
| 000001 | 2006-10-27 | 0.077178 |
| 000001 | 2006-11-03 | -0.01945 |
| 000001 | 2006-11-10 | 0.077244 |
| 000001 | 2006-11-17 | -0.00388 |
| 000001 | 2006-11-24 | 0.233463 |
| 000001 | 2006-12-01 | -0.02051 |
| 000001 | 2006-12-08 | 0.057971 |
| 000001 | 2006-12-15 | 0.015982 |
| 000001 | 2006-12-22 | -0.02547 |
| 000001 | 2006-12-29 | 0.112221 |
| 000002 | 2006-06-02 | -0.05051 |
| 000002 | 2006-06-09 | -0.06206 |
| 000002 | 2006-06-16 | 0.05293 |
| 000002 | 2006-06-23 | -0.02514 |
| 000002 | 2006-06-30 | 0.040516 |
| 000002 | 2006-07-07 | -0.00885 |
| 000002 | 2006-07-14 | 0.107143 |
| 000002 | 2006-07-21 | -0.00161 |
| 000002 | 2006-07-28 | -0.03974 |
| 000002 | 2006-08-03 | -0.02069 |
| 000002 | 2006-08-11 | 0.03169 |
| 000002 | 2006-08-18 | 0.066553 |
| 000002 | 2006-08-25 | 0.024 |
| 000002 | 2006-09-01 | 0.057813 |
| 000002 | 2006-09-08 | 0.001477 |
| 000002 | 2006-09-15 | 0.069322 |
| 000002 | 2006-09-22 | 0.055172 |
| 000002 | 2006-09-29 | -0.01046 |
| 000002 | 2006-10-13 | -0.05548 |
| 000002 | 2006-10-20 | 0.103497 |
| 000002 | 2006-10-27 | 0.03929 |
| 000002 | 2006-11-03 | 0.004878 |
| 000002 | 2006-11-10 | 0.11165 |
| 000002 | 2006-11-17 | 0.146288 |
| 000002 | 2006-11-24 | 0.028571 |
| 000002 | 2006-12-01 | 0.12037 |
| 000002 | 2006-12-08 | -0.03884 |
| 000002 | 2006-12-15 | 0.139295 |
| 000002 | 2006-12-20 | 0.096604 |
| 000002 | 2006-12-29 | 0.062629 |
