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;
Nearly 200 sessions are now available on demand with the SAS Innovate Digital Pass.
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!