移动平均值

2021-05-20 本文已影响0人 FlyingPeter

T1:
LOAD F1,F2,F2 AS F3,1 AS FLAG;
load * inline [
F1,F2
a,1
b,2
c,3
d,4
e,5
f,6
];

FOR n=1 to 3

let tn = $(n)+1;

NoConcatenate
T $(tn): load F1,F2, F3+Peek(F2,-$ (n)) AS F3
Resident T $(n); DROP table T$ (n);

FinalTable:
load *,F3/ $(n) as avg_value Resident T$ (tn);
DROP Table T$(tn);

EXIT Script;