Hello, I am new in working with SAS and hope someone can help me with my problem. I have to subtract var2 from var1 and so on in my example but the problem is, that the values are in different lines although the ID is similar. So the question is how can I copy the values for one varibáble into the other lines for the same ID. So to copy the values depentent on the value in the variable ID (see second table how the result should look like). ID var1 var2 var3 result1=var1-var2 result2=var2-var3 1 . 4 . 1 . 4 . 1 2 . . 1 2 . 2 1 . . 2 2 9 . . 2 9 . . 2 . . . 2 . . 1 2 . . 1 3 3 . . 3 3 . . 3 . 2 . 3 . 2 . 3 . . 7 3 . . 7 ID var1 var2 var3 result1=var1-var2 result2=var2-var3 1 2 4 2 -2 2 1 2 4 2 -2 2 1 2 4 2 -2 2 1 2 4 2 -2 2 1 2 4 2 -2 2 2 9 . 1 . . 2 9 . 1 . . 2 9 . 1 . . 2 9 . 1 . . 2 9 . 1 . . 3 3 2 7 1 -5 3 3 2 7 1 -5 3 3 2 7 1 -5 3 3 2 7 1 -5 3 3 2 7 1 -5 3 3 2 7 1 -5 I only found the function to retain values dependent on the previous value but that wouldn help in my case. So I would be very happy if someone yould help! Thank you so much and best regards! Sarah
... View more