So I am trying to do the rolling sum (5 points) in SAS UE adding lags. I also want to get rid of missings, but they are still generated. What is wrong? I tried doing if statements separately but didn't work... data SUM; set work.IMPORT; rollingsum = y+lag1(y)+lag2(y)+lag3(y)+lag4(y); if x=-10 then rollingsum = y; if x=(-9.9) then rollingsum = y+lag1(y); if x=(-9.8) then rollingsum = y+lag1(y)+lag2(y); if x=(-9.7) then rollingsum = y+lag1(y)+lag2(y)+lag3(y); run; obs x y rollingsum 1 -10 0.5440211109 0.5440211109 2 -9.9 0.4575358938 . 3 -9.8 0.3664791293 . 4 -9.7 0.2717606264 . 5 -9.6 0.1743267812 1.8141235416 6 -9.5 0.0751511205 1.3452535511 7 -9.4 -0.024775425 0.8629422319 8 -9.3 -0.124454424 0.3720086791 9 -9.2 -0.222889914 -0.122641861 I want to have obs x y rollingsum 1 -10 0.5440211109 0.5440211109 2 -9.9 0.4575358938 0.5440211109 + 0.4575358938 3 -9.8 0.3664791293 0.5440211109 + 0.4575358938 + 0.3664791293 4 -9.7 0.2717606264 ...+ 0.2717606264 5 -9.6 0.1743267812 1.8141235416 6 -9.5 0.0751511205 1.3452535511 7 -9.4 -0.024775425 0.8629422319 8 -9.3 -0.124454424 0.3720086791 9 -9.2 -0.222889914 -0.122641861
... View more