If I have data values like Data ABC; infile Cards; Input Var1 var2; Cards; A1 . A2 0.1 A3 0.1 A4 . A5 . B1 0.1 B2 0.1 B3 0.1 B4 . B5 . B6 . B7 0.1 B8 0.1 C1 0.1 C2 0.1 C3 0.1 C4 0.1 C5 . C6 0.1 D1 . D2 . D3 0.1 D4 . Then need cumulative answer like Range variable define a range cumulative start from - to end Cmvt variable for numeric cumulative mis_cum variable for missing cumulative range cumtv mis_cum A0 to A2 . 0.2 A2 to A3 0.2 A3 to A5 . 0.2 B0 to B3 0.5 B3 to B6 . 0.3 B7 to B8 0.2 C0 to C4 0.5 C4 to C5 . 0.1 C5 to C6 0.1 D0 to D2 . 0.2 D2 to D3 0.1 . D3 to D4 . 0.1 We where adding observation A0,B0 It mean if A1=0.1 it mean A1 is completed Means A0-A1=0.1
... View more