不用SQL更方便:
%macro test;
data aa1;
set a;
%do i=1 %to 99;
high&i=lag&i(highprice);
low&i=lag&i(lowprice);
%end;
day100max=max(of highprice high1-high99);
day100min=min(of lowprice low1-low99);
run;
%mend test;
%test;
楼主: 马甲1号
|
3011
10
请教一条SQL语句 |
副教授 23%
-
|
20论坛币
最佳答案本帖被以下文库推荐
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| ||
It was the best of times, it was the worst of times.
|
||
| ||
扎扎实实学知识,老老实实去做人!
|
||
| ||
京ICP备16021002-2号 京B2-20170662号 京公网安备 11010802022788号 论坛法律顾问:王进律师 知识产权保护声明 免责及隐私声明