create sum of group of data

[Rodrigo Badilla]

Hi all,

I need create new variables : sum for pooled data, each independent of other.

Here i attach more detail of my original data and my desire results.

Thanks in advance.

Regard Rodrigo

[Nick Cox]

Your photo is unreadable, to me at least. I think you will get more readable results by attaching listings as code.

As earlier requested, please identify yourself using your full real name, which I guess to be Rodrigo Badilla.

[Roberto Ferrer]

Please use your full real name. Use the CONTACT US link to ask the administrators to change it.

Here's some code:

clear all
set more off

*------  example data -----

input ///
pred1 pred2 pred3
. . .
. 3 .
. 2 .
. . .
5 . .
7 . .
. . 4
. . 4
1 . .
3 . .
2 . .
end

list, sep(0)

*------ what you want -----

gen ord = _n
foreach v of varlist pred1-pred3 {

    * create a variable that flags each "group"
    gen `v'i = sum(!missing(`v') & missing(`v'[_n-1]))
    replace `v'i = 0 if missing(`v')
    
    * compute totals by group
    bysort `v'i: egen `v't = total(`v')
    drop `v'i // drop group variable
    
    * sort back to original order to work on next variable
    sort ord
}

drop ord
list, sep(0)

[Rodrigo Badilla]

Thanks Roberto for you reply, I made my request to change in my nick name.to administrators
regards

[Rodrigo Badilla]

Hi Roberto,

Your command work so fine!!, thanks for your command!

Regards

[Roberto Ferrer]

Glad it worked.

Thanks for soliciting a more adequate user name.