Hello,
I am struggling with a simple bit of summary statistics with panel data and wonder if someone can help.
I have a balanced panel data set with time variable: round (1, 2, 3), and panel variable: id (generated by egen group(householdID))
I have have a dummy variable: shock (1/0) , reported for each id for each round
I would like to count and produce a table that reports the percentage of households/unique ids that experience 0 shocks, 1 shock, 2 shocks and 3 shocks, across the 3 rounds (I do not care whether shocks are consecutive, e.g. a household experiencing a shock in rounds 1 & 3 only I would count as having '2 shocks').
Many thanks
Annie
Related Posts with Panel data 3 rounds: how do I count number of unique IDs for which a dummy=1 in none, one, two or all of the rounds
Measuring between and within group variance.I just came across an interesting analysis that reports between and within-group variance (of health…
Probit marginal effects: correct interpretation?I am running a regression of a binary variable (proficient in math or not) on education expenditure …
Limit the sample ID with even numbersHi everyone, I want to change my ID dataset to be limited to show only even number ID. Below is a sa…
Tabulating the variable's highest value and show the highest frequencyHello all, I am having difficulty of tabulating a variable that shows the highest frequency and the …
foreach VAR in Panel DataHi, I have an unbalanced panel dataset. I am looking to carry out Vector Autoregression (VAR) for e…
Subscribe to:
Post Comments (Atom)
0 Response to Panel data 3 rounds: how do I count number of unique IDs for which a dummy=1 in none, one, two or all of the rounds
Post a Comment