BJ Data Tech Solution

Specialized on Data processing, Data management Implementation plan, Data Collection tools - electronic and paper base, Data cleaning specifications, Data extraction, Data transformation, Data load, Analytical Datasets, and Data analysis. BJ Data Tech Solutions teaches on design and developing Electronic Data Collection Tools using CSPro, and STATA commands for data manipulation. Setting up Data Management systems using modern data technologies such as Relational Databases, C#, PHP and Android.

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
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

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

BJ Data Tech Solution

Home / Data Cleaning / Data management / Data Processing / 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
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

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

Home / Data Cleaning / Data management / Data Processing / 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 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

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

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