Hello, I'm trying to iterate through a dataset for a specific set of rows (say 5), so for the first observation when it is read it has to read through the next 4 rows. So when we read the second observation it has to loop through 3,4,5,6 rows and for third obs read through rows 4-7 & so on... When it comes to the bottom rows it should read what is left over. Like in row 10, it can read only 11 & 12. Is there a way to achieve this through retain statements or array? the dataset might look like below: DSet : A ID Date Cost 1 8/1/2020 100 2 8/2/2020 230 3 8/3/2020 450 4 8/4/2020 660 5 8/5/2020 670 6 8/6/2020 230 7 8/7/2020 420 8 8/8/2020 110 9 8/9/2020 430 10 8/10/2020 140 11 8/11/2020 180 12 8/12/2020 340
... View more