Hello,
I want to create a variable that shows the % of increase in care by household. Below, you can see the data. For the simplicity I colored the households and I only showed the child level increase of help and parent level increase of help. What I want is to find parent level increased help divided by the total number of increased help within that household. I am not sure how to do this simple calculation within the household. That would be really nice if anyone can help me.
mergeid parent_level_increased_help) % increase help (variable I want to construct)
"AT-001881-02" 1 50%
"AT-001881-02" 1 50%
"AT-002965-02" 0 0%
"AT-002965-02" 0 .
"AT-002965-02" 0 .
"AT-002965-02" 0
"AT-020460-02" 0
"AT-020460-02" 0
"AT-020460-02" 0
"AT-020460-02" 0
"AT-020975-02" 0
"AT-020975-02" 0
"AT-020975-02" 0
"AT-034810-02" 1
"AT-034810-02" 1
"AT-044265-02" 0
"AT-044265-02" 0
"AT-046816-02" 2
"AT-046816-02" 2
Thanks in advance!
Related Posts with calculating percentages by household id
unbalanced panel data with endogenous explanatory variable and some unobservable variablesHi All, I'm struggling with an equation that has an endogenous regressor (sample selection bias) and…
How to get conditional maximum dates and values?Hi all, I would like to find the largest % of institutional ownership for each deal, for example, f…
Stacked bar graph: percentage of total observations, by groupsHello, I would like to produce a graph that shows the percentage of total observations (code_7), ov…
Having problem reshaping my qualitative data for estimation of nested logitI have a dataset with 727 observation and 29 variables. The variables with biom and solar prefix are…
i am using panel datai am using panel data and if i run the analysis it shows me that the resul of one variable "Age of P…
Subscribe to:
Post Comments (Atom)
0 Response to calculating percentages by household id
Post a Comment