Hello All ,
I am new to SAS Time Series . My Objective is to find top selling period in intervals ( 12 weeks ) by item in a given period .
I would like to know if we have any SAS Procedures to help .
Appreciate any help .
Ex : I have item, year , week , date , Units_sold ( 2 years of data 2017 - 2019 ) . I would like to know in which 12 weeks period sum of those units would be higher .
2017w1 - 2017w13 - 1000
2017w2 - 2017w14 - 1010
2017w3 - 2017w15 - 990
upto all 2018 end and need to find the greatest units sold . for each item .
I would also need to play with the interval changing from 12 to 6 or 3 based on different scenarios .
Thanks,
Subhash
The best way is probably to define all the possible intervals in a format (use option multilabel) and then use proc means with option mlf.
Thanks will try . I stumbled on to Proc Expand . Still exploring . Will post if it works .
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
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.