data e1;
input x y;
lag_y = lag1(y);
datalines;
1 1
2 .
3 3
4 9
5 13
;
proc expand data=e1 out=e2 method=none;
convert y = lead_one / transformout = (lead 1);
convert y = lag_one / transformout = (lag 1);
run;
expand函数轻松的实现了向后取数据的功能!!!
今天看到的,tql了吧~~~,神奇,对于sas来说,嘿嘿😁!!