There was a proc expand in the code above, did you run and try that solution on your data? What exactly did you get?   @ezboral wrote: Thanks everyone, I really appreciate the help.  I've not been able to make any of the queries above work in the way I intended.  However, I have made progress.  I've managed to get to the following place.   Region       Year      Qtr    Month   Value  Date North          2001      1        1           100      1/1/2001 North          2001      1        2           100      2/1/2001 North          2001      1        3           100      3/1/2001 North          2001      2        1           103      4/1/2001 North          2001      2        2           103      5/1/2001 North          2001      2        3           103      6/1/2001 North          2001      3        1           106      7/1/2001   If this was my starting point, my goal is simply to take value column and change the orange values to the equidistant value from month to month every quarter.   proc expand was mentioned as a possible solution.  Does anyone know how that might work?   ... View more