thanks alot, it helps alot ... View more

thank you very much, the code worked perfectly, can you explain me please what is the use of drop c for the original dataset, and retain for the output one? also why this instuction: put first.id last.id; ? thank you    ... View more

Good Day every one,  I am new with SAS and i am having a problem in calculating the cumulative sum of values, my table looks like this one     I used this code to calculate the cumulative sum in column C, by respect to id data Ratings1; Set Ratings; retain c; if first.id then c=0; by id notsorted; c+j1; run; the problem i have is that it gives me as result the same values as in column j1 as if the addition is not working. Can you help me please , where is the problem in this code   thank you in advance   ... View more