I have the following data, where some of the quantities are missing. I want to replace them by a rolling 3 month average of previous 3 months. I've tried to explain what I'm trying to achieve here-    ID Month Qty Rolling average Rolling average value 1 Jan 2 - - 1 Feb 3 2 2 1 Mar 2 average(3,2) 2.5 1 Apr 6 average(2,3,2) 2.333333333 1 May 4 average(6,2,3) 3.666666667 1 Jun 5 AVERAGE(4,6,2) 4 1 Jul . average(5,4,6) 5 1 Aug . average(5,5,4) 4.666666667 1 Sep . average(4.666667,5,5) 4.888888889 1 Oct . average(4.8888889,4.666667,5) 4.851851852 1 Nov . average(4.8518519, 4.888889, 4.666667) 4.802469136 1 Dec . average(4.8024691, 4.8518519, 4.8888889) 4.847736626 2 Jan 5     2 Feb 1     2 Mar 4     2 Apr 3     2 May 4     2 Jun 6     2 Jul .     2 Aug .     2 Sep .     2 Oct .     2 Nov .     2 Dec .       Can anyone please help on how to do this in SAS?  ... View more

Hi,   I have two datasets in my dashboard Data A and Data B -   Data A - Month      Qty Jan22         1 Feb22        2 Mar22        3 Apr22        4 May22       5   Data B- Month      Qty Jun22        1 Jul22         2 Aug22       3 Sep22       4 Oct22        5   I'm looking to create a Data C which appends Data A and B and gives this output-   Month      Qty Jan22         1 Feb22        2 Mar22        3 Apr22        4 May22       5 Jun22        1 Jul22         2 Aug22       3 Sep22       4 Oct22        5   ... View more