Hello @Avishaarky and welcome to the SAS Support Communities!
To keep it simple:
data want(drop=i);
set sales;
array x[100];
array y[100];
do i=3 to 98;
y[i]=mean(x[i-2],x[i-1],x[i],x[i+1],x[i+2]);
end;
run;
2025 SAS Hackathon: There is still time!
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!