I have a small long format dataset below.
* Example generated by -dataex-. For more info, type help dataex
clear
input byte (gender period pr)
1 1 11
1 1 11
1 1 11
1 2 15
1 2 15
1 2 15
2 1 11
2 1 11
2 1 11
2 2 12
2 2 12
2 2 12
end
I want to create a new variable sum_pr,
which equals to the sum of the first value within gender and period like below:
* Example generated by -dataex-. For more info, type help dataex
clear
input byte (gender period pr sum_pr)
1 1 11 26
1 1 11 26
1 1 11 26
1 2 15 26
1 2 15 26
1 2 15 26
2 1 11 23
2 1 11 23
2 1 11 23
2 2 12 23
2 2 12 23
2 2 12 23
end
How can I use Stata code to achieve it?
Thank you!
Related Posts with How to compute the sum of the first occurence within Group(s) in Stata?
t-valuesDear all, After running a regression in Stata, I export the result to an excel file by using the out…
What is the Test for Under-Dispersion in STATA?We are trying to fit a zero-weighted binomial model to our data set. The model is strongly supported…
SVY and MELOGITDear Statalisters, I am analysing longitudinal data in long format from a complex survey design. Th…
How to interpret "marginals" in case of the zero-weighted binomial model?How to interpret "marginals" in case of the zero-weighted binomial model? It may be noted that in t…
Comparing coefficients between nested and non-nested fixed effects regression modelsI am using panel data, and would like to evaluate whether coefficients from different fixed effects …
Subscribe to:
Post Comments (Atom)
0 Response to How to compute the sum of the first occurence within Group(s) in Stata?
Post a Comment