topic Re: Calculate five days average from current date in SAS Programming

Calculate five days average from current date

ST85 — Sat, 20 May 2017 14:34:31 GMT

Hi,

I have a dataset like presented below:

Brands Date Sales QTY %Delivery

Adidas 5/15/2017 14000 19 45

Adidas 5/15/2017 1000 12 20

Adidas 5/16/2017 10000 5 35

Adidas 5/17/2017 6000 8 20

Adidas 5/18/2017 8000 17 18

Nike 5/16/2017 6000 8 12

Nike 5/17/2017 8000 13 10

Nike 5/18/2017 8000 13 11

I have data like above for different brands and their delivery percentage. The problem is I would like to loop through all the 100 brands and create a flag for each brand where %Delivery (last column) is 40% more than the last 5 day average.

Thank you

Re: Calculate five days average from current date

PeterClemmensen — Sat, 20 May 2017 14:58:56 GMT

Do you want as many records as in your current dataset with a 0/1 flag or do you want 1 record for each brand?

Re: Calculate five days average from current date

Reeza — Sat, 20 May 2017 18:53:36 GMT

http://blogs.sas.com/content/iml/2016/01/27/moving-average-in-sas.html

If you can assume that you have a continuous series, the best solutions are above.

Otherwise you need to first figure out how to deal with breaks in your data.

Re: Calculate five days average from current date

ST85 — Mon, 22 May 2017 07:47:39 GMT

I want one record for each brand. The business problem is if current %delivery is more than last five day's average then create a flag 1 else zero. and then output it

Re: Calculate five days average from current date

ST85 — Tue, 23 May 2017 16:53:08 GMT

I do not have a continous series. I need to calculate this by each brand.

Re: Calculate five days average from current date

Reeza — Tue, 23 May 2017 19:14:10 GMT

Did none of the solutions in the blog work for you?

If not, please explain how.

Re: Calculate five days average from current date

ballardw — Tue, 23 May 2017 19:51:33 GMT

Show what your desired output for the example data should look like.