数据:
TYPE Group Month Amount
silver DY 1 12900
silver DY 2 10000
silver DY 3 17800
Gold TO 1 8000
Gold TO 2 .
Gold TO 3 .
. IT 1 .
. .
然后用retain (use if first...if last语句)从上面的第一步到下面:
obs Group Month total amount
1 DY 1 47900
2 DY 2 37000
3 DY 3 72800
4 IT 1 64900
5 IT 2 .
6 IT 3 .
7 TO 1 .
8 TO 2 .
9 TO 3
想请问一下各位,如何用sas从第一步到第二步呢?谢谢