Hello everyone,
I was hoping someone could help me. I am trying to create a variable that would count each "1" until the following "0", as demonstrated in the example "newvar". This "newvar" is the variable I am trying to create, unsuccessfully... I am not sure if it is possible to reset the "sum" variable for each zero.
Expectation:
gov1change newvar
0
1 1
1 2
1 3
1 4
0
1 1
1 2
1 3
1 4
1 5
1 6
1 7
0
1 1
1 2
1 3
1 4
1 5
0
However, what I have is a variable called "gov1cum":
gen gov1cum = .
replace gov1cum = sum(inrange( gov1change[_n], 0,1)) if gov1change!=0
gov1change gov1cum
0
1 1
1 2
1 3
1 4
0
1 5
1 6
1 7
1 8
1 9
1 10
1 11
0
1 12
1 13
1 14
1 15
1 16
0
I would be very happy if someone could tell me if its possible to create such a variable... Thank you very, very much.
Cat
Related Posts with Help: Sequential Count in Between Two Variable Values
Merge based on several variables matchingHi fellow Stata users, I'm working on a population of cancer patients and for that I have two datas…
Need Help: On Constructing Some Tables with Attendance DataThis is how my Attendance data looks like: Date TeachersName Student1 Student2 Student3 Student4 …
System GMM - Interpreting the outputHello, I am estimating whether the total value of stocks traded and credit to the private sector ha…
Upon saving my stata ouput as a .tex file, sigificance is disappearing. Why is this happening?hi statalist, I am having a peculiar problem while using estout to save my output as a tex file. I …
How to calculate standardized mean difference using ipdmetan (two-stage IPD meta-analysis)?Hi everyone, I'm running a two-stage IPD meta-analysis by using ipdmetan: ipdmetan, study(StudyID) …
Subscribe to:
Post Comments (Atom)
0 Response to Help: Sequential Count in Between Two Variable Values
Post a Comment