Hello, I'm trying to expand the data that I have for the weeks that are missing. I have weekly data and the number of purchases in a certain week. Now I want to create an observation for the weeks that are missing as the number of purchases in those weeks are 0. The data looks like the following (except I have way less missing weeks): Year Week Num_purch 2008 1 10 2008 3 4 2008 10 5 2008 21 10 2008 22 3 ... 2016 51 10 What I want is then: Year Week Num_purch 2008 1 10 2008 2 0 2008 3 4 2008 4 0 2008 5 0 2008 6 0 etc. Also, my data contains several years from 2008 to 2016. I have no clue where to start. I think with a proc expand. Also don't know how to google on this problem, do not seem to find the same problem. Oh, forgot to mention, I have this not one time, but for 200 different ID codes in one time. Thanks!
... View more