topic Time Series data - Need to find top selling period by accumulating in SAS Programming

Time Series data - Need to find top selling period by accumulating

dsubashkashyap0 — Thu, 25 Jul 2019 17:52:11 GMT

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

Re: Time Series data - Need to find top selling period by accumulating

ChrisNZ — Fri, 26 Jul 2019 00:00:11 GMT

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.

Re: Time Series data - Need to find top selling period by accumulating

dsubashkashyap0 — Fri, 26 Jul 2019 14:14:46 GMT

Thanks will try . I stumbled on to Proc Expand . Still exploring . Will post if it works .