Hello;
I have a data set which shows the sales data over a period of time in different zip codes. In a second data set, I have the purchase date of the product for each customer.
I want to calculate the total sales from the beginning of time until the month before each customer has purchased the product in each zip code; in other words, I want to know the aggregate number of people had purchased the product in the vicinity (zip code) of each customer until the month before he/she purchased the product. ; I appreciate if anyone can give me a hint of how I can do this.
Thanks for reading this post.
the data sets are like this:
Sales data set:
*Please note that all of the missing observations in this data set should be considered zero;
data sales;
input obs zipcode jan10 feb10 mar10 apr10 mar10 jun10 july10 aug10 sep10 oct10 nov10 dec10 jan11 feb11;
data lines;
1 14001 1 . . . . . . . . . . . . . . . . .
2 14009 1 . . . . . . . . . . . . . . . . .
3 14011 . 1 . . . . . . . . . . . . . . . .
4 14020 . . 1 . . . . . . . . . . . . . . .
5 14026 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0
6 14031 . . . . . . . . . . . . . . . . . .
7 14036 . . 1 . . . . . . . . . . . . . . .
8 14043 . . . . . . . . . . . . 1 1 . . . .
9 14047 . . . . . . . . . . . . . . . . . .
10 14048 . . . . . . . . . . . . . . . . . .;
run;
purchase data set:
data purchasedate;
input customername $ customerzipcode purchasedate $;
datalines;
Customer1 14001 July10
customer2 14043 Jan11
....
run;
