Given the dataset, each region's reorder points bucket (based on month) is:   Bucket Region 22 Region 11 1 15-Sep 15-Sep 2 15-Jan 15-Nov 3 15-Mar 15-Jan 4 15-Jun 15-Mar 5   15-May 6   15-Jul   Expectation is to assign those products and their quantities (whose LastChancetoOrder date falls between any bucket) to the closest bucket before LastChancetoOrder     The result should look like below (last column ReorderBucket)   RegionID MonthYear ProductCode ShortageQty LastChancetoOrder OrderFirstDate MonthsBetweenOrders NoofOrdersPerYear DeliveryLeadTime ReorderBucket 11 1/1/2018 FA-520I 31 10/1/2017 15-Sep 2 6 3  15-Sep-2017 11 2/1/2018 FA-465C 6 11/1/2017 15-Sep 2 6 3  15-Sep-2017 11 2/1/2018 FA-520I 6 11/1/2017 15-Sep 2 6 3  15-Sep-2017 22 3/1/2018 FA-465C 6 12/1/2017 15-Sep 3 4 3  15-Sep-2017 22 3/1/2018 FA-696 3 12/1/2017 15-Sep 3 4 3  15-Sep-2017 22 4/1/2018 FA-465C 5 2/1/2018 15-Sep 3 4 3  15-Jan-2018 ... View more

Thank you   now i have couple of more records with below instance sno 4,5 INPUT sno txt sq 1 a 1 1 b 2 1 u 3 1 u 4 1 u 5 1 c 6 2 a 1 2 b 2 3 a 1 3 b 2 3 u 3 3 c 4 3 u 5 3 u 6 4 u 1 4 b 2 5 a 1 5 u 2 5 b 3   Need output as shown below variable txt with 'u' observation for sno 4 and 5 as well   OUTPUT sno txt sq 1 a 1 1 b 2 1 bu 3 1 bu 4 1 bu 5 1 c 6 2 a 1 2 b 2 3 a 1 3 b 2 3 bu 3 3 c 4 3 cu 5 3 cu 6 4 bu 1 4 b 2 5 a 1 5 bu 2 5 b 3 ... View more

  proc sql; create table want as select a.employee_id from full_employee a full join terminated b on a.employee_id = b.employee_id where b.employee_id is missing with join need to do a full join followed by employee_id is missing for terminated table   ... View more

Do you only have a single record per day?  If so, PROC EXPAND with a CONVERT statement will do what you want. You may need to add a record for every day, but you can do that easily with PROC TIMESERIES.   If you need further help, please provide the code you've attempted thus far and your data, preferably as a data step.    This is a commonly asked question, so if you don't have SAS/ETS search for moving statistics via an array or DoW loop and you'll find many answers.  ... View more