I would do it in Excel or as a tab separated text file, like this, assuming you have more than one Department. Department Year Month Target Widgets 2013 7 0.4 Widgets 2013 8 0.8 Widgets 2013 9 1.2 Widgets 2013 10 1.6 Widgets 2013 11 2 Widgets 2014 1 2.8 Widgets 2014 2 3.2 Widgets 2014 3 3.6 Widgets 2014 4 4 Widgets 2014 5 4.4 Widgets 2014 6 4.8 Wotsits 2013 7 etc Note that I have rolled Dec/Jan into month 1 of 2014 assuming Dec/Jan means a single report covering both December and January.  If not, provide a separate target row for each month. You can then merge with your existing data (simplify if you do not need to merge Dec/Jan): Proc SQL ;      Create table want as           Select     hav.*                ,        Case                               When Month(Date) = 12 then mdy(1,1, Year(Date)+1)                               else date                          end          as ReptDate                ,         tgt.Target           From   have         hav                ,     Targets     tgt           Where     tgt.Department = hav.Department                and    tgt.Year = Year(calculated ReptDate)                and    tgt.Month = Month(calculated ReptDate)                ; Quit ; [untested code - you may need to create ReptDate in a separate query] Richard ... View more