I have a time series containg data over a stretch of 52 weeks. My goal is the following : to smooth with an equallly weighted moving average the observations were no promotion (kinda looking for outliers) is present in order to use this new series for model setup and forecasting. Does proc expand provide with such an option? cause if i am not mistaken i have to use the whole series as an input or maybe i havent crasped the concept of proc expand in its whole.
I will give it a try, but I'm pretty sure I'm missing the mark - in this example I'm using EXPAND to "smooth a pattern" with a moving average window of 5 observations:
proc expand data=sashelp.air out=out method=none;
convert air=predict / transformout=(movave 5);
set sashelp.air out;
proc sgplot data=out;
series x=date y=air;
series x=date y=predict;
It would be very helpful if you could an example (how does the data look like now? How would you like the results to look like?).
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
Learn how to run multiple linear regression models with and without interactions, presented by SAS user Alex Chaplin.
Find more tutorials on the SAS Users YouTube channel.