hello, this may be a very simple question but is it possible to create a variable that simply sums consecutive numbers within the same variable separated by different number of missings (i.e., '.')? so the information I have is under the variable 'seq' and I want to create the variable 'total' - see example below:
seq total
1 4
2 4
3 4
4 4
. .
. .
1 2
2 2
. .
thanks in advance for your help!