@adamhyman If you want actual code for your data then don't just post a picture but post SAS datasteps creating representative sample data.   As for the joining: The only thing you need to do is to shift in your first table the date to the Sunday. After that you can join the two tables over the Item and Sunday date. The code I've posted demonstrates how you can shift the date_of_forcast to the Sunday date - try to understand it. ... View more

James, This blog post shows how to use FILENAME ZIP to extract content from a ZIP file: http://blogs.sas.com/content/sasdummy/2014/01/29/using-filename-zip/ There are some comments in the post that have some helpful variations.  There isn't an "Unzip" function in SAS, so pulling data sets from the ZIP file will involve some brute-force copy methods that you might need to play around with.  See some examples in this article. Chris ... View more

And another vote with the group. Generally, in documenting software functionality, a good approach is VERB NOUN(s), where: VERB should be a specific action done by the software (Sort, Merge, Display, Report ...). Don't use "general" terms like Process, as they don't provide any insight. NOUN(s) should be objects that make sense in your business terminology (Customer, Part Number, Financial Code). So you can see that "SPLIT OUT BAD CUSTOMER NUMBERS" is a very good name for the process. As an additional benefit, this will tend to drive your programs towards implementing single functions that can be clearly described, which is beneficial for ongoing maintenance. When you find yourself using more than one verb, or resorting to verbs like PROCESS, it's time to start thinking about whether your program is a muddle of coincidentally linked functions. Tom ... View more

Can also use DOW's counter: data want;   do count=1 by 1 until (last.fruit);   set myfruit; by fruit;   output;   end; run; Haikuo ... View more