Thanks for the response !
What is a "fifth time loaded" and exactly how to do we tell what it is from the values in the data set?
> Incase of Mon1, the fifth value is 1747 which is fifth from the bottom to top
> Incase of Mon2, the fifth value is 1419 which is fifth from the bottom to top
> It would change for the next month , to a row up again. It follows the sequence from bottom to top on the fifth entered value .
It may help to show the results in terms of NEW variables added to the data instead of attempting to replace them as the replacement has a very good chance of messing with what you are calculating for some values of "xth time loaded".
> yeh even as a separate output dataset which have calc average from 5 vs 4, 5 vs 3 , 5 vs 2 and 5 vs 1 would be fine
Are there ever more or fewer than 10 rows of data? Does the actual value of the S. No have any role in the calculations?
Its not always 10 rows of data, in the mon1 , there is only 9 rows has the value
I have added the S.No here , you can add, or remove any intermediate column if we want to .
I have done the shared output calculation in excel basically , for some of the modelling techniques, I am trying to do the math from SAS
... View more