Hi, In by group processing, I am trying to backfill previous group's values with the values available for next group. An example will be more helpful in illustrating what I am trying to do Have Want ID1 ID2 Date ID1 ID2 Date Date_ 0001 10 20051231 0001 10 20051231 20061231 0001 20 20051231 0001 20 20051231 20061231 0001 30 20051231 0001 30 20051231 20061231 0001 40 20051231 0001 40 20051231 20061231 0001 10 20061231 0001 10 20061231 20071231 0001 20 20061231 0001 20 20061231 20071231 0001 30 20061231 0001 30 20061231 20071231 0001 40 20061231 0001 40 20061231 20071231 0001 10 20071231 0001 10 20071231 20071231 0001 20 20071231 0001 20 20071231 20071231 0001 30 20071231 0001 30 20071231 20071231 0001 40 20071231 0001 40 20071231 20071231 The groups are formed by ID1 and ID2 and the date column is the same for all observations within the group. As the 'want' table shows, the date value from next group of observation is backfilled to previous group of observations. For the last group, date and date_ columns have the same value. Would appreciate any help on how to achieve this. Thanks.
... View more