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;
April 27 - 30 | GAYLORD TEXAN
Register now to lock in early bird pricing through February 25!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.
Browse our catalog!