seq | total |
1 | 4 |
2 | 4 |
3 | 4 |
4 | 4 |
. | . |
. | . |
1 | 2 |
2 | 2 |
. | . |
Specialized on Data processing, Data management Implementation plan, Data Collection tools - electronic and paper base, Data cleaning specifications, Data extraction, Data transformation, Data load, Analytical Datasets, and Data analysis. BJ Data Tech Solutions teaches on design and developing Electronic Data Collection Tools using CSPro, and STATA commands for data manipulation. Setting up Data Management systems using modern data technologies such as Relational Databases, C#, PHP and Android.
Thursday, July 30, 2020
Simple sum within the same variable
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:
thanks in advance for your help!
No comments:
Post a Comment