如何根据变量no得到变量z

1. data aaa;
   
2. input no a1$ b1 c1;
   
3. cards;
   
4. 1 x1 1 1
   
5. 1 z1 2 1
   
6. 1 y1 1 2
   
7. 2 x2 1 2
   
8. 2 y2 1 2
   
9. 3 x3 2 2
   
10. ;
    
11. run;

复制代码

如何根据变量no得到变量z？谢谢！

no a1 b1 c1 z
1 x1 1 1 1
1 z1 2 1 2
1 y1 1 2 3
2 x2 1 2 1
2 y2 1 2 2
3 x3 2 2 1

data wanted;
set aaa;
if no ne lag(no) then z=1;
else z+1;
run;

data aaa;
input no a1$ b1 c1;
cards;
1 x1 1 1
1 z1 2 1
1 y1 1 2
2 x2 1 2
2 y2 1 2
3 x3 2 2
;
run;
proc sort data=aaa out=b;
by a1;
run;
data c(rename=(no=z));
set b(keep=no);
run;
data bb;
merge aaa c;
run;

1. data aaa;
   
2. input no a1$ b1 c1;
   
3. cards;
   
4. 1 x1 1 1
   
5. 1 z1 2 1
   
6. 1 y1 1 2
   
7. 2 x2 1 2
   
8. 2 y2 1 2
   
9. 3 x3 2 2
   
10. ;
    
11. run;
    
12. proc sort data=aaa;by no;run;
    
13. 
    
14. data bbb;
    
15.         set aaa;
    
16.         by no;
    
17.         if first.no then z=1;
    
18.         else z+1;
    
19. run;

复制代码

wwang111 发表于 2014-3-3 11:12
data wanted;
set aaa;
if no ne lag(no) then z=1;

厉害啊，赞个，学习了！